ดึงข้อมูลจาก Database มาโชว์ใน DropDownList
strsqlLoad = "SELECT DISTINCT(iCompany),Company_Name FROM Company_Trns"; DBdsLoad = objConn.Execute2Table(strsqlLoad, 1);
ddlCompany.DataSource = DBdsLoad;
ddlCompany.DataTextField = "Company_Name";
ddlCompany.DataValueField = "iCompany";
ddlCompany.DataBind();
foreach (DataRow dr in DBdsLoad.Tables[0].Rows)
{
}
strsqlLoad = "SELECT DISTINCT(iCompany),Company_Name FROM Company_Trns"; DBdsLoad = objConn.Execute2Table(strsqlLoad, 1);
ddlCompany.DataSource = DBdsLoad;
ddlCompany.DataTextField = "Company_Name";
ddlCompany.DataValueField = "iCompany";
ddlCompany.DataBind();
foreach (DataRow dr in DBdsLoad.Tables[0].Rows)
{
ListItem Litemcompany = new
ListItem();
Litemcompany.Text =
dr["company_name"].ToString().Trim();
Litemcompany.Value =
dr["icompany"].ToString();
ddlCompany.Items.Add(Litemcompany);
ddlCompany.DataSource = DBdsLoad;
}
ความคิดเห็น