kavithabhaskar 0 Junior Poster

hi:

I have a db which has RAM field in it. I have set it as text because I need to have the GB or MB along with it. I had 5 modules in my project and this is my last one.

i also have decimal values in RAM like 2.98 and 3.25.

I want to have a combo box which lets me choose > or < from the first combo box and a second combo box which choose me a RAM Value and a third one again with < or > and the 4th combobox with a RAM value again.

What I intend to do is frame SQL queries ..parametrized ones such that if i chose values from the combo boxes that I want RAM values b/w 2 and 3.25, i should have them in the datagridview.

I know that SQL query would look into the database for the RAM values and would expect it to be number but in this case it is text.. I want to work on this module without actually changing anything in the previous modules. How do i go about doing this ? IS there a way by which I can do it?

Thanks

Kukki.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.