edit a radgrid column

[Satya]

hi
 this is satya  the following is my requirement please help me
i  have  radgrid in my page
in that  radgrid one column is editable column for this i use  radgrid item templet
under the radgrid  one  button
 first i edit some rows in the  grid and click the  button 
then the changes  are saved in  database

[Shinu]

Hello Satya,

You can use the following code to achieve the scenario.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" >
            <MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
                AllowMultiColumnSorting="true" EnableHeaderContextMenu="true">
                <Columns>
                    <telerik:GridBoundColumn DataField="name" HeaderText="name"
                        UniqueName="name">
                    </telerik:GridBoundColumn>
                   <telerik:GridTemplateColumn UniqueName="Password1" HeaderText="id">
                     <ItemTemplate>
                      <asp:TextBox ID="txt1" runat="server" Text='<%# Eval("id")%>'>
                     </asp:TextBox>
                    </ItemTemplate>
                 </telerik:GridTemplateColumn>
           </Columns>
      </MasterTableView>
</telerik:RadGrid>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="click" />

C#:

protected void Button1_Click(object sender, EventArgs e)
  {
      SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString());
      foreach (GridDataItem grdItem in RadGrid1.Items)
     {
         String val=grdItem["name"].Text;
         TextBox txt = (TextBox)grdItem.FindControl("txt1");
     String data = txt.Text;
         con.Open();
         String s = "update test set id='" + data + "' where name='" + val + "'";
         SqlCommand cmd = new SqlCommand(s, con);
         cmd.ExecuteNonQuery();
         con.Close();
     }
  }

Thanks,
Shinu.