public class Kjsql { private string m_strConnString; private SqlConnection m_connConnection; private string strDataSource; private string strInitialCatalog; private string strUserID; private string strPwd; public Kjsql() { strDataSource = Properties.Settings.Default.ServerAd; strInitialCatalog = Properties.Settings.Default.SqlName; strUserID = Properties.Settings.Default.UserSa; strPwd = Properties.Settings.Default.PSW; } //打开数据库 public void Open() { m_strConnString = "Data Source=" + strDataSource + ";Initial Catalog=" + strInitialCatalog + ";User ID=" + strUserID + ";Password=" + strPwd+";Connection Timeout=30"; m_connConnection = new SqlConnection(m_strConnString); m_connConnection.Open(); } //关闭数据库 public void Close() { m_connConnection.Close(); } //获取数据源 public DataSet FillDataSet(string strCommandString, string strTableName, DataSet dsDataSet) { SqlDataAdapter adAdapter = new SqlDataAdapter(); adAdapter.SelectCommand = new SqlCommand(strCommandString, m_connConnection); adAdapter.Fill(dsDataSet, strTableName); return dsDataSet; } //更新数据库 public bool UpData(string strCommandString, string strTableName, DataSet dsDataSet) { SqlDataAdapter adAdapter = new SqlDataAdapter(); adAdapter.SelectCommand = new SqlCommand(strCommandString, m_connConnection); SqlCommandBuilder ThisBuilder = new SqlCommandBuilder(adAdapter); adAdapter.Update(dsDataSet, strTableName); return true; } public void Insert(string InsertSql, SqlParameter[] parameters) { SqlCommand thiscommand = m_connConnection.CreateCommand(); thiscommand.CommandType = CommandType.StoredProcedure; thiscommand.CommandText = InsertSql; for (int i = 0; i < parameters.Length; i++) { thiscommand.Parameters.Add(parameters[i]); } thiscommand.ExecuteNonQuery(); }