SqlConnection myConnection = new SqlConnection("server=localhost;uid=sa;pwd=;database=test");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles order by id desc", myConnection);
myConnection.open();
DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles");
myConnection.close();
DataGrid1.DataSource = ds.Tables["Titles"].DefaultView;
DataGrid1.DataBind();
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles order by id desc", myConnection);
myConnection.open();
DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles");
myConnection.close();
DataGrid1.DataSource = ds.Tables["Titles"].DefaultView;
DataGrid1.DataBind();
不要open的不是这个写法。
DataGrid1.DataSource = ds.Tables[0].DefaultView;
DataGrid1.DataBind();