110,567
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0"?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="connstr" connectionString="Data Source=192.168.3.88; Initial Catalog=HRMSYSDB;User ID=sa;Password=123456" />
<add name="connstr1" connectionString="Data Source=192.168.3.88; Initial Catalog=HRMSYSDB1;User ID=sa;Password=123456" />
<add name="connstr2" connectionString="Data Source=192.168.3.88; Initial Catalog=HRMSYSDB2;User ID=sa;Password=123456" />
</connectionStrings>
<appSettings>
<add key="passwordSalt" value="love?P3@9"/>
<add key="aaa" value="333"/>
</appSettings>
<startup useLegacyV2RuntimeActivationPolicy="true"><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup></configuration>
这个是App.config 文件代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace HRMSys.DAL
{
static class SqlHelper
{
//app.config文件的继承:
public static readonly string connstr =
ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
public static int ExecuteNonQuery(string sql,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
}
}
public static object ExecuteScalar(string sql,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteScalar();
}
}
}
public static DataTable ExecuteDataTable(string sql,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
return dataset.Tables[0];
}
}
}
这个事SqlHelper.cs 也是就是做了个数据增删改查的封装, 我就是不懂界面用户选择,这两个文件里写不进if判断语句