Retrieve Data from autonumber and display it

Question

0.00/5 (No votes)

See more:

hye..
I have a database call student which consists of all students information and also student id..
i have created a form that admin have to insert all the data about student..
then after admin click a save button,
i want to display all the information also with the student id(autonumber)..
i have try,but got an error..
this is my coding..
can anyone guide me..

C#

OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=dbStd.mdb;");
OleDbCommand cmd = new OleDbCommand("SELECT StdId FROM Student WHERE StdId ='{0}'");
conn.Open();

OleDbDataReader dr = null;
dr = cmd.ExecuteReader();

while(dr.Read())
{
textBox1.Text = dr.GetString(0);
}


dr.Close();
conn.Close();

Posted 16-Dec-10 8:36am

Mikiyas Abeb

Updated 16-Dec-10 8:40am

Abdul Quader Mamun

v2

Add a Solution

Comments

Abdul Quader Mamun 16-Dec-10 14:41pm

Use pre tag.

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)

Abdul Quader Mamun · Answer 1 · 2010-12-16T08:44:00

Thank you for your question,

C#

OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=dbStd.mdb;");
OleDbCommand cmd = new OleDbCommand("SELECT StdId FROM Student WHERE StdId =IdHere");
conn.Open();
OleDbDataReader dr = null;

cmd.Connection = conn; //add this line

dr = cmd.ExecuteReader();
while(dr.Read())
{
textBox1.Text = dr.GetString(0);
}

dr.Close();
conn.Close();

Thanks,
Mamun

OriginalGriff · Answer 2 · 2010-12-16T08:48:00

This may be me being very thick, but what is

WHERE StdId ='{0}'

supposed to achieve?
I know of no SQL syntax which includes this, where did you find it?

If you are going to save data and read it back immediately, you might want to consider using a Guid rather than an autonumber field - that way you are in control of the id and do not have to query the db to find out what value has been assigned.

Retrieve Data from autonumber and display it

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0