Binding data from database to datagrid combo box
HI,I have a combo box in datagrid. I need to get data from database and on page load I have to bind data to combobox datagrid.
Any code or links...
Regards,
protected void dg_OnItemDataBound(object sender,DataGridItemEventArgs e)
{
if((e.Item.ItemType == ListItemType.Item) ||
(e.Item.ItemType == ListItemType.AlternatingItem))
{
ComboBox cmb=(ComboBox)e.Item.FindControl("cmb1");
cmb.DataSource=ds;
cmb.DataTextField="text";
cmb.DataValueField="value";
cmb.DataBind();
}
}
puiblic void Item_Bound(Object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
Label PriceLabel = (Label)e.Item.FindControl("PriceLabel");
PriceLabel.BackColor = System.Drawing.Color.Red;
}
}