using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using SqlData = System.Data.SqlClient.SqlDataAdapter;
namespace DAL
{
public class SqlHelper
{
public static string connstr = "server=DESKTOP-4HM5BLU;uid=sa;pwd=123456;database=hotel";
//查询
public static DataTable ExcuteTable(string sql,params SqlParameter[] sqlParameters)
{
using (SqlData sda = new SqlData(sql, connstr))
{
if (sqlParameters != null && sqlParameters.Count() > 0)
sda.SelectCommand.Parameters.AddRange(sqlParameters);
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
return dt;
}
}
}