.net 与sql server问题(.net与sql server存储过程问题)

Question

请问一下.net里面的sqldatareader 对像可以访问 sql server里面的存储过程吗  ?                      可以的话麻烦贴段代码出来看看           谢了!!!!!!!

Answer 1

SqlCommand cmd = new SqlCommand("exec getdata @tablename=" + this.checkedListBox1.CheckedItems[s] + "", conn);
                                conn.Open();
                                cmd.ExecuteNonQuery();
                                SqlDataReader sdr = cmd.ExecuteReader();
                                while (sdr.Read())
                                {
                                    string strsql = "";
                                    for (int i = 0; i < sdr.FieldCount; i++)
                                    {
                                        strsql += sdr[i];                                       
                                    }
                                    sw.WriteLine(strsql);
                                }
                                conn.Close();

Answer 2

            SqlConnection conn = new SqlConnection(sqlConnStr);
            SqlCommand cmd = new SqlCommand(procName, conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                ...
            }
            reader.Close();

Answer 3

            SqlConnection conn = new SqlConnection(sqlConnStr);
            SqlCommand cmd = new SqlCommand("存储过程名称", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                ...
            }
            reader.Close();