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