我是菜鸟,大家见笑,麻烦解答一下
我在页面的CS文件完成了GridView的数据绑定并且测试成功,代码如下:protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbs"].ConnectionString);
sqlconn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from users", sqlconn);
DataSet ds = new DataSet();
sda.Fill(ds);
this.GVinfo.DataSource = ds;
this.GVinfo.DataBind();
sda.Dispose();
ds.Dispose();
sqlconn.Close();
现在我想用写一个方法来吧读取的部分写到一个公有类里
我在我的公有类DB.cs文件的代码如下using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Sql;
using System.Data.SqlClient; private string connstr;
private SqlConnection con;
private SqlCommand cmd;
private SqlDataAdapter sqladpter;
private DataSet ds;
private SqlDataReader dr;public db()
{
//实例化
connstr = ConfigurationManager.ConnectionStrings["dbs"].ConnectionString;
con = new SqlConnection(connstr);
cmd = new SqlCommand();
sqladpter = new SqlDataAdapter();
ds = new DataSet();
}
麻烦各位帮忙看一下如果写成一个公有的读取方法怎么写,并且在CS文件中怎么调用的。GridView控件名为GVinfo。
我在页面的CS文件完成了GridView的数据绑定并且测试成功,代码如下:protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbs"].ConnectionString);
sqlconn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from users", sqlconn);
DataSet ds = new DataSet();
sda.Fill(ds);
this.GVinfo.DataSource = ds;
this.GVinfo.DataBind();
sda.Dispose();
ds.Dispose();
sqlconn.Close();
现在我想用写一个方法来吧读取的部分写到一个公有类里
我在我的公有类DB.cs文件的代码如下using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Sql;
using System.Data.SqlClient; private string connstr;
private SqlConnection con;
private SqlCommand cmd;
private SqlDataAdapter sqladpter;
private DataSet ds;
private SqlDataReader dr;public db()
{
//实例化
connstr = ConfigurationManager.ConnectionStrings["dbs"].ConnectionString;
con = new SqlConnection(connstr);
cmd = new SqlCommand();
sqladpter = new SqlDataAdapter();
ds = new DataSet();
}
麻烦各位帮忙看一下如果写成一个公有的读取方法怎么写,并且在CS文件中怎么调用的。GridView控件名为GVinfo。
http://www.microsoft.com/china/MSDN/library/EnterpriseDevelopment/BuildDistApp/Vsdnbdadaab_rm.mspx?mfr=true
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbs"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter(Sql, sqlconn);
DataSet ds = new DataSet();
sda.Fill(ds);
Return ds;
}看看楼上说的吧。