string connectionstring = ConfigurationManager.ConnectionStrings["nbmisConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text; sql = "exec CP_Manage '20061101','20061231','1','',''"; cmd.CommandText = sql;
con.Open();
this.GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
con.Dispose();问题出现:
超时时间已到。在操作完成之前超时时间已过或服务器未响应。
this.GridView1.DataSource = cmd.ExecuteReader();
总是这一行不对,
如果我把sql改为常用的select 语句就没有问题,
我这个存储过程是一个很复杂的查询语句,直接在查询分析里执行没有任何问题,只有5秒左右就会出现结果
create PROCEDURE CP_Manage
@stdt char(8),
@eddt char(8),
@flag char(1),
@dept_id varchar(10),
@empl_id varchar(10)
AS
SET NOCOUNT ON
select * from c_manage多谢!
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text; sql = "exec CP_Manage '20061101','20061231','1','',''"; cmd.CommandText = sql;
con.Open();
this.GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
con.Dispose();问题出现:
超时时间已到。在操作完成之前超时时间已过或服务器未响应。
this.GridView1.DataSource = cmd.ExecuteReader();
总是这一行不对,
如果我把sql改为常用的select 语句就没有问题,
我这个存储过程是一个很复杂的查询语句,直接在查询分析里执行没有任何问题,只有5秒左右就会出现结果
create PROCEDURE CP_Manage
@stdt char(8),
@eddt char(8),
@flag char(1),
@dept_id varchar(10),
@empl_id varchar(10)
AS
SET NOCOUNT ON
select * from c_manage多谢!
Conn.Open();
SqlDataAdapter Da=new SqlDataAdapter("exec CP_Manage '20061101','20061231','1','',''",Conn);
DataSet t_ds=new DataSet();
Da.Fill(t_ds,tablename);
Da.Dispose();
Conn.Close();
Conn.Dispose();
不知为什么
执行
sql = "exec CP_Manage '20061101','20061231','1','',''"; cmd.CommandText = sql;
con.Open();
this.GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();就出问题谢谢!
{
SqlConnection Conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
Conn.Open();
SqlDataAdapter Da=new SqlDataAdapter(s_tmp,Conn);
DataSet t_ds=new DataSet();
Da.Fill(t_ds,tablename);
Da.Dispose();
Conn.Close();
Conn.Dispose();
return t_ds;
}调用
DataSet ds=new DataSet();ds=Ds("exec CP_Manage '20061101','20061231','1','',''","table1");
this.GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;/// sql = "exec CP_Manage '20061101','20061231','1','',''";/// 我晕,调用存储过程能这样调吗????
应该改成:
cmd.CommandText = "CP_Manager";
cmd.CommandType = CommandType.storedProcedure;
cmd.Parameters.AddWithValue("参数名称",参数值);
cmd.Parameters.AddWithValue("参数名称",参数值);
cmd.Parameters.AddWithValue("参数名称",参数值);
.
.
.
con.Open();
this.GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
con.Dispose();