DropDownList

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

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.tables",con);
        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"