i need to know how to dynamically sort the column's data.i just placed a radgrid and dynamically binded through the following...
con = new SqlConnection("Data Source=ServerName;Initial Catalog=Databasename;User ID=sa;Password=*******");
con.Open();
cmd = new SqlCommand("select * from TableName where Department ='FieldName'", con);
reader = cmd.ExecuteReader();
RadGrid1.DataSource = reader;
RadGrid1.DataBind();
con.Close();
and i aslo enable the radgrid properties such as sorting , paging, auto generate columns, at the design time itself ...when i click on the column header at runtime .. it shows error like below..
Server Error in '/' Application.
Exception Details: System.InvalidOperationException: Invalid attempt to call FieldCount when reader is closed.
Source Error:
Stack Trace:
pls reply me quick...i i'm in urgent
con = new SqlConnection("Data Source=ServerName;Initial Catalog=Databasename;User ID=sa;Password=*******");
con.Open();
cmd = new SqlCommand("select * from TableName where Department ='FieldName'", con);
reader = cmd.ExecuteReader();
RadGrid1.DataSource = reader;
RadGrid1.DataBind();
con.Close();
and i aslo enable the radgrid properties such as sorting , paging, auto generate columns, at the design time itself ...when i click on the column header at runtime .. it shows error like below..
Server Error in '/' Application.
Invalid attempt to call FieldCount when reader is closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Invalid attempt to call FieldCount when reader is closed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
|
pls reply me quick...i i'm in urgent
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 11 Feb 2013, 10:56 AM
Hi,
The most appropriate place to close the DataReader and the connection is in the DataBound event handler of the grid, as shown below. Please take a look into the sample code snippet I treid.
ASPX:
C#:
Please check this documentation for more details.
Thanks,
Shinu.
The most appropriate place to close the DataReader and the connection is in the DataBound event handler of the grid, as shown below. Please take a look into the sample code snippet I treid.
ASPX:
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowFilteringByColumn="true" AllowSorting="true" CellSpacing="0" GridLines="None" PageSize="10"> <MasterTableView AutoGenerateColumns="true" DataKeyNames="CustomerID"> </MasterTableView></telerik:RadGrid>C#:
SqlDataReader reader;SqlConnection conn;protected void RadGrid1_NeedDataSource1(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e){ RadGrid1.DataSource = ReadRecords("SELECT CustomerID, CompanyName, ContactName FROM Customers");}private SqlDataReader ReadRecords(string query){ String ConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString; conn = new SqlConnection(ConnString); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); reader = cmd.ExecuteReader(); return reader;}protected void RadGrid1_DataBound(object sender, System.EventArgs e){ reader.Close(); conn.Close();}Please check this documentation for more details.
Thanks,
Shinu.