DropDownList

Question

How to add Text to DropDownList when populating from Database using Dataset How to hide TabControls Tabpages on load

Satyapriya Nayak · Answer

Hi Ravi SqlConnection con = new SqlConnection(strConnString); con.Open(); str = Select * from area; SqlCommand com = new SqlCommand(str con); SqlDataAdapter sqlda = new SqlDataAdapter(com); DataSet ds = new DataSet(); sqlda.Fill(ds area); DropDownList1.DataTextField = country; DropDownList1.DataValueField = state; DropDownList1.DataSource = ds; DropDownList1.DataMember = area; DropDownList1.DataBind(); con.Close(); Note:- //DataTextField is used for the user to bind data to dropdownlist and DataValueField is used like key// Thanks If this post helps you mark it as answer

Prabhu Raja · Answer

Hi add dropdownlist like this SqlConnection con = new SqlConnection( Your Database Connection String Here ); try { con.Open(); Dataset ds = new Dataset(); SqlDataAdapter da = new SqlDataAdapter(Select * from sys.tablescon); da.fill ( ds da.Tables[0]); DropDownList1.DataTextField = ds.Tables(0).Columns(1).Caption DropDownList1.DataValueField = ds.Tables(0).Columns(0).Caption DropDownList1.DataSource = ds.Tables(0) DropDownList1.DataBind() } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } Hide you Tab Control By using : private void Form1_Load(object sender System.EventArgs e) { if ( (tabControl1.SelectedTab == tabPage1)) { tabControl1.Remove(tabPage2); } else if ((tabControl1.SelectedTab == tabPage2)) { tabControl1.Remove(tabPage1); } } Or try this Link : ------------------------------------------------ If it helps you then mark as Correct Answer