使用 asp.net 删除查询时出错
本文关键字:出错 查询 删除 asp net 使用 | 更新日期: 2023-09-27 18:33:41
我尝试使用网格视图删除一些行。
protected void Button1_Click(object sender, EventArgs e)
{
Session["ID_Oosby"] = GridView1.SelectedRow.Cells[0].Text;
try
{
SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["RentCarConnectionString"].ConnectionString);
conn1.Open();
string deleteQuery = "Delete From from Klienci Where IDOsoby = @idosoby ";
SqlCommand com2 = new SqlCommand(deleteQuery, conn1);
com2.Parameters.AddWithValue("@idosoby", Session["ID_Osoby"]);
com2.ExecuteNonQuery();
conn1.Close();
}
catch (Exception ex)
{
Response.Write("Nie udąło sie usunac uzytkownika" + ex.ToString());
}
}
但是当我执行它时,我收到错误消息
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'from'. w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
知道出了什么问题吗?
将 sql 查询更改为:
string deleteQuery = "Delete From Klienci Where IDOsoby = @idosoby ";
您有两个 FROM 子句导致异常。