DBHelper(带参数C#)_冶金矿山地质_工程科技_专业资料 - DBHelper(带...

2023年6月21日发(作者：)

usingusingusingusingusingusingSystem;c;;;ent;uration;{publicstaticclassDBHelper{privatestaticSqlConnectionconnection;publicstaticSqlConnectionConnection{get{stringconnectionString=tionStrings["MyBookShop"].ConnectionString;if(connection==null){connection=newSqlConnection(connectionString);();}elseif(==){();}elseif(==){();();}returnconnection;}}publicstaticintExecuteCommand(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);intresult=eNonQuery();returnresult;}publicstaticintExecuteCommand(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);eNonQuery();}publicstaticintGetScalar(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);intresult=32(eScalar());returnresult;}publicstaticintGetScalar(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);intresult=32(eScalar());returnresult;}publicstaticSqlDataReaderGetReader(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);SqlDataReaderreader=eReader();returnreader;}publicstaticSqlDataReaderGetReader(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);SqlDataReaderreader=eReader();returnreader;}publicstaticDataTableGetDataSet(stringsafeSql){DataSetds=newDataSet();SqlCommandcmd=newSqlCommand(safeSql,Connection);SqlDataAdapterda=newSqlDataAdapter(cmd);(ds);[0];}publicstaticDataTableGetDataSet(stringsql,paramsSqlParameter[]values){}}}DataSetds=newDataSet();SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);SqlDataAdapterda=newSqlDataAdapter(cmd);(ds);[0];

2023年6月21日发(作者：)

usingusingusingusingusingusingSystem;c;;;ent;uration;{publicstaticclassDBHelper{privatestaticSqlConnectionconnection;publicstaticSqlConnectionConnection{get{stringconnectionString=tionStrings["MyBookShop"].ConnectionString;if(connection==null){connection=newSqlConnection(connectionString);();}elseif(==){();}elseif(==){();();}returnconnection;}}publicstaticintExecuteCommand(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);intresult=eNonQuery();returnresult;}publicstaticintExecuteCommand(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);eNonQuery();}publicstaticintGetScalar(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);intresult=32(eScalar());returnresult;}publicstaticintGetScalar(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);intresult=32(eScalar());returnresult;}publicstaticSqlDataReaderGetReader(stringsafeSql){SqlCommandcmd=newSqlCommand(safeSql,Connection);SqlDataReaderreader=eReader();returnreader;}publicstaticSqlDataReaderGetReader(stringsql,paramsSqlParameter[]values){SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);SqlDataReaderreader=eReader();returnreader;}publicstaticDataTableGetDataSet(stringsafeSql){DataSetds=newDataSet();SqlCommandcmd=newSqlCommand(safeSql,Connection);SqlDataAdapterda=newSqlDataAdapter(cmd);(ds);[0];}publicstaticDataTableGetDataSet(stringsql,paramsSqlParameter[]values){}}}DataSetds=newDataSet();SqlCommandcmd=newSqlCommand(sql,Connection);ge(values);SqlDataAdapterda=newSqlDataAdapter(cmd);(ds);[0];