public static Customer ExecuteReader(string sql) { Customer sub = new Customer(); SqlConnection con = new SqlConnection(); con.ConnectionString = CustomerAndBoatDatabase.getAppConfig(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; con.Open(); SqlDataReader ds = com.ExecuteReader(); while (ds.Read()) { sub.Phoneno = ds.GetString(2); sub.Address = ds.GetString(1); sub.Boat1 = new Boat(); sub.Boat1.Stateregistrationno = ds.GetString(3); sub.Boat1.Slipwayno = ds.GetInt32(5); sub.Boat1.Manufacturer = ds.GetString(4); sub.Boat1.Validity = ds.GetString(8); } con.Close(); return(sub); }
public static void ExecuteNonQuery(string sql) { SqlConnection con = new SqlConnection(); con.ConnectionString = CustomerAndBoatDatabase.getAppConfig(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; con.Open(); int k = com.ExecuteNonQuery(); con.Close(); }
public static object ExecuteScalar(string sql) { SqlConnection con = new SqlConnection(); con.ConnectionString = CustomerAndBoatDatabase.getAppConfig(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; con.Open(); object val = com.ExecuteScalar(); con.Close(); return(val); }
public static DataSet ExecuteDataSet(string sql) { SqlConnection con = new SqlConnection(); con.ConnectionString = CustomerAndBoatDatabase.getAppConfig(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; con.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = com; DataSet ds = new DataSet(); da.Fill(ds); con.Close(); return(ds); }
public static Slipway ExecuteReader1(string sql) { Slipway sub = new Slipway(); SqlConnection con = new SqlConnection(); con.ConnectionString = CustomerAndBoatDatabase.getAppConfig(); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = sql; con.Open(); SqlDataReader ds = com.ExecuteReader(); while (ds.Read()) { sub.Id = ds.GetInt32(5); sub.Name = ds.GetString(10); sub.Volume = ds.GetInt32(5); } con.Close(); return(sub); }