C#- OleDb Data Adapeter

Question

0.00/5 (No votes)

See more:

Hi,

I have a database with a table name "main" which contain 4 column and N no of rows.

The Four columns names are Type,Model Name, Min and Max.

In this, i have to choose a model name by giving its type and then its range.

Model Name should be displayed for given range value.(it compares that range value in min and max value)

But here i am not getting the result properly.

I have given code in C#-oledb data adapter as,

C#

con.open();
oledb da=new oledbdataapter("select model Name from main where type='gates' and min<='"+textbox1.text+"' and max>='"+textbox2.text+"'",con);
con.close();

Posted 24-Sep-13 18:37pm

Member 10295714

Add a Solution

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)

PIEBALDconsult · Answer 1 · 2013-09-24T18:48:00

You're not asking for any results; all you're asking for is trouble.

I strongly recommend you not use a DataAdapter, but if you do, you need to look at its Fill method.

I also strongly recommend you use a parameterized query rather than using string concatenation to form the query.

Plus, if I recall correctly, the Fill method will open and close the connection, so you don't have to.

leonidasvijay · Answer 2 · 2013-09-24T18:44:00

Solution 1

C#

try using this:
select [model Name] from main where type='gates' and min<='"+textbox1.text+"' and max>='"+textbox2.text+"'"

Posted 24-Sep-13 18:44pm

leonidasvijay

Comments

Member 10295714 25-Sep-13 3:47am

Thanks for your reply..

Sorry i made a mistake in my previous question , which made it too complex.

But my question is how to use a compare statement using Oledb Data Adapter..

for Example : Table contains these values
model Name = zeta
Type = class a
min = 250
max = 350

select model Name from main where type='gates' and min<='"+textbox1.text+"' and max>='"+textbox1.text+"'"

If i give input as 260 in text box , it should compare "260" with min and max and display its value in gridview.. I wrote all codings for dataGridview and others.. Its works fine. But it displays all fields which contain 2,6 and 0. its not comparing the values with min and max..

PIEBALDconsult 25-Sep-13 9:30am

That's because you're using a string compare; a parameterized query would help with that too.

Member 10295714 25-Sep-13 12:18pm

Though i m beginner in C#, i Think i cant clearly understand your valuable points. I have given my coding clearly.. Please suggest me solutions

try
{
con.Open();
da = new OleDbDataAdapter("select mname,min,max from main where side='dampers'and min <='"+textBox1.Text+"' and max >= '"+textBox1.Text+"'", con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "main");
if (ds1.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds1;
dataGridView1.DataMember = "main";
}
else
{
dataGridView1.DataSource = null;
}
}