摘要:
usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Collections;namespaceSystemDAO{///<summary>///数据库的通用访问代码苏飞修改//////此类为抽象类,///不允许实例化,在应用时直接调用即可///</summary>publicabstractclassSqlHelper{///<summary>///数据库连接字符串///< 阅读全文
摘要:
View Code public int ExecuteSql(List<string> listsql) { OleDbCommand command = null; try { Open(); command.Connection = conn; command.Transaction = conn.BeginTransaction(); int i=0; foreach (string sql in listsql) { command.CommandText = sql; i += command.ExecuteNonQuery(); } command.Transact 阅读全文
摘要:
View Code /// PageList for DataReader /// </summary> /// <param name="connectionString"></param> /// <param name="sql"></param> /// <param name="pageSize"></param> /// <param name="curPage"></param> /// < 阅读全文
摘要:
View Code public static string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; /// <summary> /// 执行存储过程,返回SqlDataReader ( 注意:调用该方法后,一定要对SqlDataReader进行Close ) /// </summary> /// <param name="storedProc 阅读全文
摘要:
using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Collections; using HelloWinForm.DBUtility; using System.Windows.Forms; namespace HelloWinForm.DAL { class Student { SQLHelper sqlHelper = new SQLHelper();//非静态方法,需要实例化类 /// 阅读全文
摘要:
/// <summary> /// 获取对固定列不重复的新DataTable /// </summary> /// <param name="dt">含有重复数据的DataTable</param> /// <param name="colName">需要验证重复的列名</param> /// <returns>新的DataTable,colName列不重复</returns> private DataTable GetDistinctTable(DataTa 阅读全文
摘要:
public override DataTable GetUserDataDTList(string excelPath) 02. 03. { 04. 05. excelPath = excelPath.Trim(); 06. 07. string filename = null; 08. 09. try 10. 11. { 12. 13. filename = System.Configuration.ConfigurationSettings.AppSettings["filename"].ToString(); 14. 15. } 16. 17. catch(Exce 阅读全文
摘要:
MSDN编程皇冠交流总群130945818,从这里开始.编程 技术.综合交流 阅读全文