C# .NET - How do I bind all column names in one dropdownlist?

I have 7 column names in my database and I would like to bind them in one dropdownlist.

Hi,

    What we generally do is

dropdown1.DataSource=dt (some datatable)
dropdown1.DisplayMemeber="column name";
dropdown1.ValueMemeber="column name";

here we binded the table to dropdown

here you table can have 7 column but only two are functional.

Even if you bind table with 7 column only two will be functional.

I hope this will help you.

So..it can't be bind with 7?Only two is the maximum?

Hi,

check this

DataTable dt = new DataTable("sample");

dt.Columns.Add("sample_id", typeof(int));

dt.Columns.Add("sample_name", typeof(string));

dt.Columns.Add("sample_volume", typeof(int));

cmbDomain.Properties.DataSource = dt;

cmbDomain.DisplayMember = "sample_name";

cmbDomain.ValueMember = "sample_volume";

I can bind a table with more than 2 columns but only two will be functional. But indirectly you can get all columns value.

Get sample_id and get complete row using that sample_id.

I hope this will solve your issue.

Oh.

 You can Display 7 columns value in DropDown, Use Thsi Code-
 

SqlConnection cn = new SqlConnection("YOUR CONNECTTION STRING");

cn.Open();

string strQuery = "Select * from Tab_Emp";

SqlDataAdapter da = new SqlDataAdapter(strQuery, cn);

DataSet ds = new DataSet();

da.Fill(ds);

foreach (DataRow r in ds.Tables[0].Rows)

{

DropDownList1.Items.Add(r[0].ToString() + " " + r[2].ToString());  //Add 7 columns

}

This code will add all 7 column values add display in DropDownList.

Try and let me know.

Hi!

To get Column name using this query =select  column_name from information_schema.columns where table_name='Tablename'

Hope this......

protected void LoadDropdown()

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand("select  column_name from information_schema.columns where table_name='EmployeeMaster'", conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

}

I dont want my results to appear.I only want my heading which is the column name to appear in my dropdownlist.

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

Hi!

to Get column name using this query  =" 

select column_name from information_schema.columns where table_name='EmployeeMaster'

"
try like this:
cs. page:
String qry="select column_name from information_schema.columns where table_name='EmployeeMaster'"

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString);

SqlCommand com = new SqlCommand(qry, conn);

conn.Open();

SqlDataReader dr = com.ExecuteReader();

drodownList1.Items.Clear();

drodownList1.DataSource = dr;// your data source name

drodownList1.DataTextField = "column_name";

drodownList1.DataTextField= "column_name";

drodownList1.DataBind();

If you want to display all columns name in DropDownList then Use Thie Code-

SqlConnection cn = new SqlConnection("YOUR CONNECTION STRING");

cn.Open();

string strQuery = "SELECT COLUMN_NAME from information_schema.columns where table_name='EMPIMAGE'";

SqlDataAdapter da = new SqlDataAdapter(strQuery, cn);

DataSet ds = new DataSet();

da.Fill(ds);

　

foreach (DataRow r in ds.Tables[0].Rows)

{

DropDownList1.Items.Add(r[0].ToString());

}

TRY AND LET ME KNOW.

TRY AND LET ME KNOW.

Use this query in your SQL statement, you will get the column name

How do I hide my ID column?I don't want it to be shown inside my dropdownlist

Hi!


hide id from drowdown like this.

thank you very much div v.