qtytotal cost gridview column not insert database

Question

protected void btnSubmit_Click(object sender EventArgs e) { foreach (GridViewRow g1 in GridView1.Rows) { SqlConnection con = new SqlConnection(ConStr); SqlCommand com = new SqlCommand(insert into tblTotal(Product_NameMRPSalon_CostQtyTotal_Cost) values (' + g1.Cells[0].Text + '' + g1.Cells[1].Text + '' + g1.Cells[2].Text + '' + g1.Cells[3].Text+ '' + g1.Cells[4].Text + ') con); con.Open(); com.ExecuteNonQuery(); con.Close(); } } this my code. the quantity and total cost enter the run time using jquery but the two column values not insert the database

Vincent Maverick Durano · Answer

The problem is with the Label control (Total_Cost). This is because the Label control is read-only means that you cannot overwrite the value from client side and expect to maintain its value across server postbacks. As a solution you would need to store the value of the total in HiddenField control so you can get the value in your code behind (sever). Here's a working example: ASPX: Grand Total: CODE BEHIND: protected void Button1_Click(object sender EventArgs e) { foreach (GridViewRow g1 in GridView1.Rows) { TextBox tbQty = (TextBox)g1.Cells[3].FindControl(Qty); HiddenField hidTotal = (HiddenField)g1.Cells[4].FindControl(hidTotal_Cost); using (SqlConnection connection = new SqlConnection(YOUR CONNECTION STRING HERE)) { string sql = INSERT INTO tblTotal (Product_NameMRPSalon_CostQtyTotal_Cost) VALUES (@PName@MRP@Cost@Qty@Total); using (SqlCommand cmd = new SqlCommand(sql connection)) { connection.Open(); cmd.Parameters.AddWithValue(@PName g1.Cells[0].Text); cmd.Parameters.AddWithValue(@MRP g1.Cells[1].Text); cmd.Parameters.AddWithValue(@Cost g1.Cells[2].Text); cmd.Parameters.AddWithValue(@Qty tbQty.Text); cmd.Parameters.AddWithValue(@Total hidTotal.Value); cmd.ExecuteNonQuery(); } } } } NOTE: Keep an eye on the highlighted changes above and it should work.

Vincent Maverick Durano · Answer

Did you add a HiddenField control and use that to access the control value? The code that i have provided should work because i tested it. Please refer again to the code i've posted and see those line in bold.

Vincent Maverick Durano · Answer

I would suggest you to create a separate thread for that topic so answers on this thread will not mixed up. Let me know the link of your thread so we can discuss there. Thank you.

Rubiya Rajamanickam · Answer

mmmm k sir i want another help send notification one user to another user like our C# corner notification... if you have any sample code

Vincent Maverick Durano · Answer

No problem. I'm glad to be of help. Just one favor. If your issue was resolved then please don't forget to close this thread by marking/accepting the reply which helps you as answer as reference to future readers. Thanks.

Rubiya Rajamanickam · Answer

mmmm thank you very much sir...........

Rubiya Rajamanickam · Answer

sir this code is insert always 0 not getting to insert given value....

Rubiya Rajamanickam · Answer

sir please reply fast how to solve this problem....

Vincent Maverick Durano · Answer

Give me a moment to open my dev machine so I can test on it. I'll get back to you. so hold on :)

Rubiya Rajamanickam · Answer

ya its perfectly correct sir...

Vincent Maverick Durano · Answer

Looks good to me. So let me re iterate the issue you are facing just to make sure I follow. Your jQuery calculation is working correctly and displays the calculated values in respective Label (Total_Cost). Right? Now your problem is once you click on a Button to insert the values of your Qty TextBox and Total Cost Label is empty? Correct?

Rubiya Rajamanickam · Answer

Grand Total: and this is my jquery code

Vincent Maverick Durano · Answer

Server controls render as regular old HTML input fields. As long as the input field is within a form element the data will makes it's way to the server. Again please post your GirdView HTML markup so we can have a look.

Rubiya Rajamanickam · Answer

yes sir... column name is correct but cannot take the text values.... add runtime total cost values using jquery code.... so this code affect gridview is possible????

Vincent Maverick Durano · Answer

