problem with parameters and their data types

  • Thread starter Thread starter Carloz
  • Start date Start date
C

Carloz

Hi, i've made a connection with an informix database and now I want to
pass a parameter via a textbox to get the right values of the database
in a datagrid. When I enter an integer, I get the desired values, but
when I enter a string, I get no value at all. I don't know exactly why
this doesn't work, but I suppose it has something to do with the
correct data types. Informix works with varchars, just like an oracle
datebase, while the textbox.text property is a string. I don't know,
it's just a guess... Does anyone know why I don't get the right value
in the grid? (there's nothing wrong with the names I used in my SQL
statement to refer to the table and the columns)

thanks in advance
 
Hi,

Strings are converted into varchars without problems. What is your code that
gets data from the database?
 
Carloz,

Assuming that you use a winforms datagrid (however this is as well for a
webform). The datagrid uses a datatasource. That datasource is in a Net
format that uses values accoording to your used program language.

Therefore can you describe more what values are in that dataset and as well
to make it easier to answer if it is a Webform datagrid or a Windowforms
datagrid and what program language you use.

Cor
 
Back
Top