1.数据库DBHELper:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace FalutWinform
{
public class DBHelper
{
private static SqlConnection connection;
/// <summary>
/// 数据库链接字符串
/// </summary>
public static SqlConnection Connection
{
get
{
string connectionString = String.Format("SERVER='{0}';DataBase='{1}';UID='{2}';PWD='{3}'", From_PIC.Properties.Settings.Default.SERVER,From_PIC.Properties.Settings.Default.DataBase,
From_PIC.Properties.Settings.Default.UID,From_PIC.Properties.Settings.Default.PWD);
if (connection==null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State==System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State==System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}
///执行无参数数据库命令,返回执行结果
public int ExecuteCommand(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, Connection);
int result = cmd.ExecuteNonQuery()