代码如下:
SqlConnection conn = new SqlConnection("server=.;database=SQL_Test;uid=sa;pwd=123");
conn.Open();
SqlCommand cmd =
new SqlCommand("sp_cystyle " + System.DateTime.Now.Year + "," + ds.Tables["year"].Rows[0]["systemsetvalue"] + ",0", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
conn.Close();提示找不到存储过程!
请赐教!存储过程 sp_cystyle 在SQL_Test真实存在。且有三个参数。
CREATE PROCEDURE sp_cystyle
@defyear int,
@setyear int,
@selection int
AS
BEGIN
select styleid,s_name from stylepower_elyp where selection='0' and st_year>=(@defyear-@setyear) and selection=@selection order by styleid
END
SqlConnection conn = new SqlConnection("server=.;database=SQL_Test;uid=sa;pwd=123");
conn.Open();
SqlCommand cmd =
new SqlCommand("sp_cystyle " + System.DateTime.Now.Year + "," + ds.Tables["year"].Rows[0]["systemsetvalue"] + ",0", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
conn.Close();提示找不到存储过程!
请赐教!存储过程 sp_cystyle 在SQL_Test真实存在。且有三个参数。
CREATE PROCEDURE sp_cystyle
@defyear int,
@setyear int,
@selection int
AS
BEGIN
select styleid,s_name from stylepower_elyp where selection='0' and st_year>=(@defyear-@setyear) and selection=@selection order by styleid
END
解决方案 »
- C# 导出oracle数据。执行到一半中止。<Shift>+<F5>“终止调试”会接着执行完。
- 多线程问题,求指教!...
- .NET2.0 ftp主动模式上传文件
- 根据字符串创建类实例后的问题????(急,在线等)!!!!
- 为什么我写的这段Sql语句无法对数据库是否有重复的用户进行判断?
- 400分求助 窗体快速点击时误点新开窗口的按钮 怎么处理?
- 已知dataGrid填上了数据,请问怎么得到有几列,每一列的标题是什么?
- 【求教】字段初始值无法引用非静态字段、方法的问题
- 请问.NET能够连sql6.5的数据库吗?
- 怎样在c#中执行ShellExecute这个API函数?
- 如何获取硬盘的总大小,不是剩余空间
- 焦点设置无效的问题,大家帮忙看看
SqlConnection conn = new SqlConnection("server=.;database=SQL_Test;uid=sa;pwd=123");
conn.Open(); SqlParameter p1 = new SqlParameter("@defyear", SqlDbType.Int);
p1.Direction = ParameterDirection.Input;
p1.Value = System.DateTime.Now.Year; SqlParameter p2 = new SqlParameter("@setyear", SqlDbType.Int);
p2.Value = ds.Tables["year"].Rows[0]["systemsetvalue"];
p2.Direction = ParameterDirection.Input; SqlParameter p3 = new SqlParameter("@selection", SqlDbType.Int, 4);
p3.Direction = ParameterDirection.Input;
p3.Value = 0; SqlCommand cmd = conn.CreateCommand();
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_cystyle ";
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
conn.Close();
.CommandType=CommandType.StoredProcedure; SqlConnection Sql = new SqlConnection(ConnStr);
SqlCommand cmd = new SqlCommand("存储过程", Sql);
string Str = "exec ...";
Sql.Open();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_cystyle ", conn);
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
cmd.Parameters.Add("@defyear", SqlDbType.Int).Value = System.DateTime.Now.Year;
//下面两个语句可能要类型转换
cmd.Parameters.Add("@setyear", SqlDbType.Int).Value = ds.Tables["year"].Rows[0]["systemsetvalue"];
cmd.Parameters.Add("@selection", SqlDbType.Int).Value = ds.Tables["year"].Rows[0]["systemsetvalue"];
conn.Close();
SqlConnection conn = new SqlConnection("server=.;database=SQL_Test;uid=sa;pwd=123");
conn.Open();
SqlCommand cmd = new SqlCommand("sp_cystyle ", conn);
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
cmd.Parameters.Add("@defyear", SqlDbType.Int).Value = System.DateTime.Now.Year;
//下面两个语句可能要类型转换
cmd.Parameters.Add("@setyear", SqlDbType.Int).Value = ds.Tables["year"].Rows[0]["systemsetvalue"];
cmd.Parameters.Add("@selection", SqlDbType.Int).Value = ds.Tables["year"].Rows[0]["systemsetvalue"];
conn.Close();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_cystyle ", conn);
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter dapa = new SqlDataAdapter(cmd);
dapa.Fill(ds, "style");
cmd.Parameters.Add("@defyear", SqlDbType.Int).Value = System.DateTime.Now.Year;
//下面两个语句可能要类型转换
cmd.Parameters.Add("@setyear", SqlDbType.Int).Value = ds.Tables["style"].Rows[0]["systemsetvalue"];
cmd.Parameters.Add("@selection", SqlDbType.Int).Value = ds.Tables["style"].Rows[0]["systemsetvalue"];
conn.Close();