|
If you would take a look at this article: http://www.codeproject.com/KB/grid/GenericGridView.aspx[^]">. You'll see it is not that hard to build.
|
|
|
|
|
Thanks a lot...Now sorting is happening in my gridview..but the problem is if i click on same column second time sorting is not happening...
on the first click it will sort as descending...and again i click on same column it should sort as ascending...but not happening...
but if i click any other column and come back to this its working fine...
what can be the reason?
|
|
|
|
|
Is your value for ascending/descending for the column stored in a session variable?
If not, than do so. When u see the page it is in disconnected state, so the website does not memorize the local variables only the session variables.
good luck
|
|
|
|
|
Sorry i didnt get u....
My code is here
Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles GridView1.Sorting
'Retrieve the name of the clicked column (sort expression)
Dim pageindex As Integer
pageindex = GridView1.PageIndex
Dim sortExpression As String = e.SortExpression
'Decide and save the new sort direction
If (sortExpression = e.SortExpression) Then
If gridSortDirection = SortDirection.Ascending Then
gridSortDirection = SortDirection.Descending
Else
gridSortDirection = SortDirection.Ascending
End If
Else
gridSortDirection = WebControls.SortDirection.Ascending
End If
Me.DsRefMaster1.Tables(Me.HdnProcessingTable.Value).DefaultView.Sort = sortExpression
Me.DvProcessing = Me.DsRefMaster1.Tables(Me.HdnProcessingTable.Value).DefaultView
UDF_SetMasterData()
UDF_SetGridData()
GridView1.PageIndex = pageindex
End Sub
Private Property gridSortDirection()
Get
'Initial state is Ascending
If (ViewState("GridSortDirection") Is Nothing) Then
ViewState("GridSortDirection") = SortDirection.Ascending
End If
'Return the state
Return ViewState("GridSortDirection")
End Get
Set(ByVal value)
ViewState("GridSortDirection") = value
End Set
End Property
|
|
|
|
|
Hi,
I am not a VB-code but a CSharpcoder (as a little warning)
You State: If (sortExpression = e.SortExpression) Then
How dus this check your ViewState("GridSortDirection") ?
|
|
|
|
|
I have put that gridSortDirection as private property na...check the second function...
Private Property gridSortDirection()
Get
'Initial state is Ascending
If (ViewState("GridSortDirection") Is Nothing) Then
ViewState("GridSortDirection") = SortDirection.Ascending
End If
'Return the state
Return ViewState("GridSortDirection")
End Get
Set(ByVal value)
ViewState("GridSortDirection") = value
End Set
End Property
|
|
|
|
|
If i click on the second time its giving an Error like this:
Sys.InvalidOperation Exception ScriptLoader.load script cannot be called while the script loader is already loading scrips
|
|
|
|
|
do you use the if Page.IsPostback Then construction?
If that is false only then you should call your property.
This is due to AJAX
also check your code:
If (sortExpression = e.SortExpression) Then
If gridSortDirection = SortDirection.Ascending Then
gridSortDirection = SortDirection.Descending
Else
gridSortDirection = SortDirection.Ascending
End If
Else
gridSortDirection = WebControls.SortDirection.Ascending
End If
what are the values in a debug of:
sortExpression, gridSortExpression
and what path does it run in the if sections?
|
|
|
|
|
this is my design code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login page.aspx.cs" Inherits="Login_page" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>WebForm1</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<!-- <summary>
||||| Style Sheet |||||
</summary>
--><link title="standard" href="Styles.css" type="text/css" rel="stylesheet">
</head>
<body>
<!-- ||||| Login Form ||||| -->
<form id="frmlogin" method="post" runat="server">
<table id="mainTable" border="0" style="left: 368px; position: relative; top: 177px">
<tr>
<td>
<table class="t_border" id="loginTable" cellspacing="15" cellpadding="0" style="left: -1px; position: relative; top: 12px">
<tr>
<td style="height: 24px"><b>Login: </b>
</td>
<td style="height: 24px"><asp:textbox id="txtUserName" runat="server" width="160px"></asp:textbox></td>
</tr>
<tr>
<td><b style="position: relative">Password: </b>
</td>
<td><asp:textbox id="txtPassword" runat="server" width="160px" textmode="Password"></asp:textbox></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="height: 21px; position: relative;">
<asp:Label ID="Label3" runat="server" Font-Size="Large" Style="left: 5px; position: relative;
top: -3px" Text="Selcet Center"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" style="left: 6px; position: relative; top: 1px">
<asp:ListItem>Select Type</asp:ListItem>
<asp:ListItem>Service Center</asp:ListItem>
<asp:ListItem>Call Center</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="height: 21px"><asp:Label ID="Label4" runat="server" Font-Size="Large" Text="Select Zone" style="left: 5px; position: relative; top: 0px" Width="97px"></asp:Label>
<asp:DropDownList ID="DropDownList2" runat="server" Width="111px" style="left: 5px; position: relative; top: -1px">
<asp:ListItem>Select Zone</asp:ListItem>
<asp:ListItem>West Zone</asp:ListItem>
<asp:ListItem>North Zone</asp:ListItem>
<asp:ListItem>South Zone</asp:ListItem>
<asp:ListItem>Other</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td align="center" colspan="2"><asp:button id="Button1" runat="server" text="Submit" borderstyle="Solid" OnClick="Button1_Click1"></asp:button></td>
</tr>
</table>
</form>
<asp:label id="lblMessage" runat="server" width="288px" font-bold="True" font-italic="True"
font-size="Medium" forecolor="#C00000" style="left: -2px; position: relative; top: 286px"></asp:label>
<asp:label id="lblMessage2" runat="server" width="288px" font-bold="True" font-italic="True"
font-size="Medium" forecolor="#C00000" style="left: -289px; position: relative; top: 259px"></asp:label>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TOSHIBA1ConnectionString %>"
SelectCommand="SELECT [First_Name], [LOGIN_Id], [Password] FROM [Users]"></asp:SqlDataSource>
<!-- ||||| End of Form ||||| -->
</body>
</html>
i am getting the error in the data base connection it showing that u have not initilize the data base connection
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Login_page : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
}
#region Web Form Designer generated code
#endregion
protected void Button1_Click1(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (DBConnection(txtUserName.Text, txtPassword.Text))
{
FormsAuthentication.RedirectFromLoginPage(txtUserName.Text, false);
Response.Redirect("wellcome.aspx");
}
else
{
lblMessage.Text = "Invalid Login, please try again!";
}
}
}
private bool DBConnection(string txtUser, string txtPass)
{
SqlConnection myConn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["<%$ ConnectionStrings:TOSHIBA1ConnectionString %>"]);
SqlCommand myCmd = new SqlCommand("sp_ValidateUser", myConn);
myCmd.CommandType = CommandType.StoredProcedure;
SqlParameter objParam1;
SqlParameter objParam2;
SqlParameter returnParam;
objParam1 = myCmd.Parameters.Add("[LOGIN_Id]", SqlDbType.VarChar);
objParam2 = myCmd.Parameters.Add ("[Password]", SqlDbType.VarChar);
returnParam = myCmd.Parameters.Add("[First_Name]", SqlDbType.VarChar);
objParam1.Direction = ParameterDirection.Input;
objParam2.Direction = ParameterDirection.Input;
returnParam.Direction = ParameterDirection.ReturnValue;
objParam1.Value = txtUser;
objParam2.Value = txtPass;
try
{
if (myConn.State.Equals(ConnectionState.Closed))
{
myConn.Open();
myCmd.ExecuteNonQuery();
}
if ((int)returnParam.Value < 1)
{
lblMessage.Text = "Invalid Login!";
return false;
}
else
{
myConn.Close();
return true;
}
}
catch (Exception ex)
{
lblMessage2.Text = ex + "Error Connecting to the database";
return false;
}
}
}
|
|
|
|
|
What line did you get your error on? Have you got a connection string in the config file?
|
|
|
|
|
Nothing understandable.  Please post properly
|
|
|
|
|
Go to your admissions office, hand them back your student ID and tell them you're too stupid to be on this course. Then go home stand in front of a mirror and repeat these lines 100 times "Would you like fries with that, Sir".
|
|
|
|
|
Just to add, it's idiots like you that are killing our industry, especially when you start taking jobs through sites like rentacoder and cause end users to assume that this level of cluelessness is what our industry is about. If this is not homework, but a paid job, then contact the client, tell them you were stealing from them, and return their deposit.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
...
"Well, we're getting "F"'d at work. WPF, WCF, and WWF... WTF?" --John Simmons
|
|
|
|
|
i have parent datagrid and a child datagrid nxt row of everydataitem. when i click the expand button in parent dg the child dg will be shown.
my problem is when i clicked edit button or any button in child datagrid my parent datagrid collapse. how can i maintain the expanded child datagrid?
this is my code snippet
<code><script type="text/javascript">
function expandcollapse(obj){
var div = document.getElementById(obj);
var img = document.getElementById('img' + obj);
if (div.style.display == "none"){
div.style.display = "block";
img.src = "images/collapse.gif";
img.alt = "Close to view sub menus";
}else{
div.style.display = "none";
img.src = "images/expand_blue.gif";
img.alt = "Expand to show sub menus";
}
}
</script>
<asp:datagrid id="grdMenu" runat="server" width="830px" autogeneratecolumns="False">
<columns>
<asp:templatecolumn headertext="Menu Title" sortexpression="mainmenuid">
<itemtemplate>
<asp:label id="lblmenutitle" runat="server" />
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn>
<itemtemplate>
<a href="javascript:expandcollapse('div<%# Eval(" mainmenuid=") %>');">
<img id="imgdiv<%# Eval(" mainmenuid=") %>" src="images/expand_blue.gif" /></a>
<tr><td colspan="100%">
<div id="div<%# Eval(" mainmenuid=") %>">
style="display:none;position:relative;left:25px;OVERFLOW: auto;WIDTH:98%;" >
<asp:datagrid id="grdSub" runat="server" autogeneratecolumns="False" cssclass="InputText" datakeyfield="mainmenuid" onpageindexchanged="ChangeIndex2" ondeletecommand="grdSub_DeleteCommand" onupdatecommand="grdSub_UpdateCommand" oneditcommand="grdSub_EditCommand" onsortcommand="grdSub_SortCommand" onitemdatabound="grdSub_ItemDataBound">
<columns>
<asp:templatecolumn headertext="SubmenuTitle">
<itemtemplate>
<asp:label id="lblparentid" runat="server" />
</itemtemplate>
</asp:templatecolumn> <asp:templatecolumn> <itemtemplate><asp:imagebutton id="ImageButton6" runat="server" imageurl="~/images/edit.gif" commandname="Edit" causesvalidation="false"></asp:imagebutton>
</itemtemplate></asp:templatecolumn>
</columns></asp:datagrid>
</div></td></tr></itemtemplate>
</asp:templatecolumn>
</columns></asp:datagrid></code>
thanks in advance.
|
|
|
|
|
Hi,
I am using the Infragistics calendar view control for displaying the booking activity...
I need to pass the date & time along with the parameter from the parent page to the child page.
Please help me in fetching the date & time through javascript and pass it as a parameter to the child window.
Thanks for your quick response.
Regards
Priya
|
|
|
|
|
Please guide me if any one have any solution.
|
|
|
|
|
I have a datagrid with AutoGenerateColumns="True". I also have 3 template columns in the datagrid. One with a checkbox for multiple selection of rows.
Now I need to iterate through the grid to know which are the rows selected.
But when I try to iterate like below:
foreach(DataGridItem i in grdResults.Items)
{
bool bChecked = ((CheckBox)i.FindControl("chkSelect")).Checked;
if(bChecked == true)
{
string locationTxt = ((TextBox)i.FindControl("txtLocation")).Text;
}
}
grdResults.Items gives "error: cannot obtain value"
I am not sure what is going wrong. I want to use autogeneratecolumns since the datasource is bound to ds.tables[2] and template columns since some of the data is bound to ds.tables[0] and tables[1].
Please help. Thanks in advance.
|
|
|
|
|
you better do a
foreach (Datarow row in grdResults.Rows)
you scan all the rows in the gridview.
than do a row.FindControl(). What you do now is checking each item and if the item is chkSelect. If it is not chkSelect you have a null reference. Only 1 item in each row is chkSelect, not all items in the grid can be chkSelect.
|
|
|
|
|
How to save an grid values in database (sql server 2005)at runtime..
Is there any link refer to me..
Thanx in advance..
|
|
|
|
|
|
|
No i dont want to edit,update,select command.For example if i am loading an xml file to the project during run time.that particular file details must stored in database automatically...
help me.
Thanx in advance.
|
|
|
|
|
in general you can export your xml data to sqlserver using SSIS(Integration Service)
but if you mean that your xml data binded to a grid and you want to insert these data into sqlserver from your grid, i think you can generate a datatable from your grid data, and then insert your datatable into sqlserver table completely.
|
|
|
|
|
for asp.net 2.0 What is difference between following methods for selecting XML data. which one is better interms of performace.
1) Dataset.select
2) dataview
3) xmlDocument.SelectNodes
4) xmlNavigator.select
modified on Monday, January 19, 2009 2:41 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
