执行这下面的代码的时候报错: “抱歉!操作失败!输入字符串的格式不正确”。
private void CC_button_Click(object sender, System.EventArgs e)
{
try
{
PubF.DBOpen();
string strid="";
string sl="";
int kcsl=0;
int lysl=0;
int sysl=0;
string strsql_select="";
string strsql_delete="";
string strsql_insert="";
string strsql_update="";
int i=0;
foreach(DataGridItem id in this.DataGrid1.Items)
{
i=i+1;
TextBox ccsl =(TextBox)DataGrid1.Controls[0].Controls[1+i].FindControl("ccsl");
if(ccsl.Text!="")
{
strid=DataGrid1.DataKeys[i-1].ToString();
strsql_select="select sl from ckgl_kcxx where xh='"+strid+"'";
//Label1.Text=strsql_select;
OleDbCommand cmd=new OleDbCommand(strsql_select,PubF.cn);
OleDbDataReader dt=cmd.ExecuteReader();
dt.Read();
sl=dt["sl"].ToString();
kcsl= Convert.ToInt32(sl);
dt.Close();
lysl=Convert.ToInt32(ccsl.Text);
sysl=kcsl-lysl;
wpmc.Text=kcsl.ToString();
gys.Text=sysl.ToString();
strsql_delete="delete ckgl_kcb where xh like '"+strid+"'";
strsql_insert="insert into ckgl_ckb select * from ckgl_kcb where xh like '"+strid+"'";
//PubF.ExSQL(strsql_insert);
//PubF.ExSQL(strsql_delete);
}
}
PubF.ShowMessage("出库成功!");
PubF.DelectGridLast(DataGrid1);
this.GridBind();
}
catch(Exception ex)
{
PubF.ShowWrongMessage("抱歉!操作失败!",ex.Message.ToString());
}
finally
{
PubF.DBClose();
}
请问那里错了?
private void CC_button_Click(object sender, System.EventArgs e)
{
try
{
PubF.DBOpen();
string strid="";
string sl="";
int kcsl=0;
int lysl=0;
int sysl=0;
string strsql_select="";
string strsql_delete="";
string strsql_insert="";
string strsql_update="";
int i=0;
foreach(DataGridItem id in this.DataGrid1.Items)
{
i=i+1;
TextBox ccsl =(TextBox)DataGrid1.Controls[0].Controls[1+i].FindControl("ccsl");
if(ccsl.Text!="")
{
strid=DataGrid1.DataKeys[i-1].ToString();
strsql_select="select sl from ckgl_kcxx where xh='"+strid+"'";
//Label1.Text=strsql_select;
OleDbCommand cmd=new OleDbCommand(strsql_select,PubF.cn);
OleDbDataReader dt=cmd.ExecuteReader();
dt.Read();
sl=dt["sl"].ToString();
kcsl= Convert.ToInt32(sl);
dt.Close();
lysl=Convert.ToInt32(ccsl.Text);
sysl=kcsl-lysl;
wpmc.Text=kcsl.ToString();
gys.Text=sysl.ToString();
strsql_delete="delete ckgl_kcb where xh like '"+strid+"'";
strsql_insert="insert into ckgl_ckb select * from ckgl_kcb where xh like '"+strid+"'";
//PubF.ExSQL(strsql_insert);
//PubF.ExSQL(strsql_delete);
}
}
PubF.ShowMessage("出库成功!");
PubF.DelectGridLast(DataGrid1);
this.GridBind();
}
catch(Exception ex)
{
PubF.ShowWrongMessage("抱歉!操作失败!",ex.Message.ToString());
}
finally
{
PubF.DBClose();
}
请问那里错了?
转换出错,sl是有2位小数的数字,这要怎么转换?是不是要转换成float?