如题
public DataView DBSingleStrDv ( string strSpName , string strParName , string strID )
{
//创建数据的连接,连接字符串从web.config中读取
SqlConnection myConn = new SqlConnection( ConfigurationSettings.AppSettings["DBConnectionString"] ); //创建数据库操作命令,命令为sql语句
SqlCommand myCmd = new SqlCommand ( strSpName, myConn );
myCmd.CommandType = CommandType.StoredProcedure ;
myCmd.CommandTimeout = 30;
myCmd.Parameters.Add (strParName,SqlDbType.NVarChar ,14);
myCmd.Parameters[0].Value = strID;
SqlDataAdapter myda = new SqlDataAdapter ( myCmd );
DataSet myds = new DataSet ( "ds" );
DataView dv = new DataView ( );
//连接数据库,并填充数据
try
{
myConn.Open ( );
myda.Fill ( myds,"ds" );
dv.Table = myds.Tables[0];
}
catch( Exception E )
{
throw E;
}
finally
{
myConn.Close ( );
}
return dv;
}
public DataView DBSingleStrDv ( string strSpName , string strParName , string strID )
{
//创建数据的连接,连接字符串从web.config中读取
SqlConnection myConn = new SqlConnection( ConfigurationSettings.AppSettings["DBConnectionString"] ); //创建数据库操作命令,命令为sql语句
SqlCommand myCmd = new SqlCommand ( strSpName, myConn );
myCmd.CommandType = CommandType.StoredProcedure ;
myCmd.CommandTimeout = 30;
myCmd.Parameters.Add (strParName,SqlDbType.NVarChar ,14);
myCmd.Parameters[0].Value = strID;
SqlDataAdapter myda = new SqlDataAdapter ( myCmd );
DataSet myds = new DataSet ( "ds" );
DataView dv = new DataView ( );
//连接数据库,并填充数据
try
{
myConn.Open ( );
myda.Fill ( myds,"ds" );
dv.Table = myds.Tables[0];
}
catch( Exception E )
{
throw E;
}
finally
{
myConn.Close ( );
}
return dv;
}
解决方案 »
- 怎样远程访问sqlserver 2005
- 请问BulletedList能否把<a>或<asp:Hyperlink>作为它的显示项?
- 如何动态添加控件到指定位置?
- vs2005简单数据绑定
- asp.net執行exe文件只能在進程中有顯示,但是無法顯示窗口??
- 生成SQL语句,请高手指教
- 用C#连接sybase数据库的完成代码。QQ:85210053
- 如何自己写代码从pdf文件中提取纯文本
- 请问 HtmlButton的 OnServerClick 事件跟 WebButton的事件有区别吗?
- 怎样在asp.net中实现数据的动态查询?
- ASP.NET中讀寫資料庫需要用到那些類?他們的作用?
- 哪位知道http://www.google.cn/search?hl=zh-CN&q=%E8%...中的search是什么程序?
2没有必要使用DataView
{
//创建数据的连接,连接字符串从web.config中读取
SqlConnection myConn = new SqlConnection( ConfigurationSettings.AppSettings["DBConnectionString"] );//创建数据库操作命令,命令为sql语句
SqlCommand myCmd = new SqlCommand ( strSpName, myConn );
myCmd.CommandType = CommandType.StoredProcedure ;
myCmd.CommandTimeout = 30;myCmd.Parameters.Add (strParName,SqlDbType.NVarChar ,14);
myCmd.Parameters[0].Value = strID;SqlDataAdapter myda = new SqlDataAdapter ( myCmd );
DataSet myds = new DataSet ( "ds" );
DataTable dt = null;
//连接数据库,并填充数据try
{myda.Fill ( myds,"ds" );
dt = myds.Tables[0];}
catch( Exception E )
{
throw E;
}
finally
{
myConn.Close ( );
}
return dt.DefaultView;
}
public DataView GetCorpInfoDet ( string StrCorpID )
{
AbstractDBOp aop = new AbstractDBOp ( );
try
{
return aop.DBSingleStrDv ("spGetCorpInfoDet","@ID",StrCorpID);
}
catch ( Exception E )
{
throw E;
}
}--------------------------------
dvCorp = CorpInfo.GetCorpInfoDet(CorpID);查询不出结果,这是为什么呢??