Click here to Skip to main content
12,357,929 members (70,355 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET Gridview
Here is my .aspx page
<form id="form1"  runat="server">
    <div>
    <asp:GridView ID="GV" runat="server"  AutoGenerateColumns="false">
    <Columns>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate >
    <asp:TextBox ID="txtName" runat="server" Text='<%#Eval("Name") %>'></asp:TextBox>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:BoundField DataField="EmailId" HeaderText="Email" />
    </Columns>
    </asp:GridView>
    
    </div>
    <asp:Button ID="btnSave" runat="server" Text="Save" />
  
    </form>
Now i am binding it from code behind on page load as given below
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
       If Page.IsPostBack Then
 
           Dim str As String = ConfigurationManager.AppSettings("DBConn")
           Dim Conn As New SqlConnection(str)
           Conn.Open()
           Dim qry As String = "SELECT * FROM dbo.Employee"
           Dim adp As New SqlDataAdapter(qry, Conn)
           Dim ds As New DataSet
           adp.Fill(ds)
 
           GV.DataSource = ds
           GV.DataBind()
 
       End If
   End Sub

Now I have textbox as a editable field and user will make the changes to those textboxes

and What i want is after click of a save button those changes to be updated in dataset and further in sql Employee table

Without any kind of loop

Please suggest
Posted 12-Nov-12 6:06am
Comments
Amol_Joshi 13-Nov-12 0:36am
   
Anybody with hint

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160621.1 | Last Updated 12 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100