当前位置：首页 -> 技术开发 -> NET专区 -> 三个通用代码

三个通用代码

时间： 2021-07-31 作者：daque

public sqlconnection connection_database(string server,string database,string userid,string password) { string str_con; str_con="server="+server+";"+"database="+database+";"+"user id="+userid+";"+"password="+password; try { sqlconnection sqlcon=new sqlconnection (str_con); sqlcon.open(); return sqlcon; } catch { messagebox.show("数据库贯穿不可功!请精确填写好数据库树立","缺点",messageboxbuttons.ok,messageboxicon.stop); application.exit();//运用步调退出 return null; } }public dataview dvlist(string logstring,string tablename) //归来相映表的视图. { if( sqlconn.state == connectionstate.closed) sqlconn.open(); sqldataadapter mycommand = new sqldataadapter(logstring, sqlconn); dataset ds = new dataset(); try { mycommand.fill(ds, "+tablename+"); } catch { messagebox.show("error"); } dataview dv = new dataview(); dv = ds.tables["+tablename+"].defaultview; return dv; } public void execute_sql(string sql,sqlconnection sqlconn)//通用实行sql因变量 { // 翻开数据库贯穿 if( sqlconn.state == connectionstate.open) sqlconn.close(); sqlconn.open(); sqlcommand cmd = new sqlcommand(sql, sqlconn); try { cmd.executenonquery(); } catch(sqlexception ae) { messagebox.show(ae.message.tostring()); } cmd.dispose(); } public void show_listview_data(string select_str,string tablename,listview lv)//通用的归来树视图因变量 { //lv=new listview(); lv.clear(); this.sqldataadapter1=new sqldataadapter(select_str,this.sqlconn); sqldataadapter1.fill(dataset21,"+tablename+"); //增添列名 for(int i=0;i<dataset21.tables["+tablename+"].columns.count;i++) { lv.columns.add(dataset21.tables["+tablename+"].columns[i].columnname.tostring(),90,horizontalalignment.left); } //增添行（数据库数据） for(int j=0;j<dataset21.tables["+tablename+"].rows.count;j++) { listviewitem item=lv.items.add(dataset21.tables["+tablename+"].rows[j][0].tostring()); item.text=dataset21.tables["+tablename+"].rows[j][0].tostring(); for(int i=1;i<dataset21.tables["+tablename+"].columns.count;i++) item.subitems.add(dataset21.tables["+tablename+"].rows[j][i].tostring()); } lv.view=view.details; } }

三个通用代码

相关推荐

推荐下载

热门阅览

最新排行