110,476
社区成员
发帖
与我相关
我的任务
分享
public partial class Adapter_Dataset : System.Web.UI.Page
{
static string strConnect = "Data Source=CYQ\\SQLEXPRESS;Initial Catalog=mydb;User ID=sa;Password=sa;Persist Security Info=false;";
string strCommand;
SqlConnection sc = new SqlConnection(strConnect);
SqlDataAdapter sda;
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
strCommand = "select * from student";
sda = new SqlDataAdapter(strCommand, strConnect);
sda.Fill(ds, "tt");
GridView1.DataSource = ds.Tables["tt"].DefaultView ;
GridView1.DataBind();
}
}
public partial class Adapter_Dataset : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
static string strConnect = "Data Source=CYQ\\SQLEXPRESS;Initial Catalog=mydb;User ID=sa;Password=sa;Persist Security Info=false;";
string strCommand;
SqlConnection sc = new SqlConnection(strConnect);
SqlDataAdapter sda;
DataSet ds = new DataSet();
strCommand = "select * from student";
sda = new SqlDataAdapter(strCommand, strConnect);
sda.Fill(ds, "tt");
GridView1.DataSource = ds.Tables["tt"].DefaultView ;
GridView1.DataBind();//窗体应用程序不需要此语句
}
}