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