Save temporary values in gridview to database

Question

Hi. I have a code herewhere it will store temporary data in a gridview from textbox where when the data is stored temporarily in gridview. Alternatelyit will be linked to search the word in google. Now i want to save the values in the gridview to database. Any ideas guys? Here is my .aspx code: body > div > table > tr > td class = style1 > asp:Label ID = Label1 runat = server Text = Caller Info : > / asp:Label > / td > td style = width: 100px > asp:TextBox ID = TxtName runat = server class = cls onekeypress =  ToolTip = Press Enter key for new input > / asp:TextBox > / td > / tr > / table > asp:Button ID = BtnAddToTable runat = server align = right class = cls Text = Add OnClick = BtnAddToTable_Click / > asp:GridView ID = GridView1 runat = server AutoGenerateColumns = False > Columns > asp:TemplateField HeaderText = Caller Information > ItemTemplate > a onclick =' document.getElementById( ).src = this.href; return false;' href =' http://www.google.com/#q= ' > #DataBinder.Eval(Container.DataItem  name ) %> / a > / ItemTemplate > / asp:TemplateField > asp:TemplateField HeaderText =  > ItemTemplate > asp:Button ID = BtnDelete runat = server Text = Clear OnClick = BtnDelete_Click / > / ItemTemplate > / asp:TemplateField > / Columns > / asp:GridView > iframe runat = server id = iframe1 src =  class = cls style = z-index: 105; left: 225px; position: absolute; top: 109px; width: 875px; height: 455px; frameborder = 1 title = Google Search Display > / iframe > / div > asp:Button ID = BtnSendToDatabase runat = server class = cls Text = //Sent to database OnClick = BtnSendToDatabase_Click / > / body > And this is my .cs code: static DataTable dt; protected void Page_Load( object sender EventArgs e) { { if (!Page.IsPostBack) { // Instantiating the DataTable; dt = new DataTable(  Table1 ); // Adding Columns dt.Columns.Add(  name  typeof ( string )); } } } protected void BtnAddToTable_Click( object sender EventArgs e) { dt.Rows.Add(TxtName.Text); BindData(); TxtName.Text = String .Empty; } public void BindData() { GridView1.DataSource = dt; GridView1.DataBind(); } protected void BtnDelete_Click( object sender EventArgs e) { string sid = string .Empty; string sname = string .Empty; Button cb = sender as Button; GridViewRow grow = (GridViewRow)cb.NamingContainer; dt.Rows.RemoveAt(grow.RowIndex); BindData(); }

Manikavelu Velayutham · Answer

