Kim I don't know anything about MySQLDriverCS but if you continue to have problems, you might try my provider at www.bytefx.com
Thanks Reggie > -----Original Message----- > From: Kimberly Clark [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:14 AM > To: [EMAIL PROTECTED] > Subject: MySQLDriverCS Data Typing problem in tables > > > I'm really hoping someone here can at least point me in a new direction. > For background, I'm using MySQLDriverCS and C# in > VS.NET 2003. > > I can create the connection, read in data, and even display it fine. The > problem I'm encountering is that everything is typed as a string, even > though it may be typed int in my database. > > Reading over the documentation > that accompanied the files, it appeared that > MySQLDataReader.GetSchemaTable() might get the typing I need so that I > can set the columns in my dataset's tables. Strangely, > it > appears that it simply reads in the data almost like MySQLDataAdapter.Fill > (). And once again, all my data gets typed as a string on my end. > > How can I get the columns in my data table typed correctly (cannot hard > code it, as the query will change often)? Any suggestion is appreciated. > > Thank you, > > --K > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]