新手急求 在线等

Question

      SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=V50JJE4\\SQLEXPRESS;Initial Catalog=MyBlog;User ID=sa;Password=ko";
        conn.Open();
        
        SqlDataAdapter da = new SqlDataAdapter();
        try
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "InsertArtical";
            cmd.Parameters.Add("@Artical_ID", System.Data.SqlDbType.Int, 32).Value  = TextBox3.Text;
            cmd.Parameters.Add("@Artical_Title", System.Data.SqlDbType.NVarChar, 50).Value  = TextBox1.Text;
            cmd.Parameters.Add("@Artical_Content", System.Data.SqlDbType.NVarChar, 50) .Value = TextBox2.Text;
            int se = cmd.ExecuteNonQuery();  出先错误：Connection属性尚未初始化

Answer 1

SqlCommand cmd = new SqlCommand(conn);

Answer 2

SqlCommand command = new SqlCommand(
            queryString, connection);

Answer 3

+1
你sql语句和链接语句都没有，怎么执行sql？

Answer 4

 cmd.Connection = conn;

Answer 5

SqlConnection conn = new SqlConnection();
  conn.ConnectionString = "Data Source=V50JJE4\\SQLEXPRESS;Initial Catalog=MyBlog;User ID=sa;Password=ko";
  conn.Open();
    
  SqlDataAdapter da = new SqlDataAdapter();
  try
  {
  SqlCommand cmd = new SqlCommand();
  cmd.Connection = conn;
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = "InsertArtical";
  cmd.Parameters.Add("@Artical_ID", System.Data.SqlDbType.Int, 32).Value = TextBox3.Text;
  cmd.Parameters.Add("@Artical_Title", System.Data.SqlDbType.NVarChar, 50).Value = TextBox1.Text;
  cmd.Parameters.Add("@Artical_Content", System.Data.SqlDbType.NVarChar, 50) .Value = TextBox2.Text;