How to read sql data to runtime added combobox in c# winforms

Question

Hello Friends, I want to read table data in dynamically added combo boxes. Actually like besides the image I am adding combo boxes in runtime using button click. if I want 2 more combo box then I will add in runtime using button click. My problem is how to read SQL server data in these runtime added combo boxes. I know SQL connection method. But I am unable to read SQL table data for runtime added combo box. using the below method I have added runtime combo boxes. int cmbFieldColm_1Count = 1; public System.Windows.Forms.ComboBox AddComboFieldColumnP1() { System.Windows.Forms.ComboBox cmbBxFieldColm = new System.Windows.Forms.ComboBox(); panel1.Controls.Add(cmbBxFieldColm); cmbBxFieldColm.Top = cmbFieldColm_1Count * 22; cmbBxFieldColm.Left = 301; cmbBxFieldColm.Width = 160; cmbBxFieldColm.Name = "cmbSelectColumn" + this .cmbFieldColm_1Count.ToString(); cmbFieldColm_1Count = cmbFieldColm_1Count + 1; return cmbBxFieldColm; } Please help me. Thanks in advance.

Sachin Singh · Answer

why, which type of problem are you facing? your code is working absolutely fine private List string > Data() { // retrieve data from database, i am taking static data for ex return new List string > () { "Ram" , "shyam" }; } private void button1_Click( object sender, EventArgs e) { var cmb = AddComboFieldColumnP1(); cmb.DataSource = Data(); } public System.Windows.Forms.ComboBox AddComboFieldColumnP1() { System.Windows.Forms.ComboBox cmbBxFieldColm = new System.Windows.Forms.ComboBox(); panel1.Controls.Add(cmbBxFieldColm); cmbBxFieldColm.Top = cmbFieldColm_1Count * 22; cmbBxFieldColm.Left = 301; cmbBxFieldColm.Width = 160; cmbBxFieldColm.Name = "cmbSelectColumn" + this .cmbFieldColm_1Count.ToString(); cmbFieldColm_1Count = cmbFieldColm_1Count + 1; return cmbBxFieldColm; }