hi everyone i have database access where i have atable which gets its data from gridview 3 of field are number and accept double when i pass value the fields type get change into text
whats the wrong that make happen this is my code
public void Addrep(string ReName, double Reprice, double Retotal, double Recount)
{
String str = " INSERT INTO Report ( Re_Name, Re_price, Re_total, Re_count ) values ('" + ReName + "','" + Reprice + "','" + Retotal + "','" + Recount + "' )";
OpenCnn();
OleDbCommand cmd = new OleDbCommand(str, cnn);
cmd.ExecuteNonQuery();
CloseCnn();
}
if (RowsCount != 0 || RowsCount != null)
{
repo.DeleteRe();
for (int i = 0; i < RowsCount; i++)
{
repo.Insert(this.dgvsell[2, i].Value.ToString(),
Convert.ToDouble(dgvsell[4, i].Value),
Convert.ToDouble(dgvsell[5, i].Value),
Convert.ToDouble(dgvsell[6, i].Value));
}
}
and my fields are Re_Name text, Re_price double, Re_total double, Re_count number
in insert it changed automatically into
Re_Name text, Re_price text, Re_total text, Re_count text what is the best soulation for that problem