در هنگام INSERT در جدول SQL ارور Input string was not in a correct format میاد
و کد زیر به رنگ زرد در میاد
cstmer = newCUSTOMER();
cstmer.CustomerInsert(Convert.ToInt32(txtcustomerNum.Text.Trim()),
txtname.Text.Trim(),txtfamily.Text.Trim(), txtphone.Text.Trim(),
txtAddress.Text.Trim(),Convert.ToDecimal(txtTotalCost.Text.Trim()));
این هم از کلاس CUSTOMER
publicvoid CustomerInsert(int CUSTOMERNUM, string CUSTOMERNAME,
string CUSTOMERFAMILY,string CUSTOMERPHONE,string CUSTOMERADDRESS,decimal CUSTOMERCOST)
{
cmd = newSqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CustomerInsert";
cmd.Parameters.AddWithValue("@CUSTOMERNUM", CUSTOMERNUM);
cmd.Parameters.AddWithValue("@CUSTOMERNAME", CUSTOMERNAME);
cmd.Parameters.AddWithValue("@CUSTOMERFAMILY", CUSTOMERFAMILY);
cmd.Parameters.AddWithValue("@CUSTOMERPHONE", CUSTOMERPHONE);
cmd.Parameters.AddWithValue("@CUSTOMERADDRESS", CUSTOMERADDRESS);
cmd.Parameters.AddWithValue("@CUSTOMERCOST", CUSTOMERCOST);
DbRun = newMyDbRun();
DbRun.Execommand(cmd);
.
.
و این هم استورپرسیجر
createproc CustomerInsert
@CUSTOMERNUM int,
@CUSTOMERNAME nvarchar(20),
@CUSTOMERFAMILY nvarchar(40),
@CUSTOMERPHONE nvarchar(20),
@CUSTOMERADDRESS nvarchar(500),
@CUSTOMERCOST decimal(9, 0)
as
insertinto RESTAURANT.dbo.CUSTOMER(CUSTOMERNUM,CUSTOMERNAME,
CUSTOMERFAMILY,CUSTOMERPHONE,CUSTOMERADDRESS,CUSTOMERCOST)
values (@CUSTOMERNUM,@CUSTOMERNAME,
@CUSTOMERFAMILY,@CUSTOMERPHONE,@CUSTOMERADDRESS,@CUSTOMERCOST)
go
مشکلش چیه؟
پاسخ با نقل قول