Update gridview editable changes to dataset inturn to a sql table
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