SQL 异常未处理 - System.Data 中发生类型 'System.Data.SqlClient.SqlException' 的未处理异常.dll

Question

SQL Exception is unhandled-System.Data.SqlClient.SqlException 类型为">System.Data.SqlClient.SqlException"的未处理异常.dll

 public DataSet getCustomers()
    {
        string Connectionstring = ConfigurationManager.ConnectionStrings["DbConn"].ToString();
        SqlConnection objConnection = new SqlConnection(Connectionstring);
        objConnection.Open();
        SqlCommand objCommand = new SqlCommand("Select * from Customer '"                                                  ,
                                              objConnection);
        DataSet objDataSet = new DataSet();
        SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
        objAdapter.Fill(objDataSet);
        objConnection.Close();
        return objDataSet;
    }

Answer 1

看起来像客户' "后的额外撇号：

SqlCommand objCommand = new SqlCommand("Select * from Customer '", objConnection);

Answer 2

从查询命令中删除 '：

SqlCommand objCommand = new SqlCommand("Select * from Customer" , objConnection);

Answer 3

将您的代码包含在 Try Catch 中：

        public DataSet getCustomers()
    {
        try
        {
            string Connectionstring = ConfigurationManager.ConnectionStrings["DbConn"].ToString();
            SqlConnection objConnection = new SqlConnection(Connectionstring);
            objConnection.Open();
            SqlCommand objCommand = new SqlCommand("Select * from Customer '",
                                                  objConnection);
            DataSet objDataSet = new DataSet();
            SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
            objAdapter.Fill(objDataSet);
            objConnection.Close();
            return objDataSet;
        }
        catch (Exception ex)
        {
            Trace.Write(ex.Message);
            return null;
        }
    }

前任。消息将是：字符串 '' 后面的未闭合引号。

只需删除">客户之后">