private static DataTable GetDataTable(string sql)
{
DataTable table = new DataTable();
DBUtility.SqlDbHelper s = new SqlDbHelper();
using (var conn = s.GetConnection())
{
if (conn.State == ConnectionState.Closed) conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader sdr = comm.ExecuteReader();
table.Load(sdr);
}
return table;
}
private static int exec_sql(string sql1)
{
var row_out = 0;
using (var conn = new SqlDbHelper().GetConnection())
{
if (conn.State == ConnectionState.Closed) conn.Open();
using (var cmd = new SqlCommand(sql1, conn))
{
int row = cmd.ExecuteNonQuery();
row_out = row;
}
}
return row_out;
}
