DataGrid1_Updat eCommand (update price)

[cwbp17]

Have a datagrid that displays the price column in this format $12,400.00 from
a table.

Went to the Property Builder of the datagrid and selected the Price column
and changed the Data formatting expression to {0:c}

*********
Have the following code in the DataGrid1_Updat eCommand event handler

string key = DataGrid1.DataK eys[e.Item.ItemInde x].ToString();

//Price column
TextBox tb = (TextBox) e.Item.Cells[1].Controls[0];
string stPrice = tb.Text.SubStri ng(1); //this is the decimal number without
the '$'
decimal dc = decimal.Parse(s tPrice); //convert string number to decimal

DataSet1.CAR_DE TAILRow r;

r = dataSet11.CAR_D ETAIL.FindByCAR _ID(int.Parse(k ey));

r.PRICE=dc; //this line causes problems; in my table the datatype of Price is
//number and I keep getting the error "Input string was
not in a
//correct format."

oracleDataAdapt er1.Update(data Set11);
DataGrid1.DataB ind();

DataGrid1.EditI temIndex = -1;
DataGrid1.DataB ind();

*************** ****
Can anyone tell me what I'm doing wrong? I've also tried using
Convert.ToDecim al and still same error message.

Is there a better way of updating the changes of a datagrid to the database?

Any suggestions would be appreciated.

I'm using c# and oracle9i table

Thanks

bebop