Save temporary values in gridview to database

Unni R

11y1.4k.NET

I have one grid view , two text box ,two button and one drop down box , while am entering data to text box and drop down boxes (inside the grid view),that data want to store temporally in grid view after that data want to store in database.My code is attached here
public static DataTable dt;
static int C = 0;

protected void Buttonadd_Click(object sender, EventArgs e)
{
if (Session["Data"] == null)
{

C = 1;

dt = new DataTable();
DataRow dr = dt.NewRow();
dt.Columns.Add(new System.Data.DataColumn("EMPNAME", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("EMPID", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("DEPARTMENT", typeof(String)));
dr[0] = Txtaddname.Text;
dr[1] = Txtaddempid.Text;
dr[2] = Drpadddept.SelectedItem.Text;
dt.Rows.Add(dr);
GridView1.DataSource = dt;
GridView1.DataBind();
Session["Data"] = dt;

}
else
{
C = C + 1;

dt = new DataTable();
dt = (DataTable)Session["Data"];
DataRow dr = dt.NewRow();
dr[0] = Txtaddname.Text;
dr[1] = Txtaddempid.Text;
dr[2] = Drpadddept.SelectedItem.Text;
dt.Rows.Add(dr);
GridView1.DataSource = dt;
GridView1.DataBind();
Session.Remove("Data");
Session["Data"] = dt;

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Unni R11y ago
foreign key column vale is not working.its shows as NULL
0
Manoj Kumar Mandal11y ago
string strEMPNAME = GridView1.Rows[i].Cells[0].Text.ToString().Trim();
string strEMPID = GridView1.Rows[i].Cells[0].Text.ToString().Trim();
string strDEPARTMENT = GridView1.Rows[i].Cells[0].Text.ToString().Trim();
SqlCommand cmd = new SqlCommand("insert into MFIMSMASTERADDITION (EMPNAME,EMPID,DEPARTMENT) values('"+strEMPNAME+"','"+strEMPID+"','"+strDEPARTMENT+"' )", SC);

Use code like above and check whether you are getting values in those string variable.
Its always a best practive to store values in string rather than directly passing them as an argument.

One more thing i would like to say is that, It is not a good practice to hit your db for each and every row of grid. try to save them in a datatable(as you have already done that while populating your grid)
and send that datatable as a parameter to your procedure.

check link http://www.c-sharpcorner.com/UploadFile/b63684/the-prologue/ if you are using old versions like 2005 od sqlserver
check link http://www.c-sharpcorner.com/UploadFile/87b416/passing-datatable-to-storeprocedure-as-parameter-in-C-Sharp/ if you have db server like Sql Server 2014
0
Unni R11y ago
Data passing from grid view to database is ok.Now I have one another problem , I have two tables in this application, first table one column value set as primary key and second table one column value set as foreign key. while data inserting time, foreign key column value shows as NULL.My code attached here.. second table code public void fillgrid() { for (int i = 0; i < GridView1.Rows.Count; i++) { SqlConnection SC = new SqlConnection("sqlconnection"); SC.Open(); SqlCommand cmd = new SqlCommand("insert into MFIMSMASTERADDITION (EMPNAME,EMPID,DEPARTMENT) values('" + GridView1.Rows[i].Cells[0].Text.ToString().Trim() + "','" + GridView1.Rows[i].Cells[1].Text.ToString().Trim() + "','" + GridView1.Rows[i].Cells[2].Text.ToString().Trim() + "')", SC); cmd.ExecuteNonQuery(); SC.Close(); } first table code protected void Button1_Click(object sender, EventArgs e) { SqlConnection SC = new SqlConnection("sqlconnection"); SC.Open(); SqlCommand cmd = new SqlCommand("INSERTMFIMSMASTERSP", SC); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EMPNAME", txtname.Text); cmd.Parameters.AddWithValue("@EMPID", txteid.Text); cmd.Parameters.AddWithValue("@DEPARTMENT", drpdept.SelectedValue); cmd.Parameters.AddWithValue("@TITLE", Txttitle.Text); cmd.Parameters.AddWithValue("@CATEGORY", drpcatgry.SelectedValue); cmd.Parameters.AddWithValue("@OTHERDETAILS", txtothers.Text); cmd.Parameters.AddWithValue("@PRESENTSITUATION", TxtPresentSituation.Text); cmd.Parameters.AddWithValue("@IDEA", Txtidea.Text); cmd.Parameters.AddWithValue("@IMPROVE", Txtimprove.Text); cmd.Parameters.AddWithValue("@METRICSIMPROVE", drpmatrcs.SelectedValue); int m=cmd.ExecuteNonQuery(); if (m > 0) { fillgrid(); } Response.Write(""); txtname.Text = ""; txteid.Text = ""; Txtimprove.Text = ""; Txtidea.Text = ""; TxtPresentSituation.Text = ""; Txttitle.Text = ""; txtothers.Text = ""; drpdept.SelectedIndex = 0; drpcatgry.SelectedIndex = 0; drpmatrcs.SelectedIndex = 0; GridView1.DataSource = null; GridView1.DataBind(); Session.Clear(); SC.Close(); }
0
Manoj Kumar Mandal11y ago
Tell us whether you are facing problem in the code you are using to store data in temporary table or you want to know how you can send datatable to sqlprocedure ?
+1