关于GridView读取

[kevin52141]

我是菜鸟，大家见笑，麻烦解答一下
我在页面的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。

[downmoon]

用SQLHelper

Data Access Application Block for .NET
http://www.microsoft.com/china/MSDN/library/EnterpriseDevelopment/BuildDistApp/Vsdnbdadaab_rm.mspx?mfr=true

[fuda_1985]

public DataSet GetDataSet(string Sql) 
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbs"].ConnectionString);
        SqlDataAdapter sda = new SqlDataAdapter(Sql, sqlconn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        Return ds;
}

看看楼上说的吧。