三套路-----增删改

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();