第一种: DataTable 对象查询数据
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlDataAdapter da = new SqlDataAdapter(“select * from student”, conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
第二种:DataSet对象查询数据
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlDataAdapter da = new SqlDataAdapter(“select * from student”, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.GridView1.DataSource = ds;
// this.GridView1.DataSource = ds.Tables[0]; //这种数据源赋值语句都可以
this.GridView1.DataBind();
第三种:DataTable对象与DataSet对象查询数据1
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlDataAdapter da = new SqlDataAdapter(“select * from student”, conn);
DataTable dt = new DataTable();
//DataTable dt = new DataTable(“cj”);//定义一个有别名的数据表,
da.Fill(dt);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
this.GridView1.DataSource = ds;
// this.GridView1.DataSource = ds.Tables[0]; //这种数据源赋值语句都可以(只有一个表)
//this.GridView1.DataSource = ds.Tables[“cj”];//别名作为索引(有若干个表)
//this.GridView1.DataSource = ds.Tables[2];//序号作为索引(ds中的第三个表)
this.GridView1.DataBind();
第四种:DataTable对象与DataSet 对象查询数据2
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlDataAdapter da = new SqlDataAdapter(“select * from student”, conn);
DataTable dt = new DataTable(“cj”);//定义一个有别名的数据表,
DataSet ds = new DataSet();
ds.Tables.Add(dt);
da.Fill(ds,”cj”);
this.GridView1.DataSource = ds;
// this.GridView1.DataSource = ds.Tables[0]; //这种数据源赋值语句都可以(只有一个表)
//this.GridView1.DataSource = ds.Tables[“cj”];//别名作为索引(有若干个表)
//this.GridView1.DataSource = ds.Tables[2];//序号作为索引(ds中的第三个表)
this.GridView1.DataBind();
第五种: DataView对象查询数据
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlDataAdapter da = new SqlDataAdapter(“select * from student”, conn);
DataTable dt = new DataTable();
da.Fill(dt);
DataView dv = dt.DefaultView;
//DataView dv = new DataView(dt);
//DataView dv = dt.DefaultView;
// DataView dv =ds.Tables[0].DefaultView;
dv.RowFilter = “age>15 and age<30”;
dv.Sort = “age desc”;
this.GridView1.DataSource = dv;
this.GridView1.DataBind();
第六种: SqlDataReader 对象进行数据查询1
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlCommand comm = new SqlCommand(“select * from student”, conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader();
this.GridView1.DataSource = dr;
this.GridView1.DataBind();
dr.Close();
conn.Close();
第七种: SqlDataReader 对象进行数据查询2
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlCommand comm = new SqlCommand(“select * from student”, conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
//根据dr[索引]对这行数据进行处理
}
dr.Close();
conn.Close();
第八种:数据查询 ExecuteScalar()
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlCommand comm = new SqlCommand(“select * from student”, conn);
conn.Open();
int n = comm.ExecuteScalar();//获得查询结果的第一行第一个单元格数据
conn.Close();
第九种:对数据库进行“增 删 改” 操作
SqlConnection conn = new SqlConnection(“server=CF1BFWRIM2DKXJ;database=PM;uid=sa;pwd=123456;”);
SqlCommand comm = new SqlCommand(“delete from student where id=5”, conn);
//由sql语句确定采取 增 删 改的哪种操作
conn.Open();
int nums = comm.ExecuteNonQuery();
conn.Close();