edit field in gridview control

i more question at the end.. how to get the total of "ALL" the products of cart in the label "Total" ??
 
 
 

sorry kirtan....
i 4got 2 remove old code.... ur trick worked
 
thanks soooooooooooooooooo much

to kirtan:
same prblm
when
price=1000 qnt=1 and when set qty=2 , price becomes 2000 as per the qty*price equation..
now qty is 2 and price =2000
bt what when qty changes from 2 to 1 then
it qty*price=1*2000 = 2000?? and also when qty set=3 it wil do 2000*3
 
i am confused.. any one can tell me.. how to solve this??

to Kirtan 
good suggession ..
so query for sqldatasource should be like this way?
select purl, code, pname, price, qty, (qty*price)as tot from product
 
i am trying ur suggession
 

to Roei Bar
 
i did as u said.. it works well bt only once
becoz
>>>> when
price=1000 qnt=1 and when set qty=2 , price becomes 2000 as per the qty*price equation..
now qty is 2 and price =2000
bt what when qty changes from 2 to 1 then
it qty*price=1*2000 = 2000?? and also when qty set=3 it wil do 2000*3
 
i am confused.. any one can tell me.. how to solve this??

In windows forms, using DataGridView is easy to achieve this kind of function.
But not sure with GridView in Asp.net. Maybe Ajax can help you?
he he..
 

For the part you have commented I suggest this.
// comm.Parameters.AddWithValue("@price",Convert.ToDouble(newprice.ToString()));

comm.Parameters.Add( "@price", SqlDbType.Decimal).Value = Convert.ToDouble(newprice.ToString());

bt i want the price to be updated by it self..
suppose if anyone have add "item1" of price Rs 500,
then when user update qnty as 2 then price should be updated by itself as
newprice=qty*price that measn 500*2=1000

and again when user change qnty from 2 to one then it should be 1000/2 and so on...

you can do it in 2 different ways, you can either update the price in the Item_DataBound by doing this

System.Web.UI.WebControls.Label LblPrice;
Label3 = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("lblprice");

System.Web.UI.WebControls.TextBox _txtQuantity;
Label3 = (System.Web.UI.WebControls.Textbox)GridView1.Rows[e.RowIndex].FindControl("Quantity");

and then

LblPrice.Text =(int.parse(txtQuantity.Te) * float.parse(LblPrice.Text)).ToString();

or you can go to the db with the items and quantity and have it return the prices 
per each item by quantity.

What's the problem with your current code? Why not add one more code with "AddWithValue" to update the price column. Note you may need to caluclate the price based on the quatitiy...
 

  Hi Friend,

 name of texbox is "txtPrice"  so find control with that name :-) simple !! :)

below is corrected code :) chek it out :) if any problem ancounters let me know i will asssist you :-)

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
System.Web.UI.WebControls.TextBox TextBox1;
TextBox1 = (System.Web.UI.WebControls.TextBox)GridView1.Rows[e.RowIndex].FindControl("txtqty");

// Add New Line Like Below
System.Web.UI.WebControls.TextBox PriceTextBox;
PriceTextBox = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("txtPrice");
 
System.Web.UI.WebControls.Label Label3;
Label3 = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("lblcode");


 
objConnection.Open();
 
SqlCommand comm = new SqlCommand("UPDATE tmp SET qty=@qty,price=@price WHERE code=@code", objConnection);
comm.Parameters.AddWithValue("@qty", TextBox1.Text.ToString());

// Add New Line Like Below
comm.Parameters.AddWithValue("@price", PriceTextBox.Text);

comm.Parameters.AddWithValue("@code", Label3.Text.ToString());
comm.ExecuteNonQuery();
 
//Finally Close the Connection 
objConnection.Close();
GridView1.EditIndex = -1;
GridView1.DataBind();

}