c# 连接数据库类

最新推荐文章于 2025-12-03 13:04:04 发布

原创最新推荐文章于 2025-12-03 13:04:04 发布 · 381 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #c# #string #dataset #parameters #insert

本文介绍了一个使用C#进行SQL数据库操作的简单类库，包括数据库连接、数据读取及更新等功能。通过实例展示了如何建立数据库连接、执行SQL命令填充数据集以及更新数据库等常见操作。

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(); }