Edit Question - KnowledgeHub

Title Body

In my website, I am using a MySQL database. I am using a Web service, where I do all my database-related manipulations. Now, in one of the methods of that Web service, I get the following error. select command denied to user '<userid>'@'<ip-address>' for table '<table-name>' What could be wrong? Below is the code where I get that error. I tried debugging and found that it fails at line MySqlDataReader result1 = command1.ExecuteReader(); Here is my code: String addSQL = "Select Max(`TradeID`) from `jsontest`.`tbl_Positions"; MySqlConnection objMyCon = new MySqlConnection(strProvider); objMyCon.Open(); MySqlCommand command = objMyCon.CreateCommand(); command.CommandText = addSQL; MySqlDataReader result = command.ExecuteReader(); //int j = command.ExecuteNonQuery(); while (result.Read()) { MaxTradeID = Convert.ToInt32(result[0]); } objMyCon.Close(); for (i = 1; i <= MaxTradeID; i++) { String newSQL = "Select `Strike`,`LongShort`,`Current`,`TPLevel`,`SLLevel` from `json`.`tbl_Position` where `TradeID` = '" + i + "'"; MySqlConnection objMyCon1 = new MySqlConnection(strProvider); objMyCon1.Open(); MySqlCommand command1 = objMyCon1.CreateCommand(); command1.CommandText = newSQL; MySqlDataReader result1 = command1.ExecuteReader(); objMyCon2.Close();

Tags (comma-separated) Cancel