Top "Mysqldatareader" questions

Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'

In my website, I am using MySQL database. I am using a webservice where in I do all my database …

mysql mysqldatareader mysql-error-1142

Using MySQLConnection in C# does not close properly

Final solution: The connection was added to the connection pool. So I closed it, but it still remained physically open. …

c# mysqlconnection mysqldatareader

Checking the number of rows returned from MySQL Data Reader

I am currently working on an C# project and I am trying to get the number of rows returned from …

c# mysql mysqldatareader

MySQLDataReader retrieving Null value problem in c#

I am currently working on a C# project that will export MySQL Data. The export is for any database within …

c# mysql mysqldatareader

MySqlDataReader: DataTable.Fill(reader) throws ConstraintException

I have two tables orders and orderdetails table orders (PK = id, UNIQUE index on orderno) |id|orderno| | 1|1000 | | 2|1001 | table orderdetails (PK = …

c# mysql datareader mysql-connector mysqldatareader

How to check for NULL in MySqlDataReader by the column's name?

How can I check for a NULL value in an open MySqlDataReader? The following doesn't work; it's always hitting the …

c# mysql null dbnull mysqldatareader

MySQL datetime field query sort by hour:minute

I have a table like this: id date_time 1 2/11/2013 7:05 2 2/11/2013 7:00 3 2/12/2013 7:00 4 2/14/2013 7:00 5 2/16/2013 7:00 6 2/17/2013 7:00 7 2/12/2013 7:05 8 2/14/2013 7:05 9 2/15/2013 7:05 10 2/16/2013 7:05 11 2/17/2013 7:05 12 2/13/2013 7:00 13 2/15/2013 7:00 14 2/13/2013 7:05 I need it sorted by HOUR:MINUTE and than sorted by …

mysql sql sorting mysqldatareader