public void showCarregi()
{
model m = new model();
m.open();
DataTable dt = m.multipleTableQuery("carcompany.carcompanyname,cartype.cartype,carmodel.carmodelname,carsubmodel.carsubmodelname,carregi.*", "(((carregi INNER JOIN carcompany ON carregi.carcompanyid=carcompany.carcompanyid)INNER JOIN cartype ON carregi.cartypeid=cartype.cartypeid)INNER JOIN carmodel ON carregi.carmodelid=carmodel.carmodelid)INNER JOIN carsubmodel ON carregi.carsubmodelid=carsubmodel.carsubmodelid", "carregi.isdelete='1'");
CarRegiRepeater.DataSource = dt;
CarRegiRepeater.DataBind();
m.close();
}
public void showDept()
{
model m = new model();
m.open();
DataTable dt = m.show("depttbl");
CarRegiRepeater.DataSource = dt;
CarRegiRepeater.DataBind();
m.close();
}
private void showInquirydata()
{
model m = new model();
m.open();
DataTable dt = m.show("carinquiry");
CarRegiRepeater.DataSource = dt;
CarRegiRepeater.DataBind();
m.close();
}
public void showsalesmanName()
{
model m = new model();
m.open();
DataTable dt = m.multipleTableQuery("salesmantbl.*", "salesmantbl", "salesmantbl.isdelete='1'");
CarRegiRepeater.DataSource = dt;
CarRegiRepeater.DataBind();
m.close();
}