Binding the values to Dropdownlist from datatable

Question

0.00/5 (No votes)

See more:

I have a datatable which contains the data like three rows and three coloumns.But I would like to populate the only first row second coloumn data to the dropdownlist from datable.I dont want to populate all the data which is in datatable.Can you help?

Posted 17-Dec-12 5:35am

priya9826

Add a Solution

Comments

Member 9581488 17-Dec-12 12:27pm

U mean cell value? as you mentioned first row and second column data.

Akbar Ali Hussain 17-Dec-12 13:04pm

If you want to show value of only one cell (first row second column), why you are using a Dropdownlist? I guess your requirement is adding values to a dropdownlist, not binding a table. If yes, use dropdownlist.items.add()

priya9826 19-Dec-12 9:58am

Yes.You are exactly correct.I would like to aading the only one cell value to dropdownlist instead of binding the table.Can you send the exact code to me?

priya9826 19-Dec-12 10:39am

Thanks a lot.Its worked for me.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Cheetah.syr · Accepted Answer · 2012-12-17T16:31:00

Hi Firstly, you must choose what is your DBMS type (Access or oracle or sql server)
Secondly, you must work in three steps:
1)Select your data from the table in your database
2)put your selected data in a list (List<string> object)
3)Now you can fill the [DropdownList] by items in your List<string>

As example,I used SQL server as DBMS and I have in my database a [Table] named program contains two columns [Id,Name] :
1) Firstly,I'll fill the List<string> by using static Method :

C#

static public List<string> SelectPrograms(List<string> programs)
    {
        string ConnectionString =      ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlConnection connect = new SqlConnection(ConnectionString);
        string query = "select program_name from Program;";
        SqlCommand command = new SqlCommand(query, connect);
        connect.Open();
        SqlDataReader reader = command.ExecuteReader();
        try
        {
            string x;
            while (reader.Read())
            {
                x = Convert.ToString(reader[0]);
                programs.Add(x);
            }

        }
        finally
        {
            reader.Close();
            connect.Close();
        }
        return programs;
    }

2)Now I'll use the last method after I take a List<string> variable

C#

List<string> program = new List<string>();
            program = [Put_ClassName].SelectPrograms(program);

3)Finally, I'll Fill my [DropdownList]

C#

for (int i = 0; i &lt; program.Count; i++)
            {
                DropDownList_ProgramName.Items.Add(program[i]);
            }

Good lock....

Krunal Rohit · Accepted Answer · 2012-12-17T18:18:00

from MSDN Forum[^]

C#

public partial class Form1 : Form
  {
    DataSet ds;
    public Form1()
    {
      InitializeComponent();

      ds = new DataSet();

      //I will create and populate dataTable manually, 
      //you will do it with sqlDataAdapter Fill() method:

      //so this is not for you
      DataTable table = new DataTable("MyTable");
      table.Columns.Add("id", typeof(int));
      table.Columns.Add("name", typeof(string));

      string[] names = { "A", "B", "C", "A", "B" };
      DataRow dr;
      for (int i = 0; i < names.Length; i++)
      {
        dr = table.NewRow();
        dr["id"] = i + 1;
        dr["name"] = names[i];
        table.Rows.Add(dr);
      }

      //up to here!

      //this is:
      ds.Tables.Add(table);
      dropdownlistid.DataSource = ds.Tables["MyTable"];
      dropdownlistid.DisplayMember = "name";
      dropdownlistid.ValueMember = "id";
    }
  }

or else try it :
http://shahed-kazi.blogspot.in/2009/03/bind-datatable-to-dropdownlist.html[^]

Binding the values to Dropdownlist from datatable

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0