How to set Combobox is Slect Option And then Bind Data

Question

LINQ

var query = (from p in db.Tbl
select new
{
p.PartNo
}).ToList();

// Combobox1.Items.Insert(1, "Select Part No");
Combobox1.DataSource = query;
Combobox1.DisplayMember = "tblPartMaster_PartNo";
Combobox1.ValueMember = "tblPartMaster_PartNo";

How to set Combobox is Slect Option And then Bind Data in Combobox

My Blog: http://aspnettutorialscode.blogspot.in/

Thank You

Manish Kumar Choudhary · Answer

HI sir it working check it private void Form1_Load( object sender EventArgs e) { EmployeesDBContext db = new EmployeesDBContext (); var items = ( from c in db.Departments orderby c.DeptId ascending select c).ToList(); items.Insert(0 new Department { DeptId = 0 DeptName = --Select-- }); cmb1.BindingContext = new BindingContext (); cmb1.DataSource = items; cmb1.DisplayMember = DeptName ; cmb1.ValueMember = DeptId ; } in above departments table two filed is there 1.DeptName 2.DeptId it displaying fine. share ur code if not working yet.

Saber Shaikh · Answer

var tempValue = new { tblTestMaster_TestType = -- Select Test Type-- }; Query.Insert(0 tempValue); Cmb_TestType.BindingContext = new BindingContext(); Cmb_TestType.DataSource = Query; This is done

Saber Shaikh · Answer

try it but not working can u give me other option

Manish Kumar Choudhary · Answer

Hi saber shaikh  do something like One way would be to insert the --Select-- contact place-holder into the results before binding: var items = (from c in db.Contacts orderby c.Name ascending select c).ToList(); items.Insert(0 new Contact { ID = 0 Name = --Select-- }); cmb1.BindingContext = new BindingContext(); cmb1.DataSource = items; cmb1.DisplayMember = Name; cmb1.ValueMember = ID; Or you could do the same thing with an anonymous version of the results: var items = (from c in db.Contacts orderby c.Name ascending select new { c.ID c.Name }).ToList(); items.Insert(0 new { ID = 0 Name = --Select-- }); cmb1.BindingContext = new BindingContext(); cmb1.DataSource = items; cmb1.DisplayMember = Name; cmb1.ValueMember = ID;