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 EmpIDEmpName 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(EmpIDEmpName)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

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