public void CustomerListView()
{
CsCustomerlist customerlists = new CsCustomerlist(CustomerTable);
try
{
ConnectionClass.GetCustomerList(customerlists);
cListBoard.DataSource = customerlists.customerList;
cListBoard.DataBind();
}
catch
{
testlabel.Text = "fail";
}
finally
{
}
}
public static void GetCustomerList(CsCustomerlist customertable)
{
string dQuery = string.Format(@"SELECT CUSTOMERID AS NO,(fName + ' '+ lName ) AS NAME,
EMAIL AS 'E-MAIL',CITY AS 'CITY',PROVINCE AS 'PROVINCE',
CONVERT(VARCHAR, REGISTERDATE,106) AS 'REGISTER DATE' FROM TBLCUSTOMER
ORDER BY CUSTOMERID DESC;");
cmdString = new SqlCommand(dQuery, cntString);
try
{
cntString.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdString);
DataSet ds = new DataSet();
da.Fill(ds);
customertable.customerList = ds.Tables[0];
}
finally
{
cntString.Close();
}
}
