Integers and Strings

[mike55]

Yo

 

Have a database table of customers containing a mixture of integers (used in the reference numbers etc.) and chars (names and addresses). Am doing a select * on the table and loading the data into a dataReader, the problem occures when i attempt to take the contents of the data reader and put it into a string array, i get a message telling me that the specific cast that i am using is not valid, has anyone any suggestions or alternative??

 

Mike

[Joe Mamma]

  Quote

Yo

 

Have a database table of customers containing a mixture of integers (used in the reference numbers etc.) and chars (names and addresses). Am doing a select * on the table and loading the data into a dataReader, the problem occures when i attempt to take the contents of the data reader and put it into a string array, i get a message telling me that the specific cast that i am using is not valid, has anyone any suggestions or alternative??

 

Mike

hy no use a dataadapter to fill a dataset. the table in the dataset is already an array

[samsmithnz]

Can we see some code?

[huby]

you using c# or vb.net ?

 

in c#, remeber to use ToString() :

 

while (myReader.Read())
{
   myName = myReader["name"].ToString();
}

[mike55]

Managed to solve the problem, found that there are a number of sql variables also available.

 

while dataReader.read

stringArray(0) = dataReader.getSQLInt32(0).toString 'reference number

stringArray(1) = dataReader.getString(1) 'names

stringArray(2) = dataReader.getSQLMoney(2).toString 'Money values

End While

 

 

Mike