public void FillGrid()
{
SqlLite sq = new SqlLite();
sq.SetDataGridSourse(ref Dg1, "Select t1.orderid,t2.prodid,t2.qty from orders t1 join ordersD t2 on t1.orderid=t2.orderid where t1.userid = '" + orderUser + "' and orderstate = 1 and t1.orderid in (select max(orderid) from orders where userid = '" + orderUser + "' and orderstate = 1) ");
// если не указать имя - возьмет с sql, никаких варнингов.
}
public void FillGrid()
{
SqlLite sq = new SqlLite();
sq.SetDataGridSourse(ref DG, "Select * from Products order by ProdID");
// если не указать имя - возьмет с sql, никаких варнингов.
DG.Columns[0].Header = "ProdID";
DG.Columns[1].Header = "ProdName";
DG.Columns[2].Header = "Quantity";
DG.Columns[3].Header = "price";
}
