How to set Combobox is Slect Option And then Bind Data

Saber Shaikh

11y1.2kLINQ

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar Choudhary11y ago
Accepted 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 Shaikh11y ago
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 Shaikh11y ago
try it but not working can u give me other option
Manish Kumar Choudhary11y ago
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";