How to display access database data on label

Question

5.00/5 (1 vote)

See more:

I want to display database data from Access into a label. Here is my code:

C#

string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=D:/_Web3rev/App_Data/CentralDB.mdb";
OleDbConnection cn = new OleDbConnection(connectString);

cn.Open();
string selectString = "SELECT studid FROM Students WHERE studid='" + lblStudid.Text+ "'";
OleDbCommand cmd = new OleDbCommand(selectString, cn);
OleDbDataReader reader = cmd.ExecuteReader();

I want to display database content into label as per user entry. Thanks.

Posted 6-Feb-13 22:05pm

Ed Gepulle

Add a Solution

Comments

[no name] 7-Feb-13 4:08am

So where so you stuck ?

Ed Gepulle 7-Feb-13 7:08am

I want to display the studid of that particular user to the lblstudid.txt. what is the good code in displaying such data? the above code already opened but not yet displaying the data with that studid.

Ed Gepulle 7-Feb-13 7:36am

here is the code i am trying to implement but it went wrong, still the data from database isnt displaying:

string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=D:/_Web3rev/App_Data/CentralDB.mdb";
OleDbConnection cn = new OleDbConnection(connectString);

cn.Open();
string selectString = "SELECT studid FROM Students WHERE studid='" + lblStudid.Text+ "'";
OleDbCommand cmd = new OleDbCommand(selectString, cn);
OleDbDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
//txtStudid.Text = reader["studid"].ToString();
cmd.Parameters.AddWithValue("@studid", txtStudid.Text);
cmd.Parameters.AddWithValue("@fullname", txtName.Text);
}
reader.Close();
cn.Close();

CHill60 7-Feb-13 8:57am

You're adding parameters to the sql cmd after you've run ExecuteReader but not actually getting the results from reader e.g. lblstudid.text = reader.GetString(reader.GetOrdinal("studid"));
But why bother getting studid from the database when you already have it in lblStudid.Text (see selectString)

Ed Gepulle 7-Feb-13 9:48am

I wanted to display the corresponding data of the studid from the db. Display it on a label or textbox will be good.

CHill60 7-Feb-13 10:45am

if(reader.Read())
lblstudid.text = reader.GetString(reader.GetOrdinal("studid"));
and get rid of the while {}

Ed Gepulle 8-Feb-13 1:06am

wow i liked that. let me try that coding.

Ed Gepulle 8-Feb-13 1:14am

Thanks a lot chill60. Its working and its implemented in my code.

CHill60 8-Feb-13 4:02am

I'll post it as the solution for any others that come this way

Member 12869350 24-Nov-16 17:32pm

wow! You solved my question easily

CHill60 29-Nov-16 19:05pm

Cool! I'm pleased that it worked for you

Member 14081438 10-Dec-18 10:51am

connection.Open();
string selectString = "SELECT FullName FROM Import WHERE IDNumber='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(selectString, connection);
OleDbDataReader reader = cmd.ExecuteReader();

reader = cmd.ExecuteReader();
while (reader.Read())
{
cmd.Parameters.AddWithValue("@IDNumber", textBox1.Text);
if (reader.Read())
label1.Text = reader.GetString(reader.GetOrdinal("FullName"));
}

connection.Close();
it wont work :( plse help me sir

Member 14081438 10-Dec-18 10:52am

connection.Open();
string selectString = "SELECT FullName FROM Import WHERE IDNumber='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(selectString, connection);
OleDbDataReader reader = cmd.ExecuteReader();

reader = cmd.ExecuteReader();
while (reader.Read())
{
cmd.Parameters.AddWithValue("@IDNumber", textBox1.Text);
if (reader.Read())
label1.Text = reader.GetString(reader.GetOrdinal("FullName"));
}

connection.Close();
it wont work to my system :(. plse help me sir

CHill60 10-Dec-18 11:01am

If you have a question of your own then you should really use the red "Ask a Question" link rather than commenting on a comment from 2 years ago! However, you are correctly attempting to use a parameterised query but your SQL does not contain the parameter. Try

string selectString = "SELECT FullName FROM Import WHERE IDNumber=@IDNumber";

Also like the OP here, you don't need a while - just use an if

Also like the OP here - you are adding the parameter AFTER you have executed the read.
I'd post a proper answer but this isn't your question, and formatting in the comments is a real PITA.

Member 14081438 10-Dec-18 10:49am

why it wont work to my system it always says that there is no value given by one or more paramiter?

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)

CHill60 · Accepted Answer · 2013-02-07T22:02:00

Solution 1

As per the comments above, this worked

SQL

if(reader.Read())
     lblstudid.text = reader.GetString(reader.GetOrdinal("studid"));
and get rid of the while {}

Posted 7-Feb-13 22:02pm

CHill60