Update table from DataGridView using stored procedures.

Thank you everyone for the links.

I went with this solution for Update/Delete
http://www.dotnetsharepoint.com/2013/07/insert-update-delete-edit-in.html#.U0ZOp_mSzft

When the user adds new records in dataGridView, I'm using the following code in FormClosing event for inserting the data to SQL table.
using (conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("INSERT_ENTRIES", conn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@EmployeeName", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlParameter("@EntryDescr", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlParameter("@InsUserID", SqlDbType.NVarChar));

conn.Open();

foreach (DataGridViewRow row in gridDetailsView.Rows)
{
if (!row.IsNewRow)
{
if (string.IsNullOrEmpty(row.Cells[2].Value.ToString())) // Hidden column with Autonumber
{
cmd.Parameters["@Department"].Value = department;
cmd.Parameters["@EmployeeName"].Value = row.Cells[4].Value;
cmd.Parameters["@EntryDescr"].Value = row.Cells[5].Value;
cmd.Parameters["@InsUserID"].Value = System.Environment.UserName;

cmd.ExecuteNonQuery();
}
}
}
}

Thank you again for all the help.

Hi

        you can refer to these links given below.may be it will hepl u.

http://dotnetsridhar.blogspot.in/2012/04/datagridview-in-wndows-form.html

http://www.dotnetcurry.com/showarticle.aspx?ID=132

http://www.c-sharpcorner.com/uploadfile/kannagoud/insertupdatedelete-in-datagridview-using-linq-in-windows-forms/

Try this also
http://dotnetsridhar.blogspot.in/2012/04/datagridview-in-wndows-form.html

Try This Link
http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html



Thanks
Find Jobs