SQL数据库连接
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using System.Web; using System.Web.Configuration; using System.Configuration; namespace DAL { public class cls_SQLFunction { string connectionString = "" ; System.Configuration.ConnectionStringSettings connString = System.Configuration.ConfigurationManager.ConnectionStrings[ "K3ConnectionString" ]; /// <summary> /// 读取数据库 /// </summary> /// <param name="ComTxt">数据库查询语句</param> /// <param name="TableName">表名</param> /// <returns>查询结果——数据集</returns> public DataSet Read_DataSet( string ComTxt, string TableName) { try { if ( null != connString) { connectionString = connString.ConnectionString; } SqlConnection con; SqlCommand selectcmd; con = new SqlConnection(connectionString); con.Open(); selectcmd = new SqlCommand(); selectcmd.CommandText = ComTxt; selectcmd.CommandTimeout = 1800; SqlDataAdapter adapter = new SqlDataAdapter(selectcmd.CommandText, con); adapter.SelectCommand.CommandTimeout = 1800; DataSet ds = new DataSet(); adapter.Fill(ds, TableName); DataTable dt = ds.Tables[TableName]; con.Close(); return ds; } catch { DataSet ds = new DataSet(); ds = null ; return ds; } } //-------------------------------------------------------------------------------- /// <summary> /// 插入、删除、修改数据库 /// </summary> /// <param name="ComTxt">SQL语句</param> public bool SQLUpdate( string ComTxt) { try { if ( null != connString) { connectionString = connString.ConnectionString; } SqlConnection con; SqlCommand selectcmd; con = new SqlConnection(connectionString); con.Open(); selectcmd = new SqlCommand(); selectcmd.Connection = con; selectcmd.CommandText = ComTxt; //执行TSQL、表名、存储过程、一段SQL语句 selectcmd.ExecuteNonQuery(); con.Close(); return true ; } catch { return false ; } } //-------------------------------------------------------------------------------- /// <summary> /// 数据库二进制数据写入 /// </summary> /// <param name="ComTxt">SQL语句</param> /// <param name="File">文件二进制流</param> /// <returns>是否写入成功</returns> public bool SQLUpdate_Photo( string ComTxt, byte [] File) { try { if ( null != connString) { connectionString = connString.ConnectionString; } SqlConnection con; SqlCommand selectcmd; con = new SqlConnection(connectionString); con.Open(); selectcmd = new SqlCommand(ComTxt, con); selectcmd.Parameters.Add( "@File" , SqlDbType.Image); selectcmd.Parameters[0].Value = File; selectcmd.ExecuteNonQuery(); con.Close(); return true ; } catch { return false ; } } } } |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步