返回数据集.txt

学习积累的代码段

public GetDate()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //用与执行查询并返回数据集返回值为Dataset型执行成功返回DataSet
    public DataSet Get(string Sql,string TableName)
    {
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlDataAdapter sdr = new SqlDataAdapter(Sql,con);
        DataSet ds = new DataSet();
        sdr.Fill(ds,TableName);
        con.Close();
        return ds;

    
    
    }//
调用：
 protected void Button1_Click(object sender, EventArgs e)
    {
        string str = "select  top 1 Nname  from TestNews";
        this.DataList1.DataSource = gt.Get(str, "TestNews");
        this.DataList1.DataBind();
    }