qty,total cost gridview column not insert database

Rubiya Rajamanickam

10y1.2k.NET

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_Name,MRP,Salon_Cost,Qty,Total_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

29 Replies

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

Vincent Maverick Durano10y ago
Accepted 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:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridViewCalc.aspx.cs" Inherits="WebFormDemo.GridViewCalc" %>

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_Name,MRP,Salon_Cost,Qty,Total_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.

+1
Vincent Maverick Durano10y ago
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.
0
Rubiya Rajamanickam10y ago
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
0
Vincent Maverick Durano10y ago
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.
0
Rubiya Rajamanickam10y ago
mmmm thank you very much sir...........
0
Vincent Maverick Durano10y ago
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".
+1
Rubiya Rajamanickam10y ago
sir this code is insert always 0 not getting to insert given value....
0
Rubiya Rajamanickam10y ago
sir please reply fast how to solve this problem....
0
Vincent Maverick Durano10y ago
Give me a moment to open my dev machine so I can test on it. I'll get back to you. so hold on :)
0
Rubiya Rajamanickam10y ago
ya its perfectly correct sir...
0
Vincent Maverick Durano10y ago
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?
0
Rubiya Rajamanickam10y ago

Grand Total:

and this is my jquery code
0
Vincent Maverick Durano10y ago
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.
0
Rubiya Rajamanickam10y ago
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????
0
Vincent Maverick Durano10y ago
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?
0
Rubiya Rajamanickam10y ago
there is no values to take qty and total textbox... why the textbox value cannot taken...
0
Vincent Maverick Durano10y ago
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.
0
Rubiya Rajamanickam10y ago
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
0
Vincent Maverick Durano10y ago
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.
0
Vincent Maverick Durano10y ago
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.
0
Rubiya Rajamanickam10y ago
this code is not getting to insert database sir....
0
Vincent Maverick Durano10y ago
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_Name,MRP,Salon_Cost,Qty,Total_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();
}
}
}

0
Rubiya Rajamanickam10y ago
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
0
Vincent Maverick Durano10y ago
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");
0
Rubiya Rajamanickam10y ago
please reply for this question....
0
Rubiya Rajamanickam10y ago
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_Name,MRP,Salon_Cost,Qty,Total_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 ????
0
Vincent Maverick Durano10y ago
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");
0
Rubiya Rajamanickam10y ago
there are insert only the 1st three column not getting to insert the qty and total cost column values
0
Manas Mohapatra10y ago
What is the issue exactly:

Is it inserting only record with no data.
Is is not inserting any record.
0