SqlDataReader and SelectedItem for data type Time in Combobox

Question

4.00/5 (1 vote)

See more:

, +

Hello guys,
I have this code which should read data type Time and then SelectItem,but it doesn't select Item. How should I change it ? thanks!
This is how I fill it:

C#

void vypl_comboboxy()
        {
            

                spojeni.Open();
                var cb1 = new SqlCommand("SELECT odjezd FROM stanice WHERE akce='"
                                + selectrowid+ "' ORDER BY odjezd ASC", spojeni);
 SqlDataReader dr1 = cb1.ExecuteReader();
                while (dr1.Read())
                {
                    comboBox1.Items.Add(dr1["odjezd"]);

                }
                dr1.Close();
                dr1.Dispose();

This is how I want to select item in data type Time

C#

SqlCommand novyprikaz = new SqlCommand("SELECT * FROM klient WHERE ID_K=" + selectrowid, spojeni);
                spojeni.Open();
                SqlDataReader precti = novyprikaz.ExecuteReader();

                if (precti.Read())
                {
 comboBox1.SelectedItem = precti.GetTimeSpan(16).ToString();
}

Posted 15-Jul-13 23:41pm

mareksip

Updated 15-Jul-13 23:42pm

v2

Add a Solution

Comments

Naz_Firdouse 16-Jul-13 6:44am

are you sure that the value precti.GetTimeSpan(16).ToString() is added to the Combobox???
if it is listed in the combobox , it will be selected.

mareksip 16-Jul-13 6:50am

It is added. It shows the whole combobox but don't select the right one. It is empty when I load form

1 solution

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)

RuchiH · Accepted Answer · 2013-07-17T00:50:00

Solution 1

You are adding Object type in combobox and setting string type as selected Item. It won't work.

Add string type in combo box like

C#

comboBox1.Items.Add(dr1["odjezd"].ToString());

and also the selectedItem as string

comboBox1.SelectedItem = precti.GetTimeSpan(16).ToString();

Posted 17-Jul-13 0:50am

RuchiH