ASP.NET

using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
<br />
 private void Page_Load(object sender, System.EventArgs e)<br />
    {<br />
    }<br />
    public void BindData()<br />
    {<br />
        SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
        SqlCommand myCommand = new SqlCommand("PS_NV2", myConnection);<br />
        myCommand.CommandType = CommandType.StoredProcedure;<br />
        SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);<br />
        DataSet ds = new DataSet();<br />
        myAdapter.Fill(ds, "table");<br />
        myConnection.Open();<br />
        myCommand.ExecuteNonQuery();<br />
        GridView2.DataSource = ds;<br />
        try<br />
        {<br />
            GridView2.DataBind();<br />
        }<br />
        catch<br />
        {<br />
            GridView2.PageIndex = 0;<br />
            GridView2.DataBind();<br />
        }<br />
        myConnection.Close();<br />
<br />
    }<br />
    private string ConnectionString<br />
    {<br />
        get<br />
        {<br />
string connectionString = (@"Data Source=.\SQLEXPRESS;UID=sa;Password=**3*;Initial Catalog=mybd");<br />
<br />
            return connectionString;<br />
        }<br />
    }<br />
protected void GridView2_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)<br />
    {<br />
        Response.Write(e.NewSelectedIndex);    <br />
<br />
    }<br />
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)<br />
    {<br />
        GridViewRow row = GridView2.SelectedRow;<br />
<br />
        TextBox4.Text = row.Cells[2].Text;<br />
<br />
    }<br />
    protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)<br />
    {<br />
        GridView2.EditIndex = e.NewEditIndex;<br />
        BindData();<br />
    }<br />
<br />
    protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)<br />
    {<br />
        GridView2.EditIndex = -1;<br />
        BindData();<br />
    }<br />
<br />
<br />
    protected void Button1_Click1(object sender, EventArgs e)<br />
    {<br />
        BindData();<br />
        GridView2.Visible = true;<br />
    }<br />
}<br />

<asp:gridview id="GridView2" runat="server" allowpaging="True" autogeneratecolumns="False" xmlns:asp="#unknown"><br />
                         DataKeyNames="c1" OnRowCancelingEdit="GridView2_RowCancelingEdit"<br />
                         OnRowEditing="GridView2_RowEditing"  OnSelectedIndexChanged="GridView2_SelectedIndexChanged"<br />
                         OnSelectedIndexChanging="GridView2_SelectedIndexChanging" Style="left: -214px;<br />
                         position: relative; top: 82px"><br />
                         <selectedrowstyle backcolor="Yellow" /><br />
                         <columns><br />
                             <asp:templatefield headertext="c1"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id0" runat="server" text="<%# Bind("c1") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id01" runat="server" text="<%# Bind("c1") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <asp:templatefield headertext="c22"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id1" runat="server" text="<%# Bind("c2") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id11" runat="server" text="<%# Bind("c2") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <asp:templatefield headertext="c33"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id2" runat="server" text="<%# Bind("c3") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id21" runat="server" text="<%# Bind("c3") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <br />
                             <br />
                             <asp:commandfield showeditbutton="True" showselectbutton="True" /><br />
                         </columns><br />
                     </asp:gridview>