Posting search results to textbox

Question

1.00/5 (1 vote)

See more:

hi guy i have a problem that i try every way to make Posting search results to textbox but always return nothing this is my code

C#

private void btnNamesearch_Click(object sender, EventArgs e)
      {

         bool temp = false;
          SqlConnection con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Educational System;Data Source=DREAMS");
          con.Open();
          SqlCommand cmd = new SqlCommand("SELECT EmpName, ExcutionOrder FROM Employee WHERE EmpName  ='" + txtusernameSearch.Text.Trim() + "'", con);
          SqlDataReader dr = cmd.ExecuteReader();
          while (dr.Read())
          {
              txtemployee.Text = dr["EmpName"].ToString();
              txtExcutionOrder.Text = dr["ExcutionOrder"].ToString();

              temp = true;
          }
          if (temp == false)
              MessageBox.Show("not found");

          con.Close();
          dr.Close();

      }

its work and when i make breakpoints it gets date but nothing display
and i have another problem that i have got 4 com boxes which fill in form load
suppose when i make search it should display the value of selected from search and this will make problem because it loads with form load ?? plz help really i think more but still need experiences through windows form thanks a lot

Posted 25-Dec-12 10:48am

ost3z

Add a Solution

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)

Krunal Rohit · Answer 1 · 2012-12-25T15:34:00

Solution 1

C#

while (dr.Read())
            {
if(dr.HasRows)
{
     txtemployee.Text = dr["EmpName"].ToString();
     txtExcutionOrder.Text = dr["ExcutionOrder"].ToString();

}
else
{
        MessageBox.Show("not found");
}
}

Posted 25-Dec-12 15:34pm

Krunal Rohit

ost3z · Answer 2 · 2012-12-25T22:21:00

Solution 3

thanks a lot the problem was in another code in the from where it conflict with this code but i need to know to fill combobox from select order by searched item

Posted 25-Dec-12 22:21pm

ost3z

Comments

Thomas Daniels 26-Dec-12 4:23am

If you've a comment to an answer, click on the "Have a Question or Comment?" button, but please don't post a comment as an answer.

ost3z 26-Dec-12 11:36am

OK this my first time to participate thanks a lot