using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace UseAdo
{
public class DBHelper
{
//连接字符串
public static readonly string ConnectionString = ConfigurationManager.ConnectionStrings["SQLConn"].ToString();
//非查询操作
public static int ExecuteNonQuery(string commandText, CommandType commandType, params SqlParameter[] param)
{
int count = 0;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = commandText;
cmd.CommandType = commandType;