2005中自带了SQLDATASOURCE这个数据源,但我认为这样破坏架构,所以按2003里新写了个数据源,代码如下:
public SqlConnection Conn;
public SqlDataAdapter Sda;
public SqlDataSource Ds;
public DataTable Dt;
protected void Page_Load(object sender, EventArgs e)
{
Conn = new SqlConnection("Data Source=.;Initial Catalog=pubs;User ID=sa");
Sda = new SqlDataAdapter("select * from authors", Conn);
Ds = new SqlDataSource();
Dt = new DataTable();
Sda.Fill(Dt);
GridView1.DataSource = Dt;
GridView1.DataBind();
}
但是却没有数据显示,请问这是为什么??
另:如用2005自带的数据源,代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource1.SelectCommand = TextBox1.Text;
GridView1.DataBind();
}
也没有数据显示,请问我该如何解决,谢谢
public SqlConnection Conn;
public SqlDataAdapter Sda;
public SqlDataSource Ds;
public DataTable Dt;
protected void Page_Load(object sender, EventArgs e)
{
Conn = new SqlConnection("Data Source=.;Initial Catalog=pubs;User ID=sa");
Sda = new SqlDataAdapter("select * from authors", Conn);
Ds = new SqlDataSource();
Dt = new DataTable();
Sda.Fill(Dt);
GridView1.DataSource = Dt;
GridView1.DataBind();
}
但是却没有数据显示,请问这是为什么??
另:如用2005自带的数据源,代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource1.SelectCommand = TextBox1.Text;
GridView1.DataBind();
}
也没有数据显示,请问我该如何解决,谢谢
Ds = Dt;
//GridView的数据源为Ds
GridView1.DataSource = Ds;