show sql search result in textboxes

Question

0.00/5 (No votes)

See more:

i want show sql serach result in several textboxes(for example my serach have 4 record and every record have 5 fiels i want show one field in one textbox)

Posted 25-Jul-13 3:14am

mekameka

Add a Solution

Comments

OriginalGriff 25-Jul-13 9:42am

Sorry, but that doesn't make a whole lot of sense: if you have four records, and five columns per record than you would need a variable number of textboxes in order to display the full results.

A better approach might be to have a grid control showing all the rows, and textboxes to show only the currently highlighted row data.

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)

ZurdoDev · Answer 1 · 2013-07-25T04:32:00

Solution 1

This is easy to do. If you have a SQL helper class use that or you can use the SqlCommand object and the SqlDataReader along with the SqlConnection.

Something similar to:

C#

 dr = cmd.ExecutReader();
if (dr.HasRows)
{
  dr.Read();
  textbox1.Text = dr["FirstField"].ToString();
  textbox2.Text = dr["SecondField"].ToString();
}

so on and so forth.

Posted 25-Jul-13 4:32am

ZurdoDev

Comments

mekameka 26-Jul-13 2:54am

ok-if we have 1 record for result search it is true but search result have more than 1 record for use 2th record
in textbox 3 and textbox 4 (for example) what is code ?

ZurdoDev 26-Jul-13 7:32am

dr.Read() advances to the next record.