//Author: Marc / Andreas public DataTable GridGetProducts() { Sql_Connection sqlCon = new Sql_Connection(); sda = new SqlDataAdapter($"Select * from Product", sqlCon.Connection()); dt = new DataTable(); sda.Fill(dt); return(dt); }
public DataTable GridGetCities() { Sql_Connection sqlCon = new Sql_Connection(); sda = new SqlDataAdapter($"Select * from zipCode", sqlCon.Connection()); dt = new DataTable(); sda.Fill(dt); return(dt); }
//Author: Marc / Andreas public DataTable GridGetCustomers() { Sql_Connection sqlCon = new Sql_Connection(); sda = new SqlDataAdapter($"Select CustomerId, Name, Adress, ZipCode from Customer", sqlCon.Connection()); dt = new DataTable(); sda.Fill(dt); return(dt); }
public DataTable GridGetFrameSpec(int productID) { Sql_Connection sqlCon = new Sql_Connection(); sda = new SqlDataAdapter($"Select * from Frame WHERE productID = {productID}", sqlCon.Connection()); dt = new DataTable(); sda.Fill(dt); return(dt); }