How to retrieve values from gridview

Last post 06-26-2007 10:05 AM by ecbruck. 1 replies.

Sort Posts:

  • How to retrieve values from gridview

    06-26-2007, 6:07 AM
    • Member
      point Member
    • rojiin
    • Member since 06-26-2007, 9:35 AM
    • Posts 1
    While selecting a particular row in a gridview i want to retrieve those values to a textbox in the next aspx page.In my project i want to display all values in a gridview and after that if i selecting a particular employee i wanted his entire details to be displayed in corresponding textboxes in next aspx page.how can i able to do this.can anybody help me  to sort this problem.
  • Re: How to retrieve values from gridview

    06-26-2007, 10:05 AM
    • All-Star
      86,764 point All-Star
    • ecbruck
    • Member since 12-30-2005, 2:39 PM
    • Des Moines, IA
    • Posts 9,209
    • Moderator

    Sure, here's an example.

    PAGE 1 ASPX 

    <asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" datakeynames="ProductID"
    	datasourceid="SqlDataSource1">
    	<columns>
    		<asp:boundfield datafield="ProductID" headertext="ProductID" readonly="True" sortexpression="ProductID" />
    		<asp:boundfield datafield="Name" headertext="Name" sortexpression="Name" />
    		<asp:hyperlinkfield datanavigateurlfields="ProductID" datanavigateurlformatstring="1120691B.aspx?ProductID={0}"
    			text="View Product" />
    	</columns>
    </asp:gridview>
    <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:AdventureWorksConnectionString %>"
    	selectcommand="SELECT [ProductID], [Name] FROM [Production].[Product]">
    </asp:sqldatasource>

    PAGE 2 ASPX 

    <asp:detailsview id="DetailsView1" runat="server" datasourceid="SqlDataSource1">
    </asp:detailsview>
    <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:AdventureWorksConnectionString %>"
    	selectcommand="SELECT [ProductID], [Name] FROM [Production].[Product] WHERE ([ProductID] = @ProductID)">
    	<selectparameters>
    		<asp:querystringparameter name="ProductID" querystringfield="ProductID" type="Int32" />
    	</selectparameters>
    </asp:sqldatasource>
    Thanks, Ed

    Microsoft MVP - ASP/ASP.NET

Page 1 of 1 (2 items)