| 标题 | ADO.NET增删查改小总结 |
| 内容 | 三套路-----增删改 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(); |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。