查询字符串SQL出错
本文关键字:出错 SQL 字符串 查询 | 更新日期: 2023-09-27 18:04:25
我得到以下错误:
"类型为'System.Data.SqlClient.SqlException'的第一次机会异常"附加信息:语法不正确附近)。如果有此异常的处理程序,则程序可能安全地继续。"
这是语法吗?我真的弄不清楚,有人能告诉我做错了什么吗?
private void button2_Click(object sender, EventArgs e)
{
MessageBox.Show("A Atualizar dados...");
bool check = true;
do
{
string connectionString = @"Data Source=.'wintouch;Initial Catalog=bbl;User ID=sa;Password=Pa$$w0rd";
string queryString = string.Empty;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
queryString = "UPDATE wgcdoccab SET merc1 = merc1/2 WHERE numdoc = (SELECT MAX(numdoc) FROM WGCDOCCAB WHERE serie ='1' and tipodoc ='FSS' and contribuinte ='999999990' and datadoc = CONVERT(varchar(10),(dateadd(dd, -1, getdate())), 120))";
SqlCommand command = new SqlCommand(queryString, connection);
command.ExecuteNonQuery();
connection.Close();
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
queryString = "SELECT max(numdoc) FROM wgcdoccab WHERE serie ='1' and tipodoc ='FSS' and contribuinte ='999999990' and datadoc = CONVERT(varchar(10),(dateadd(dd, -1, getdate())), 120))";
using (SqlCommand command = new SqlCommand(queryString, connection))
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
check = true;
}
else
{
check = false;
MessageBox.Show("Dados atualizados com sucesso");
}
command.Connection.Close();
}
}
}
while (check);
检查SQL语句。这行括号太多了:
queryString = "SELECT max(numdoc) FROM wgcdoccab WHERE serie ='1' and tipodoc ='FSS' and contribuinte ='999999990' and datadoc = CONVERT(varchar(10),(dateadd(dd, -1, getdate())), 120))";