| 标题 | 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(); |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。