Below code will save the values in single column protected void BtnSendToDatabase_Click( object sender EventArgs e) { string strId = string .Empty; for ( int count = 0; count { strId = strId + dt.Rows[count][0].ToString() +   ; } SqlConnection conn = new SqlConnection (); conn.ConnectionString = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlCommand cmd = new SqlCommand (); cmd.CommandText = INSERT INTO Table1 (Company_Name) VALUES (' + strId + ') ; cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }

Manikavelu Velayutham · Answer

Finally got a solution for your problem Replace your code for (int count = 0; count { //you can get the bound filed values like string strId = GridView1.Rows[count].Cells[0].Text; With this code for ( int count = 0; count { //you can get the bound filed values like string strId = dt.Rows[count][0].ToString(); Its working fine. Hope this answer will be a accepted one.

Manikavelu Velayutham · Answer

OnClick of the save button you need to loop through the datagrid items find the textbox control in each row of the grid get the values ans store it in the database. You can do it in two ways. 1. While looping the rows in gridview each and everytime it will hit the database to store the row by row value. You can do this way. protected void Button1_Click( object sender EventArgs e) { for ( int count = 0; count { //you can get the bound filed values like string strId = GridView1.Rows[count].Cell[0].Text; //to get the template field value TextBox tx1 = (TextBox)GridView1.Rows[count].FindControl( txt1 ); string str1 = tx1.Text; //you can insert the values here } } 2. If you want to optimize it you can store the values as an xml and finally you can do an update to the database.

Manikavelu Velayutham · Answer

Problem Is Here TextBox TxtName = (TextBox)GridView1.Rows[count].FindControl(TxtName); if (TxtName != null) { string str1 = TxtName.Text; } else { string str1 = ; } In the above code you are declared the string variable in side the IF condition. Just declare it outside and store the value. It will work. Replace your code like below. string str1 = string.Empty; if (TxtName != null) { str1 = TxtName.Text; }

Manikavelu Velayutham · Answer

This error tells you that textbox is not found on that row you just need to check for null condition before getting its value if ( TxtName!=null) string str1 = TxtName.Text; else string str1 = ;

Manikavelu Velayutham · Answer

Replace this line -->string strId = GridView1.Rows[count].Cell[0].Text; by --> string strId = GridView1.Rows[count]. Cells [0].Text; Spelling mistake occured in that line. Its actually Cells[0] and not Cell[0].

Pratham Dave · Answer

Thanks you very much good contribution keep it up...

sam · Answer

Thank you so much. You helped me a lot. I appreciate it.

sam · Answer

Yaits working now..is it possible to save all the gridview values into one colums? Lets saythere are 5 cells of valuesi want all that 5 values to be stored in one column of Company_Name.

sam · Answer

Hi. I tried test and change the codebut i cant find the solution. I have uploaded my source code here. There's some textboxes in the code.Is it we have to add in the same method to save the the textbox values into database as how we want to save the temporary values?Or we have to do a seperate code to save the textbox values together with the temporary gridview values?

Manikavelu Velayutham · Answer

What happened still if your problem not solved can you zip your entire project and upload it here so that i can easily debug and tell whats the problem there.

Manikavelu Velayutham · Answer

Before clicking the save button just right click and see the view source of the page. Check whether the gridview has the saved values in it. If its not there surely it will save the empty values. If its there then check in which row and in which column the value exists. based on that change your code.

sam · Answer

Hi. Its still saving an empty value. I even tried modify and play with the count code.

sam · Answer

Noi checkedbut it still the same..when i enter >1 value in gridview columnit shows error because its saving an empty value-which is saving duplicate value.

Manikavelu Velayutham · Answer

Got the solution ?

Manikavelu Velayutham · Answer

string strId = GridView1.Rows[count].Cells[0].Text--> put a break point here & watch the value come here. If its empty then you need to check the next cells of the gridview. In Quick Watch you can easily look into the next cell value.

sam · Answer

Hi. When i use strIdit saves an empty value in database. I tried it before.

Manikavelu Velayutham · Answer

This code will work. string strId = GridView1.Rows[count].Cells[0].Text; --> This line is used to take the stored values from each row of the grid SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.CommandText = INSERT INTO Table1 (Company_Name) VALUES (' + strId + '); cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); I thought the textbox is inside the grid thats why given you the below line of codes. As per your requirements remove the below lines. TextBox TxtName = (TextBox)GridView1.Rows[count].FindControl(TxtName); if (TxtName != null) { string str1 = TxtName.Text; } else { string str1 = ; }

sam · Answer

I have a TxtName textbox outside the gridview. When i click the button addthe values will be added temporarily in gridview. Do you meani have to add another textbox in the gridview to capture values from TxtName textboxwhich is outside the gridview?

Manikavelu Velayutham · Answer

Yes the written code will execute like that only

sam · Answer

Do you mean that the values are captured from textbox to store into database?

Manikavelu Velayutham · Answer

TextBox TxtName = (TextBox)GridView1.Rows[count].FindControl(TxtName); I dont find the textbox named TxtName inside your gridview. Becuase of that empty strings are stored in the database. Make sure that TextBox is present inside the gridview.

sam · Answer

Ok..now when i click the button save to databaseno errors. But when i check in databaseit saves an empty value.The value in the gridview is not stored in the database.

sam · Answer

Here's my entire codei use my code behind as a script in aspx page. ..:: Temporary data store ::.. src=http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js> $(function() { $('input:text:first').focus(); var $inp = $('.cls'); $inp.bind('keydown' function(e) { //var key = (e.keyCode ? e.keyCode : e.charCode); var key = e.which; if (key == 13) { document.getElementById('btnSearch').click(); } }); }); static DataTable dt; protected void Page_Load(object sender EventArgs e) { { if (!Page.IsPostBack) { //Instantiating the DataTable; dt = new DataTable(Table1); //Adding Columns dt.Columns.Add(name typeof(string)); } } } protected void BtnAddToTable_Click(object sender EventArgs e) { dt.Rows.Add(TxtName.Text); // InsertIntoDatabase(TxtName.Text); BindData(); TxtName.Text = String.Empty; } public void BindData() { GridView1.DataSource = dt; GridView1.DataBind(); } protected void BtnDelete_Click(object sender EventArgs e) { string sid = string.Empty; string sname = string.Empty; Button cb = sender as Button; GridViewRow grow = (GridViewRow)cb.NamingContainer; dt.Rows.RemoveAt(grow.RowIndex); BindData(); } protected void BtnSendToDatabase_Click(object sender EventArgs e) { for (int count = 0; count { //you can get the bound filed values like string strId = GridView1.Rows[count].Cells[0].Text; //to get the template field value TextBox TxtName = (TextBox)GridView1.Rows[count].FindControl(TxtName); if (TxtName != null) { string str1 = TxtName.Text; } else { string str1 = ; } //you can insert the values here SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.CommandText = INSERT INTO Table1 (Company_Name) VALUES (' + strId + '); cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } var currentTime = new Date(); var month = currentTime.getMonth() + 1; var day = currentTime.getDate(); var year = currentTime.getFullYear(); document.forms[0].date_stamp.value = day + / + month + / + year ; //--> Text=Add OnClick=BtnAddToTable_Click /> ).src = this.href; return false;' href='http://www.google.com/#q= '> style=z-index: 105; left: 225px; position: absolute; top: 109px; width: 875px; height: 455px; frameborder=1 title=Google Search Display >

Manikavelu Velayutham · Answer

can you copy paste the entire code so that i can provide you the exact solution for it.

sam · Answer

Yai'm using the database code within the for loop. How to declare it globally? When i declare the str1 code outside the for loopit shows error.

Manikavelu Velayutham · Answer

Good to hear that my code solved one of your problem but you didnt marked it as answered. This error shows you that str1 is not accessible since it was declared inside the for loop. Make sure you are using the above database code within the for loop and not outside of the for loop str1 --> Check it out whether this variable is declared within any loop. If you want to use this variable through out the page. Just declare it globally.

sam · Answer

Ok..that solved one problem. Now i'm using this code to save to database : SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.CommandText = INSERT INTO Table1 (Company_Name) VALUES (' + str1 + ');//shows error that str1 cannot be found in this context cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); But it shows compilation error as i comment above in the code. When i use strIdit saves an empty data. Is my method correct?

sam · Answer

Hi. Now i m getting another error when i click the button to save to database : Object reference not set to an instance of an object. string str1 = TxtName.Text; Troubleshooting tips in VS2008 shows: use the new keyword to create an object instance; check to determine if the object is null before calling the method. Even when i'm doin another function such as to get username in textboxi'm getting this error.And i'm unable to solve this error. Do you knowwhat causes this error?

sam · Answer

Hi. I'm getting error when i apply the code. It shows as compilation error : CS1061: 'System.Web.UI.WebControls.GridViewRow' does not contain a definition for 'Cell' and no extension method 'Cell' accepting a first argument of type 'System.Web.UI.WebControls.GridViewRow' could be found (are you missing a using directive or an assembly reference?) do i need to do any assembly code addings?

Manikavelu Velayutham · Answer

Connect to the database and update the values

sam · Answer

what you mean by insert the values here in the code?can you elaborate more?i dont get yousorry..