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; }