.net 类库中连接数据库，经常连接数据库太麻烦了，怎么写一个类库，快速调用就可以连接数据库
.net 类库中连接数据库，经常连接数据库太麻烦了，怎么写一个类库，快速调用就可以连接数据库
[解决办法]
//写个操作数据库函数
public int ExecuteSql(string SQLString)
{
string connectionString = "Data Source=192.168.xx.xx;Initial Catalog=xx;User ID=xx;Pwd=xx";
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
//调用
string sql=string.Format("select * from xx");
ExecuteSql(sql);
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
namespace Test.DAL
{
public class BaseDAL
{
public static string connString = ConfigurationManager.AppSettings["sqlconn"];
}
}
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="sqlconn" value="Data Source=.; DataBase=tests; User ID=sa; Password=sql2005 "/>
</appSettings>
</configuration>
<appSettings>
<add key="sqlconn" value="Data Source=.; DataBase=DHHE; User ID=sa; Password=sa"/>
</appSettings>
return SqlHelper.ExecuteDataset(BaseDAL.connString, CommandType.Text, sql, parameter);
