Access Database

Question

0.00/5 (No votes)

See more:

I want use "disconnected model" to access database. Dataprovider which I am using is "OLEDB", I have a database to manage students in a school, I want get students in a class but i can't. After accessing database, the thing I received is a table which involved all of the students in the school. When I used "connection model" to access database. I can do get students in a class by using "@SelectedClass" parameter. May you help me ???

Posted 14-Oct-10 19:14pm

kid218

Add a Solution

Comments

kid218 15-Oct-10 5:32am

myConnect.open();
string myStringCommand = "SELECT ordinal, codeOfStu, fullName, ST.codeOfClass, CL.nameOfClass FROM Student ST, Class CL WHERE ST.codeOfClass = CL.codeOfClass AND ST.codeOfClass = @SelectedCodeOfClass";
OleDbCommand command = new OleDbCommand(myStringCommand, myConnect);
OleDbParameter myParameter = new OleDbParameter("@SelectedCodeOfClass", OleDbType.Integer);
myParameter.Value = SelectedCodeOfClass; // SelectedCodeOfClass is a parameter which is carried from main function.
myCommand.Parameters.Add(myParameter);
OleDbDataReader myReader = myCommand.ExecuteReader();
.
.
.

Now, I want not use "connect model" to access database anymore. I want use "disconnect model" to do that.
If I do like this:
OleDbDataAdapter adap=new OleDbDataAdapter("select * from tablename",con);
Dataset ds=new Dataset();
adap.fill(ds);

The Thing I receive is a datatable involve in all of the students. I don't want read all of the Student 's Information in database. I only want read students' Information according to class (codeOfClass) that they belong to

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)

Abhinav S · Answer 1 · 2010-10-14T19:58:00

Solution 2

Are you getting an error?
If so what?

You need to provide more information before someone can help you.

Posted 14-Oct-10 19:58pm

Abhinav S

Mohd Wasif · Answer 2 · 2010-10-14T19:36:00

Solution 1

Please clarify your question a bit more about the table and how u r using in ur code.
or U can use as
OleDbDataAdapter adap=new OleDbDataAdapter("select * from tablename",con);
Dataset ds=new Dataset();
adap.fill(ds);
Gridview1.DataSource=ds;
Gridview1.DataBind();

Posted 14-Oct-10 19:36pm

Mohd Wasif

Updated 14-Oct-10 21:21pm

v2