how to updatedelete insert in datagridview windows base application in asp.net

Question

how to updatedelete  insert in datagridview windows base application in asp.net

Satyapriya Nayak · Answer

Hi Prem Windows app. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Update_delete_datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; OleDbCommandBuilder olcb; DataTable dataTable; BindingSource bindingSource; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = SELECT * FROM student; oledbda = new OleDbDataAdapter(str con); olcb = new OleDbCommandBuilder(oledbda); dataTable = new DataTable(); oledbda.Fill(dataTable); con.Close(); bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; dataGridView1.Columns[0].Visible = false; } private void btnaddupdate_Click(object sender EventArgs e) { try { oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show(Records updated); } private void btndelete_Click(object sender EventArgs e) { try { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show(Records Deleted); } } } Web apps Untitled Page DataKeyNames=VendorId AllowPaging=True CellPadding=3 OnPageIndexChanging=ResultGridView_PageIndexChanging OnRowDeleting=ResultGridView_RowDeleting OnRowEditing=ResultGridView_RowEditing OnRowUpdating=ResultGridView_RowUpdating OnRowCancelingEdit=ResultGridView_RowCancelingEdit PageSize=5 BackColor=#DEBA84 BorderColor=#DEBA84 BorderStyle=None BorderWidth=1px CellSpacing=2 OnRowCommand=ResultGridView_RowCommand AllowSorting=true onsorting=ResultGridView_Sorting> ReadOnly=True SortExpression=VendorId /> '> '> '> '> '> '> '> '> '> '> '> '> onclick=btn_search_Click /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; //SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); DataTable dataTable; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { Session[sortBy] = null; if (!IsPostBack) { FillVendorGrid(); } } private void FillVendorGrid() { SqlConnection conn = new SqlConnection(connStr); dataTable = new DataTable(); cmd.Connection = conn; cmd.CommandText = SELECT * FROM Vendor; ad = new SqlDataAdapter(cmd); ad.Fill(dataTable); ResultGridView.DataSource = dataTable; ResultGridView.DataBind(); } protected void ResultGridView_RowEditing(object sender GridViewEditEventArgs e) { ResultGridView.EditIndex = e.NewEditIndex; FillVendorGrid(); } protected void ResultGridView_PageIndexChanging(object sender GridViewPageEventArgs e) { ResultGridView.PageIndex = e.NewPageIndex; FillVendorGrid(); } protected void ResultGridView_RowDeleting(object sender GridViewDeleteEventArgs e) { SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = DELETE FROM Vendor WHERE VendorId=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); FillVendorGrid(); } protected void ResultGridView_RowUpdating(object sender GridViewUpdateEventArgs e) { TextBox txtFName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtFName); TextBox txtLName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtLName); TextBox txtCity = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtCity); TextBox txtState = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtState); TextBox txtCountry = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtCountry); TextBox txtDescription = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtDescription); SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = UPDATE Vendor SET VendorFName =' + txtFName.Text + 'VendorLName =' + txtLName.Text + 'VendorCity =' + txtCity.Text + 'VendorState =' + txtState.Text + 'VendorCountry =' + txtCountry.Text + 'VendorDescription =' + txtDescription.Text + ' WHERE VendorId=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '; conn.Open(); cmd.ExecuteNonQuery(); ResultGridView.EditIndex = -1; FillVendorGrid(); conn.Close(); } protected void ResultGridView_RowCancelingEdit(object sender GridViewCancelEditEventArgs e) { ResultGridView.EditIndex = -1; FillVendorGrid(); } protected void ResultGridView_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName.Equals(AddNew)) { TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl(txtFName1); TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl(txtLName1); TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl(txtCity1); TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl(txtState1); TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl(txtCountry1); TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl(txtDescription1); SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = INSERT INTO Vendor(VendorFName VendorLNameVendorCityVendorStateVendorCountryVendorDescription) Values(' + txtFName.Text + ' ' + txtLName.Text + ' ' + txtCity.Text + ' ' + txtState.Text + ' ' + txtCountry.Text + '  ' + txtDescription.Text + '); conn.Open(); cmd.ExecuteNonQuery(); FillVendorGrid(); conn.Close(); } } protected void btn_search_Click(object sender EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = select * from Vendor where VendorFName like ' + TextBox1.Text + %'; cmd = new SqlCommand(str conn); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds Vendor); conn.Close(); ResultGridView.DataSource = ds; ResultGridView.DataMember = Vendor; ResultGridView.DataBind(); } protected void ResultGridView_Sorting(object sender GridViewSortEventArgs e) { Session[sortBy] = e.SortExpression; FillVendorGrid(); } } Thanks If this post helps you mark it as answer

how to update,delete , insert in datagridview windows base application in asp.net