how to insert records using gridview control like updatd cancel...

Question

Hi every one

I have gridview control , now we can do update, cancel, delete records from the database using gridview control, bcoz those methods are appearing on the gridview control same way i want to insert data using gridview control

if any body please its urgent

prathi Atluri · Answer

This the one way were v can Insert the record protected void DetailsView1_ItemInserted(Object sender, System.Web.UI.WebControls.DetailsViewInsertedEventArgs e) { if (e.Exception != null ) { ErrorMessageLabel.Text = "An error occured while entering this record. Please verify you have entered data in the correct format."; e.ExceptionHandled = true ; } GridView1.DataBind(); } protected void DetailsView1_ItemUpdated(Object sender, System.Web.UI.WebControls.DetailsViewUpdatedEventArgs e) { GridView1.DataBind(); } protected void DropDownList1_SelectedIndexChanged( object sender, EventArgs e) { DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } protected void GridView1_SelectedIndexChanged( object sender, EventArgs e) { DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } protected void GridView1_PageIndexChanged( object sender, EventArgs e) { DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } protected void GridView1_RowDeleted( object sender, GridViewDeletedEventArgs e) { if (e.Exception != null ) { ErrorMessageLabel.Text = "Failed to DELETE due to foreign key contstraint on the table. You may only delete rows which have no related records."; e.ExceptionHandled = true ; } } protected void DetailsView1_DataBound( object sender, EventArgs e) { if (DetailsView1.CurrentMode == DetailsViewMode.Insert) { TextBox stateTextBox = (TextBox)DetailsView1.Rows[6].Cells[1].Controls[0]; stateTextBox.Text = DropDownList1.SelectedValue; stateTextBox.Enabled = false ; } }

how to insert records using gridview control like updatd cancel...

Answers (1)