using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace HoteManage
{
class DBHelper
{
private static string connectionString = “Data Source=(LocalDB);Initial Catalog=Hotel;Integrated Security=True”;
public static int ExecuteSq1(string SQLString)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(SQLString, connection);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch
(System.Data.SqlClient.SqlException e)
{
connection.Close();
throw e;
}
}
public static DataSet GetDataSet(string SQLString)
{
SqlCon