public class BindUI
{
public static DataTable GetHouseTypeList()
{
string text1 = "SELECT Ht_ID, Ht_Name FROM HouseType ORDER BY Ht_OrderID";
return SQLDAL.SQLHelper.ExecuteDataTable(text1);
}
public static DataTable GetAreaList()
{
string text1 = "SELECT Area_ID, Area_Name FROM Area ORDER BY Area_OrderID";
return SQLDAL.SQLHelper.ExecuteDataTable(text1);
}
}
走HouseType 表中查出Ht_ID, Ht_Name 字段 并按照 Ht_OrderID 升序排序
sql语句的意思是查询Ht_ID, Ht_Name 这个两个字段并根据Ht_OrderID进行排序,然后将写好的sql语句返回到SQLDAL中进行访问数据库