how to do crud with rad grid using in built grid properties
AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticInserts="true"
Thanks.

Question

how to do crud with rad grid using in built grid properties AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticInserts="true" Thanks.

Dorababu Meka · Answer

This is my code as per your requirement AllowAutomaticInserts="True" Width="97%" PageSize="10" AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" OnDataBound="RadGrid1_DataBound" OnItemCreated="RadGrid1_ItemCreated" OnNeedDataSource="RadGrid1_NeedDataSource" OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand"> HorizontalAlign="NotSet" AutoGenerateColumns="False"> ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"> UniqueName="EmpID" Visible="False"> UniqueName="EmpName"> Width="100%" /> UniqueName="EditCommandColumn1" CancelText="Cancel edit"> Code behind protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); MySqlCommand cmd = new MySqlCommand("Select EmpID,EmpName from tblemp", con); con.Open(); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); RadGrid1.DataSource = ds; } protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = (GridEditableItem)e.Item; String id = item.GetDataKeyValue("EmpID").ToString(); MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); TextBox txtbox = item["EmpName"].Controls[0] as TextBox; con.Open(); MySqlCommand cmd = new MySqlCommand("update tblemp set EmpName='" + txtbox.Text + "' where EmpID='" + id + "'", con); cmd.ExecuteNonQuery(); RadGrid1.AllowAutomaticUpdates = false; RadGrid1.Rebind(); } protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; GridEditableItem insertedItem = e.Item.OwnerTableView.GetInsertItem(); GridEditFormItem editFormItem = insertedItem as GridEditFormItem; TextBox txtbox = item["EmpName"].Controls[0] as TextBox; MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); con.Open(); MySqlCommand cmd = new MySqlCommand("insert into tblemp(EmpID,EmpName)values(2001,'" + txtbox.Text + "')", con); cmd.ExecuteNonQuery(); RadGrid1.AllowAutomaticInserts = false; }

Dorababu Meka · Answer

I didn't find any wrong in that statement I also write as follows TextBox txtbox = item["Name"].Controls[0] as TextBox; // to find the Name on update or insert

nallya · Answer

The Design page is: GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" Width="700px" OnNeedDataSource="RadGrid1_NeedDataSource" ondeletecommand="gv1_DeleteCommand" oninsertcommand="gv1_InsertCommand" onupdatecommand="gv1_UpdateCommand"> CaptionDataField="ID"> Height="110px" Width="100%" /> Code behind page is: namespace Telerik { public partial class WebForm4 : System.Web.UI.Page { Entity ent = new Entity(); protected void Page_Load(object sender, EventArgs e) { BindGrid(); } protected void gv1_NeedDataSource(object sender, Web.UI.GridNeedDataSourceEventArgs e) { BindGrid(); } public void BindGrid() { var query5 = from employee in ent.EMPLOYEEs select new { ID = employee.ID, NAME = employee.NAME, ADDRESS = employee.ADDRESS, DEPTID = employee.DEPTID }; gv1.DataSource = query5; } protected void gv1_DeleteCommand(object sender, GridCommandEventArgs e) { GridDataItem dataItem = (GridDataItem)e.Item; int id = Convert.ToInt32(dataItem.GetDataKeyValue("ID")); ent.Delete_emp(id); ent.SaveChanges(); } protected void gv1_InsertCommand(object sender, GridCommandEventArgs e) { GridEditFormInsertItem dataItem = (GridEditFormInsertItem)e.Item; string Name = (dataItem["Name"].Controls[0] as TextBox).Text; string Address = (dataItem["Address"].Controls[0] as TextBox).Text; int DeptID = Convert.ToInt32((dataItem["Deptid"].Controls[0] as TextBox).Text); ent.Insert_emp(Name, Address, DeptID); ent.SaveChanges(); } protected void gv1_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; int ID = Convert.ToInt32((editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"])); string Name = (editedItem["Name"].Controls[0] as TextBox).Text; string Address = (editedItem["Address"].Controls[0] as TextBox).Text; int DeptID = Convert.ToInt32((editedItem["DeptID"].Controls[0] as TextBox).Text); ent.Update_emp(ID, Name, Address, DeptID); ent.SaveChanges(); } } } gining Error at line : string Name = (editedItem["Name"].Controls[0] as TextBox).Text; Error:Cannot find cell bound to column with unique name 'Name'. Thanks

Dorababu Meka · Answer

Have you checked this one from telerik http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/alleditablecolumns/defaultcs.aspx http://www.telerik.com/community/code-library/aspnet-ajax/grid/manual-insert-update-delete-operations-using-auto-generated-editform-with-sql-statements-from-the-code-behind.aspx