public static void DisplayInvoice(CsInvoice invoice)
        {
            string iQuery = string.Format(@"
SELECT O.ORDERNO AS ORDERNO,
O.ORDERCUSTOMERNO AS CUSTOMERNO,
CONVERT(VARCHAR(11),CONVERT(DATE,O.ORDERDATE)) AS ORDERDATE,
(C.FNAME + ' ' + C.LNAME) AS NAME,
SUM(OI.ORDERITEMQTY) AS QTY,
FORMAT(SUM(OI.ORDERITEMUPRICE * OI.ORDERITEMQTY),'C','EN-US') AS NET,
FORMAT(SUM(OI.ORDERITEMUPRICE * OI.ORDERITEMQTY + OI.ORDERITEMTAX),'C','EN-US') AS GROSS
FROM TBLORDER O 
JOIN TBLORDERITEM OI ON O.ORDERNO = OI.ORDERID
JOIN TBLCUSTOMER C ON O.ORDERCUSTOMERNO = C.CUSTOMERID
GROUP BY O.ORDERNO,O.ORDERCUSTOMERNO,(C.FNAME + ' ' + C.LNAME),O.ORDERDATE
ORDER BY O.ORDERNO DESC;");

            cmdString = new SqlCommand(iQuery, cntString);

            try
            {
                cntString.Open();
                SqlDataAdapter da = new SqlDataAdapter(cmdString);
                DataSet        ds = new DataSet();
                da.Fill(ds);
                invoice.InvoiceList = ds.Tables[0];
            }

            finally
            {
                cntString.Close();
            }
        }
        // WHOLE LIST
        public void InvoiceListView()
        {
            CsInvoice list = new CsInvoice(InvoiceTable);

            try
            {
                ConnectionClass.DisplayInvoice(list);
                InvoiceList.DataSource = list.InvoiceList;
                InvoiceList.DataBind();
            }
            catch
            {
                TEST.Text = "Error Occured, Please try reloading page. Sorry for inconvenience";
            }

            finally
            {
            }
        }