菜鸟数据库连接问题!
这两种数据库连接效果都是一样的,有什么区别,应该用那一种。能详细说一下吗?谢谢。
1、
SqlConnection con = new SqlConnection("server=.;database=qzb;uid=sa;pwd=;");
con.Open();
SqlCommand cmd = new SqlCommand("select * from qzb1", con);
SqlDataReader sdr = cmd.ExecuteReader();
GridView1.DataSource = sdr;
GridView1.DataBind();
sdr.Close();
con.Close();
2、
SqlConnection con = new SqlConnection("data source=.;database=qzb; user=sa;password=;");
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from qzb1", con);
da.Fill(ds, "Name");
GridView1.DataSource = ds.Tables["Tab"];
GridView1.DataMember = "qzb1";
GridView1.DataBind();
我是个新手,不胜感激!