ERROR [57014] ERROR: canceling statement due to statement timeout; Error while executing the query
conn.Open() da = New OdbcDataAdapter("select poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6) as Bulan, detail_trans.item_name, sum(detail_trans.qty_item) as qty, detail_trans.price_exctax from poss_tenants inner join " & _ "detail_trans on poss_tenants.poss_id=detail_trans.poss_id where detail_trans.trans_time between '" & date1.Text & "' and '" & date2.Text & "' and detail_trans.poss_id='" & possidtxt.Text & "' and detail_trans.type='ITEM' " & _ "group by poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6),detail_trans.item_name,detail_trans.price_exctax order by qty asc limit 15", conn) ds = New DataSet ds.Clear() da.Fill(ds, "top15") conn.Close() dgv1.DataSource = (ds.Tables("top15")) conn.Close()
da = New OdbcDataAdapter("select poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6) as Bulan, detail_trans.item_name, sum(detail_trans.qty_item) as qty, detail_trans.price_exctax from poss_tenants inner join " & _ "detail_trans on poss_tenants.poss_id=detail_trans.poss_id where detail_trans.trans_time between '" & date1.Text & "' and '" & date2.Text & "' and detail_trans.poss_id='" & possidtxt.Text & "' and detail_trans.type='ITEM' " & _ "group by poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6),detail_trans.item_name,detail_trans.price_exctax order by qty asc limit 15", conn)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)