这个运行不出来，请问是哪里出错了？

Question

public static class SqlHelper
{
1 string connStr = @"Data Source =.; Initial catalog=Myshop;Integrated Security = True";
2 public static object ExecuteScalarstring sql)
{
3 object obj = null;
4 using SqlConnection conn = new SqlConnectionconnStr （)
{
5 using SqlCommand cmd = new SqlCommand（conn，sql))
{
6 try
{
7 conn.close（）;
8 obj=cmd.ExecuteScalar);
9 return obj;
}
10 catch exception （ex)
{
11 throw ex;
}
}
}
}

Answer 1

这是按你的要求修改的完整代码

  public static class SqlHelper
    {
        static string connStr = @"Data Source =.; Initial catalog=Myshop;Integrated Security = True";
        public static object ExecuteScalar(string sql)
        {
            object obj = null;
            using (SqlConnection conn = new SqlConnection(connStr))
            {

                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    try
                    {
                        
                        conn.Close();
                        obj = cmd.ExecuteScalar();
                        return obj;
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
            }
        }
    }