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