C#存储过程

 string sql = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
           SqlConnection conn = new SqlConnection(sql);
           if (conn.State != ConnectionState.Open)
           {
               conn.Open();
           }
           SqlCommand cmd = new SqlCommand("P_UserLogin", conn);
           cmd.CommandType = CommandType.StoredProcedure;   //设置数据库打开方式为存储过程
           cmd.Parameters.Add("@userID", SqlDbType.Char).Value = userID;
           cmd.Parameters.Add("@userPwd", SqlDbType.VarChar).Value = userPwd;
           cmd.ExecuteNonQuery();
           SqlDataAdapter sda = new SqlDataAdapter(cmd);
           DataTable dt = new DataTable();
           sda.Fill(dt);
           conn.Close();
           return dt;