Click here to Skip to main content
15,886,689 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi.
I have a project in Asp.net that someone insert data into DB(Sqlserver) and when he wants to recall the latest inserted data(for this item i have written a strored procedure so i will use it in gridview) he has to press a button that a gridview to show them all.

in the gridview i would like to add my own template(because i have some items as well as Jquery Calendar which has to be added by myself) and bind it to server and select stored procedure to read it.so the code i have to read data from DB is in below:

C#
protected void Button2_Click(object sender, EventArgs e) 
    { 
        SqlDataReader dr = DataProvider.ExecuteDataReader("[dbo].[Get_LastIdHowzeEducationFinishDate_SP]", CommandType.StoredProcedure); 
        GridView1.DataSource = dr; 
 
 
        SqlDataReader dr2 = DataProvider.ExecuteDataReader("[dbo].[Get_LastIdHowzeEducationField_SP]", CommandType.StoredProcedure); 
        GridView1.DataSource = dr2; 
        GridView1.DataBind(); 
    } 

but i don't know why only one of them is shown (the second one )meanwhile i want to show some other data column inside gridview.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900