Click here to Skip to main content
Rate this: bad
good
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 7:06am
Comments
Amol_Joshi at 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
0 OriginalGriff 5,170
1 DamithSL 4,357
2 Maciej Los 3,750
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,851


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 12 Nov 2012
Copyright © CodeProject, 1999-2014
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