Comments by Member 10295714 (Top 2 by date)

Member 10295714 25-Sep-13 12:18pm View

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;
}
}

Member 10295714 25-Sep-13 3:47am View

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..