C#数据库帮助类,包括新建数据库,删除数据库,还原数据库
数据库连接字符串从配置文件读取。
代码
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
namespace Maticsoft.DBUtility
{
/// <summary>
/// 数据访问抽象基础类
/// </summary>
public abstract class DbHelperSQL
{
// <?xml version="1.0" encoding="utf-8" ?>
// <configuration>
// <appSettings>
// <!--连接主程序的字符串-->
// <add key="connection" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=syt"/>
// <!---->
// <add key="connectionzt" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=syt_qwerthjkl"/>
// <!--连接主SQLServer 的字符串-->
// <add key="ConnectServer" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=master"/>
// <!--建立数据库的连接字符串-->
// <add key="connInit" value="data source=CONTRON-CAD9158;user id=sa;password=sa;persist security info=false;packet size=4096"/>
// <!--SQLServer安装目录-->
// <add key="sqlServerData" value="C:Program FilesMicrosoft SQL ServerMSSQLData"/>
// </appSettings>
// </configuration>
//数据库连接字符串(web.config来配置),可以动态更改connectionString支持多数据库.
public static string connectionString = PubConstant.ConnectionString;
public static string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connection"];
public
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
namespace Maticsoft.DBUtility
{
/// <summary>
/// 数据访问抽象基础类
/// </summary>
public abstract class DbHelperSQL
{
// <?xml version="1.0" encoding="utf-8" ?>
// <configuration>
// <appSettings>
// <!--连接主程序的字符串-->
// <add key="connection" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=syt"/>
// <!---->
// <add key="connectionzt" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=syt_qwerthjkl"/>
// <!--连接主SQLServer 的字符串-->
// <add key="ConnectServer" value="server=CONTRON-CAD9158;uid=sa;pwd=sa;database=master"/>
// <!--建立数据库的连接字符串-->
// <add key="connInit" value="data source=CONTRON-CAD9158;user id=sa;password=sa;persist security info=false;packet size=4096"/>
// <!--SQLServer安装目录-->
// <add key="sqlServerData" value="C:Program FilesMicrosoft SQL ServerMSSQLData"/>
// </appSettings>
// </configuration>
//数据库连接字符串(web.config来配置),可以动态更改connectionString支持多数据库.
public static string connectionString = PubConstant.ConnectionString;
public static string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connection"];
public
补充:软件开发 , C# ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,
部份技术文章来自网络,