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