are you sure you are referencing the correct columns to where your total and qty is located? can you post your GridView HTML markup here?

Rubiya Rajamanickam · Answer

there is no values to take qty and total textbox... why the textbox value cannot taken...

Vincent Maverick Durano · Answer

then you have to debug your code. Set a break point into that method and then step into your codes to figure out what went wrong. There's no way to figure out what happened without debugging it.

Rubiya Rajamanickam · Answer

No Error will come but its not inserting the database... other columns are working super but the two column are only not working...the values add the run time but not insert to database

Vincent Maverick Durano · Answer

What's not working? Are you getting error? What's the error? Also have you tried debugging your code? Set a break point into that method and then step into your codes to figure out what's going on.

Vincent Maverick Durano · Answer

What's not working? Are you getting error? What's the error? Also have you tried debugging your code? Set a break point into that method and then step into your codes to figure out what's going on.

Rubiya Rajamanickam · Answer

this code is not getting to insert database sir....

Vincent Maverick Durano · Answer

Your query is wrong and it's prone to SQL Injection attack. You should use fully qualified parameterize query. For example: foreach (GridViewRow g1 in GridView1.Rows) { TextBox tbQty= (TextBox)g1.Cells[3].FindControl(Qty); Label tbTotal = (Label)g1.Cells[4].FindControl(Total_Cost); using (SqlConnection connection = new SqlConnection(YOUR CONNECTION STRING HERE)) { string sql = INSERT INTO tblTotal (Product_NameMRPSalon_CostQtyTotal_Cost) VALUES (@PName@MRP@Cost@Qty@Total); using (SqlCommand cmd = new SqlCommand(sql connection)) { connection.Open(); cmd.Parameters.AddWithValue(@PName g1.Cells[0].Text); cmd.Parameters.AddWithValue(@MRP g1.Cells[1].Text); cmd.Parameters.AddWithValue(@Cost g1.Cells[2].Text); cmd.Parameters.AddWithValue(@Qty tbQty.Text); cmd.Parameters.AddWithValue(@Total tbTotal.Text); cmd.ExecuteNonQuery(); } } }

Rubiya Rajamanickam · Answer

i have to change my code but i got The parameterized query '(@Qty nvarchar(4000)@Total_Cost nvarchar(1))insert into tblTota' expects the parameter '@Qty' which was not supplied. this kind of error how can i solve

Vincent Maverick Durano · Answer

It's not working because your assigning the variable index to 0. When you set the cells index to 0 it will look into the first column of the GridView. You should set the exact value of index to properly reference a column. For example if your Total column is in the 5th column then you should use: g1.Cells[4].FindControl(YourControlID);

Rubiya Rajamanickam · Answer

please reply for this question....

Rubiya Rajamanickam · Answer

protected void btnSubmit_Click(object sender EventArgs e) { foreach (GridViewRow g1 in GridView1.Rows) { int index = 0; TextBox Qty = (TextBox)g1.Cells[index].FindControl(Qty); Label Total_Cost = (Label)g1.Cells[index].FindControl(Total_Cost); SqlConnection con = new SqlConnection(ConStr); SqlCommand com = new SqlCommand(insert into tblTotal(Product_NameMRPSalon_CostQtyTotal_Cost) values (' + g1.Cells[0].Text + '' + g1.Cells[1].Text + '' + g1.Cells[2].Text + '@Qty@Total_Cost) con); com.Parameters.AddWithValue(@Total_Cost Total_Cost.Text); com.Parameters.AddWithValue(@Qty Qty.Text); con.Open(); com.ExecuteNonQuery(); con.Close(); } } this code is not working ????

Vincent Maverick Durano · Answer

If you are displaying your Quantity and Total values in Label/TextBox control then you would need to use FindControl method to access its values from the code. Using g1.Cells[index].Text will only get the value from BoundField column. For TemplateField columns you would need to use FindControl method. For example: Label lblTotal = (Label)g1.Cells[index].FindControl( Total_Cost );

Rubiya Rajamanickam · Answer

there are insert only the 1st three column not getting to insert the qty and total cost column values

Manas Mohapatra · Answer

What is the issue exactly: Is it inserting only record with no data. Is is not inserting any record.

qty,total cost gridview column not insert database