string storeList = ""; // The string that will contain the stores that the user selected
protected void Page_Load(object sender, EventArgs e)
{
// Only run on initial page load
if (!IsPostBack)
{
// Populate the checked box with data from the store table
tStoreTableAdapter storeTableAdapter = new tStoreTableAdapter();
dsStore.tStoreDataTable storeDataTable = storeTableAdapter.GetData();
cbStore.DataTextField = "StoreWithAddress";
cbStore.DataValueField = "Store";
cbStore.DataSource = storeDataTable;
cbStore.DataBind();
}
}
/// <summary>
/// Populate the dropdown and checkboxlist with appropriately formatted data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OpenConnection();
//Populating the Product dropdown.
tProductTableAdapter productTypeAdapter = new tProductTableAdapter();
ds_Products.tProductDataTable products = productTypeAdapter.GetData();
/*
* Ref for below code: http://stackoverflow.com/questions/1143639/binding-multiple-fields-to-listbox-in-asp-net/
* In all honesty not entirely sure how this works...
* Is this kinda like a Lambda Function?
* Specifically looked for this though to keep formatting out of the data layer.
*/
EnumerableRowCollection productData = from product in products
select new
{
Name = product.Name + " - " + product.Description + " :by " + product.Manufacturer,
Id = product.ProductID
};
//end code I don't fully understand
//The rest is just normal data binding.
ddProducts.DataSource = productData;
ddProducts.DataTextField = "Name";
ddProducts.DataValueField = "Id";
ddProducts.DataBind();
//Use dataset to populate check box list
tStoreTableAdapter storeTypeAdapter = new tStoreTableAdapter();
ds_Store.tStoreDataTable storeDataTable = storeTypeAdapter.GetData();
cblStores.DataTextField = "StoreString";
cblStores.DataValueField = "StoreID";
cblStores.DataSource = storeDataTable;
cblStores.DataBind();
cblStores.SelectedIndex = 0;
}
}