ADO.NET增删查改小总结

来源:网络时间:2011-06-23

  三套路-----增删改

  Code

  1 using System.Data.SqlClient;

  2

  3 SqlConnection conn = new SqlConnection("xxx");

  4

  5

  6 string sql = "xxx";

  7

  8 SqlCommand comm = new SqlCommand(sql, conn);

  9

  10 conn.Open();

  11

  12 comm.ExecuteNonQuery();

  13

  14 conn.Close();

  三套路-----查(绑定到DataGridView

  Code

  1 using System.Data.SqlClient;

  2

  3 SqlConnection conn = new SqlConnection("xxx");

  4

  5 string sql = "xxx";

  6

  7 SqlDataAdapter da = new SqlDataAdapter(sql, conn);

  8

  9 DataSet ds = new DataSet();

  10

  11 da.Fill(ds);

  12

  13 dataGridView1.DataSource = ds.Tables[0];

  14

  15 //要更新 查询语句要 查询主键列

  16

  17 SqlCommandBuilder sd = new SqlCommandBuilder(da);

  18

  19 da.Update(ds.Tables[0]);

  三套路----查(绑定到ListView)

  代码

  using System.Data.SqlClient;

  SqlConnection conn = new SqlConnection("xxx");

  string sql = "xx";

  SqlCommand comm = new SqlCommand(sql, conn);

  conn.Open();

  SqlDataReader read = comm.ExecuteReader();

  while (read.Read())

  {

  ListViewItem lvi = new ListViewItem(read["xxx"].ToString());

  lvi.Tag = read["id"];

  listView1.Items.Add(lvi);

  lvi.SubItems.AddRange(new String[] { read["xxx"].ToString() });

  }

  read.Close();

  conn.Close();

发表评论

最新评论(共0条)