How to write Insert Update Delete Operations Mannually s

[Shailesh]

Hi,
        I want to write code snippet mannually for rad grid's insert update delete oprations. I have usercontrol and in aspx page i have used sqldatasource, but I dont want to use atuomatic facility of rad grid. So I want to know how to do database oprations through code behind. What would be the commands or events I need to complete it.
Dose any one give me example to write all the things manully at codebehind file. I am using Sql server 2008. So i want to know how to write the code to perform the oprations. If possible please give me example.

Kindly help me as early as possible.

[Princy]

Hello,

Try the following code.
aspx:

<telerik:RadGrid ID="rdgdr1" runat="server" AutoGenerateColumns="false" onneeddatasource="rdgdr1_NeedDataSource" ondeletecommand="rdgdr1_DeleteCommand" oninsertcommand="rdgdr1_InsertCommand" onupdatecommand="rdgdr1_UpdateCommand" AllowAutomaticUpdates="true">
 <MasterTableView DataKeyNames="OrderID" CommandItemDisplay="top" EditMode="InPlace">
  <Columns>
    <telerik:GridButtonColumn UniqueName="delete" Text="delete" CommandName="delete"></telerik:GridButtonColumn>
    <telerik:GridBoundColumn UniqueName="OrderID" DataField="OrderID" HeaderText="OrderID"></telerik:GridBoundColumn>
    <telerik:GridBoundColumn UniqueName="EmployeeID" DataField="EmployeeID" HeaderText="EmployeeID"></telerik:GridBoundColumn>
    <telerik:GridEditCommandColumn UniqueName="edit" ButtonType="PushButton" HeaderText="edit" ></telerik:GridEditCommandColumn>
   </Columns>
 </MasterTableView>
</telerik:RadGrid>

C#:

public static string connection = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connection);
public SqlCommand SqlCommand = new SqlCommand();
protected void rdgdr1_UpdateCommand(object sender, GridCommandEventArgs e)
{
 conn.Open();
 GridEditableItem editItem = (GridEditableItem)e.Item;
 string orderId = editItem.OwnerTableView.DataKeyValues[editItem.ItemIndex]["OrderID"].ToString();
 string OrderId = (editItem["OrderID"].Controls[0] as TextBox).Text;
 string EmployeeID = (editItem["EmployeeID"].Controls[0] as TextBox).Text;
 string updateQuery = "Update Orders set EmployeeID='" + EmployeeID + "' where OrderID='" + OrderId + "'";
 SqlCommand.CommandText = updateQuery;
 SqlCommand.Connection = conn;
 SqlCommand.ExecuteNonQuery();
 conn.Close();
}
protected void rdgdr1_DeleteCommand(object sender, GridCommandEventArgs e)
{
 conn.Open();
 GridDataItem editItem = (GridDataItem)e.Item;
 string orderID = editItem.OwnerTableView.DataKeyValues[editItem.ItemIndex]["OrderID"].ToString();
 string delQuery="delete from orders where OrderID='"+orderID+"'";
 SqlCommand.CommandText = delQuery;
 SqlCommand.Connection = conn;
 SqlCommand.ExecuteNonQuery();
 conn.Close();
}
protected void rdgdr1_InsertCommand(object sender, GridCommandEventArgs e)
{
 conn.Open();
 GridEditableItem editItem = (GridEditableItem)e.Item;
 string OrderId = (editItem["OrderID"].Controls[0] as TextBox).Text;
 string EmployeeID = (editItem["EmployeeID"].Controls[0] as TextBox).Text;
 string insertQuery = "insert into Orders (OrderID,EmployeeID) values ('" + OrderId + "','" + EmployeeID + "')";
 SqlCommand.CommandText = insertQuery;
 SqlCommand.Connection = conn;
 SqlCommand.ExecuteNonQuery();
 conn.Close();
}

Thanks,
Princy.