各位高手帮忙:偶在作数据库编程,因为屡次需用:sqlconnection
gong1 2003-08-23 04:44:23 SqlDataReader 和Dataset
想把他写道一个类里(c#),
在asp.net的窗体里,
怎么样来调用?
例如:
fetchData_sdk.cs
SqlDataReader fetchReader ( string query, string db ) {
// connect to data source
SqlConnection myConn = new SqlConnection (
"server=(local)\\NetSDK; trusted_connection=yes; database=" + db );
// initialize command object with query
SqlCommand myCmd = new SqlCommand ( query, myConn );
// open connection
myConn.Open ( );
// return datareader
return myCmd.ExecuteReader ( CommandBehavior.CloseConnection );
}
// generic method to fetch data from SQL Server into a dataset
DataSet fetchData ( string query, string db ) {
// connect to data source
SqlConnection myConn = new SqlConnection (
"server=(local)\\NetSDK; trusted_connection=yes; database=" + db );
// initialize dataadapter with query
SqlDataAdapter myAdapter = new SqlDataAdapter ( query, myConn );
// initalize and fill dataset with query results
DataSet myData = new DataSet ( );
myAdapter.Fill ( myData );
// return dataset
return myData;
}
我怎样在asp.net里复用上段代码?
帮帮忙了,^_^,先谢谢各位.