三套路-----增删改

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

更多信息请查看IT技术专栏