假设在ABC.cs文件中,我在建立了一Gethtbhnum数据集如下:
public DataSet Gethtbhnum()
{
//连接字符串为空,则抛出错误
if(mcnStr == "")
{
throw(new ArgumentNullException("ConnectionString","数据库连接字符串为空"));
}
OleDbConnection objCn = new OleDbConnection();//建立联接
OleDbDataAdapter objCmd;
DataSet Ds = new DataSet();
try
{
objCn.ConnectionString = mcnStr;
objCmd = new OleDbDataAdapter("select * from efmvalues where efmid in (select efmid from flowctrl where efmformname='合同审批表' and stepname='总经理') and fldname='T1' order by efmid",objCn);
objCmd.Fill(Ds,"efmvalues");
objCn.Close();
}
catch (Exception e)
{
throw(new Exception("方法 BUEfmValues.Gethtbhnum中发生错误", e));
}
finally
{
if(!(objCn.State == ConnectionState.Closed))
objCn.Close();
}
return Ds;
}
现在我在ABC.cs 的另一个方法中调用Gethtbhnum(),如下所示:
DataSet htnumds=new DataSet();
htnumds=this.Gethtbhnum(str1); if (htnumds.Tables[0].Rows.Count>0)
{
.........
}
但是老是说Gethtbhnum()中发生错误,超时已过期,不知道是什么原因啊!
public DataSet Gethtbhnum()
{
//连接字符串为空,则抛出错误
if(mcnStr == "")
{
throw(new ArgumentNullException("ConnectionString","数据库连接字符串为空"));
}
OleDbConnection objCn = new OleDbConnection();//建立联接
OleDbDataAdapter objCmd;
DataSet Ds = new DataSet();
try
{
objCn.ConnectionString = mcnStr;
objCmd = new OleDbDataAdapter("select * from efmvalues where efmid in (select efmid from flowctrl where efmformname='合同审批表' and stepname='总经理') and fldname='T1' order by efmid",objCn);
objCmd.Fill(Ds,"efmvalues");
objCn.Close();
}
catch (Exception e)
{
throw(new Exception("方法 BUEfmValues.Gethtbhnum中发生错误", e));
}
finally
{
if(!(objCn.State == ConnectionState.Closed))
objCn.Close();
}
return Ds;
}
现在我在ABC.cs 的另一个方法中调用Gethtbhnum(),如下所示:
DataSet htnumds=new DataSet();
htnumds=this.Gethtbhnum(str1); if (htnumds.Tables[0].Rows.Count>0)
{
.........
}
但是老是说Gethtbhnum()中发生错误,超时已过期,不知道是什么原因啊!
解决方案 »
- 大雨滂沱跪地求教
- 怎样用Javsscritp判断Gridview里的label值
- 问个简单的问题,一直困扰着我。。。痛苦中。
- 客户端网页如何关闭远程机器
- Repeater控件问题
- 菜鸟问题 这里为什么出错了
- 我是新手,各位前辈ASP.NET2.0与1.1有什么不同啊
- 急求 PrincipalPermission 类的使用 谢谢+100(不够在加)
- 求助
- 100分求:ASP.NET中怎么放大、缩小、旋转、打印图像?
- 在线等!我是个初学者!想请教各位大侠,怎样打开一个ASP.NET的系统,还有如何连接数据库!说具体点!谢谢了!
- 怎样得到当前连接的上一个连接(Request.UrlReferrer问题)
select * from efmvalues where efmid in (select efmid from flowctrl where efmformname='合同审批表' and stepname='总经理') and fldname='T1' order by efmid
数据太多超时
OleDbDataAdapter objCmd;
DataSet Ds = new DataSet();
try
{
objCn.ConnectionString = mcnStr;
objCmd = new OleDbDataAdapter("select * from efmvalues where efmid in (select efmid from flowctrl where efmformname='合同审批表' and stepname='总经理') and fldname='T1' order by efmid",objCn);
objCmd.Fill(Ds,"efmvalues");
objCn.Close();
} --------------------- 以你的数据库连接字符串正确为前提
OleDbConnection objCn = new OleDbConnection(mcnStr);//建立联接
objCn.Open();
OleDbDataAdapter objCmd;
DataSet Ds = new DataSet();
try
{
objCmd = new OleDbDataAdapter("select * from efmvalues where efmid in (select efmid from flowctrl where efmformname='合同审批表' and stepname='总经理') and fldname='T1' order by efmid",objCn);
objCmd.Fill(Ds,"efmvalues");
}