C# autogenerate ID in a Combobox connected to a SQL Database

Question

I need to auto Generate ID in a Combo Box on the click of Add button in CourseMaster Form. My project uses C#.net Express Edition 2008 as Front End and Sql 2005 Database as Back End. If anyone could help me out, Please check the source code attached along.

Attachment: Fashion Dsgn.zip

Javeed M Shaikh · Answer

Hi Bhavik Do you want to populate the all the IDs from database? or generate a new next course ID? What is the error you are currently getting I downloded your project but was not able to compile and run so i am not sure where is the issue is. With little information in your question i am assuming you want to display existing IDs from the database. try the following: private void cmdclear_Click( object sender EventArgs e) { //comboBox1.DropDownStyle = ComboBoxStyle.DropDown; comboBox1.Text =  ; txtcrs.Text =  ; txtdur.Text =  ; txtdesc.Text =  ; txtcrs.ReadOnly = false ; txtdesc.ReadOnly = false ; txtdur.ReadOnly = false ; cmdsave.Enabled = true ; cmdupdate.Enabled = true ; using ( SqlConnection s = new SqlConnection ( Server = . ; Initial Catalog = INIFD; Integrated Security = True )) { SqlCommand sc = new SqlCommand ( select * from coursemaster   s); s.Open(); SqlDataReader sd = sc.ExecuteReader(); comboBox1.DataSource = sd; comboBox1.ValueMember = course_id ; comboBox1.DisplayMember = course_id ; s.Close(); } }