private void updata_Click(object sender, EventArgs e)
{
sqlInsertCommand.Parameters.Clear();
sqlInsertCommand.CommandType = CommandType.Text;
sqlInsertCommand.CommandText = "select count(*) from XS_KC WHERE XS_KC.XH='" + cmbXH.Text + "'AND XS_KC.KCH=(SELECT KCH from KC WHERE KCM='" + cmbKCM.Text + "')";
try
{
sqlConnection1.Open();
int cnt = (int)sqlInsertCommand.ExecuteScalar();
if (cnt == 1)
{
sqlInsertCommand.CommandText = "update XS_KC SET XS_KC.CJ='" + tbCJ.Text + "'WHERE XS_KC.XH='" + cmbXH.Text + "'AND XS_KC.KCH=(SELECT KCH FROM KC WHERE KCM='" + cmbKCM.Text + "')";
}
else
{
sqlSelectCommand1.Parameters.Clear();
sqlSelectCommand1.CommandType = CommandType.Text;
sqlSelectCommand1.CommandText = "select KCH FROM KC WHERE KCM='" + cmbKCM.Text + "'";
sqlInsertCommand.CommandText = "INSERT INTO XS_KC VALUES('" + cmbXH.Text.Trim() + "'," + sqlSelectCommand1.ExecuteScalar() + "," + int.Parse(tbCJ.Text.Trim()) + ")";
} sqlInsertCommand.ExecuteNonQuery();
}
finally
{
sqlConnection1.Close();
}
}
sqlInsertCommand.ExecuteNonQuery(); '.' 附近有语法错误。
{
sqlInsertCommand.Parameters.Clear();
sqlInsertCommand.CommandType = CommandType.Text;
sqlInsertCommand.CommandText = "select count(*) from XS_KC WHERE XS_KC.XH='" + cmbXH.Text + "'AND XS_KC.KCH=(SELECT KCH from KC WHERE KCM='" + cmbKCM.Text + "')";
try
{
sqlConnection1.Open();
int cnt = (int)sqlInsertCommand.ExecuteScalar();
if (cnt == 1)
{
sqlInsertCommand.CommandText = "update XS_KC SET XS_KC.CJ='" + tbCJ.Text + "'WHERE XS_KC.XH='" + cmbXH.Text + "'AND XS_KC.KCH=(SELECT KCH FROM KC WHERE KCM='" + cmbKCM.Text + "')";
}
else
{
sqlSelectCommand1.Parameters.Clear();
sqlSelectCommand1.CommandType = CommandType.Text;
sqlSelectCommand1.CommandText = "select KCH FROM KC WHERE KCM='" + cmbKCM.Text + "'";
sqlInsertCommand.CommandText = "INSERT INTO XS_KC VALUES('" + cmbXH.Text.Trim() + "'," + sqlSelectCommand1.ExecuteScalar() + "," + int.Parse(tbCJ.Text.Trim()) + ")";
} sqlInsertCommand.ExecuteNonQuery();
}
finally
{
sqlConnection1.Close();
}
}
sqlInsertCommand.ExecuteNonQuery(); '.' 附近有语法错误。
解决方案 »
- 一个Linq 问题
- 字符串语种问题
- sqlcommand?
- .Net 接口 反射
- 求助~~~~~ 未能加载文件或程序集System, Version=2.0.0.0
- windows高级内核调试PPT资料下载
- Combobox.text的值可否在另一个form中调用?
- 如何把LISTVIEW控件的标题加高呢?
- 在线等待有关字符串以及文本文档加密的方法
- VC.NET和C#有什么联系和区别,VC.NET是不是原来vc++的升级版,mfc那一套东西在VC.net里还存在吗?????
- 有没有防止 ~.exe.Config 被误删后 能正常工作的机制?在coding中能备份吗
- 关于Graphics的几点疑问
我现在看觉得是: 'WHERE XS_KC.XH=' Where前面少个空格。另外,拼字符串,就不要再转成int了。
int.Parse(tbCJ.Text.Trim()) 不要 int.Parse
我现在看觉得是: 'WHERE XS_KC.XH=' Where前面少个空格。另外,拼字符串,就不要再转成int了。
int.Parse(tbCJ.Text.Trim()) 不要 int.Parse
记得前些日子有人发帖特意指了一下这样的SQL语句写法的问题,虽然不推荐文章中的format但总比这样写好的多
用string.format吧。你这么拼SQL不仔细的话很容易出错
string.format或使用sqlparameter参数化操作
XS_KC.CJ='" + tbCJ.Text + "'WHERE XS_KC.XH
//缺少空格