c#求解

Question

cc#

Answer 1

DbCommand cmd,
cmd.CommandType = CommandType.Storage;
cmd.Text="存储过程名称";跟查文本一样的，就CommandType 设置下

Answer 2

           using (SqlConnection conn = new SqlConnection("链接字符串"))
            {
                string sql = "存储过程名";
                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@参数1","参数值"),
                    new SqlParameter("@参数2","参数值")
                };                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;  //就这一句和执行普通sql不一样
                    cmd.Parameters.AddRange(param);
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
            }

Answer 3

http://blog.csdn.net/newdtech/article/details/7766981

Answer 4

那如果的  mvc+EF的  网站呢

Answer 5

找下ADO.Net,ADO.Net EF的资料看看那就知道了。

Answer 6

SqlCommand cmd = new SqlCommand(“存储过程的名称”, 连接字符串)