Looking through records

Question

0.00/5 (No votes)

See more:

Hi, I have a simple database set up and I would like to create a small app so I can add and remove from the database in the question. I have got the basic code for the gui complete and I know how to make a connection to a db. I am using sql server 2008. The main question is how do I populate 4 textboxes with a row of data? so for example I would like first textbox to have the first name second box surname third box dob and fourth gender.

Thank you in advance for any help

Posted 5-Jun-11 3:48am

DanHodgson88

Add a Solution

2 solutions

Solution 1

Every basic book and article on .NET development covers databinding to some degree or another. Have you at least done some research?

Posted 5-Jun-11 8:21am

Not Active

Comments

DanHodgson88 5-Jun-11 15:15pm

yes I have and with respect pointing to a website or a book would have been appreciated snidy comments aren't

[no name] 5-Jun-11 15:27pm

Then don't ask questions that could be answered with very little research and effort on your part.

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)

Kim Togo · Accepted Answer · 2011-06-05T08:21:00

Solution 2

When you have opened the database and have your SELECT statement ready, use a DataTable[^] to hold all informations from the database.

C#

sqlConnection.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM tbl WHERE id=42", sqlConnection);

DataTable result = new DataTable();
dataAdapter.Fill(result);

sqlConnection.Close();

When result (DataTable) holds all rows that match the WHERE Clause.
Get value from result and populate TextBox.

C#

// Check for any result
if (result.Rows.Length > 0)
{
  // Fill in textbox values
  textBox_FirstName.Text = result["firstname"].ToString();
  textBox_Surname.Text = result["surname"].ToString();
  textBox_Dob.Text = result["dob"].ToString();
  textBox_Gender.Text = result["gender"].ToString();
}
else
{
  // No record found
  MessageBox.Show("No record found");
}

The DataTable result can be saved for future use.

Posted 5-Jun-11 8:21am

Kim Togo

Updated 5-Jun-11 8:22am

v2

Comments

DanHodgson88 5-Jun-11 15:16pm

thank you very much that is perfect :) appreciate the reply and your time

Kim Togo 6-Jun-11 3:09am

You are welcome.

[no name] 5-Jun-11 15:26pm

Give a man a code and you solve his problem for the day. Teach a man to code and research and you give him skills for a lifetime.

Kim Togo 6-Jun-11 2:56am

I just wanted to give OP a 'little' push in the right direction. But perhaps I have pushed too hard :-)

Tarun.K.S 5-Jun-11 16:25pm

Good answer Kim and I do agree with Mark's comment.

Kim Togo 6-Jun-11 2:57am

Thanks.

DanHodgson88 6-Jun-11 7:39am

I am a university student in my second year (just finished) and c# is not part of our syllabus, so I am trying to learn it during my summer. For some being told to use a datatable would be enough for them to find the answer themselves but like I say am very new to this language and have no real guide other than a couple of books I have picked up. I have never used a database in code other than with JSP so to me everything to do with linking a database to a GUI is completly new to me. I work mainly by example I find it much easier to see a piece of code that is similar to what I need and work backwords to its understanding than sitting reading books which 99% aren't really in 'English' Mark is deffinetly correct in what he has said but As I've said im new and it's nice to see an example rather than 20 pages of text I struggle to stay awake for when reading it!

Thanks again guys for your input