dataGrid的问题 请高手帮忙

Question

我想写个类 绑定dataGrid的数据 显示到网格上public string Select()
{
con=new SqlConnection("server=.;uid=sa;database=pubs");
sda=new SqlDataAdapter("select * from books",con);
ds=new DataSet();
sda.Fill(ds,"books");
return  ds.ToString();

} user add=new user();


this.dataGrid1.DataSource=add.Select();但这样行不通 请高手帮下咯

Answer 1

public DataTable Select()//更改返回类型
{
con=new SqlConnection("server=.;uid=sa;database=pubs");
sda=new SqlDataAdapter("select * from books where Name=" + user.name ,con);//写查询语句
ds=new DataSet();
sda.Fill(ds,"books");
//return  ds.ToString();换成下面
return ds.tables[0].DefaultView;
}user add=new user();
this.dataGrid1.DataSource=user.Select();

Answer 2

public DataTable Select()
{
con=new SqlConnection("server=.;uid=sa;database=pubs");
sda=new SqlDataAdapter("select * from books",con);
ds=new DataSet();
sda.Fill(ds,"books");
return  ds;}user add=new user();
this.dataGrid1.DataSource=add.Select();