Monthname() function
-
Hi All, I am using monthname() function for particular boundfield for a gridview in ASP.NET2.0. When I display it It shows "system.byte[]" in the cell instead of particular Month name. I am using MySQL database and the command is "SELECT MONTHNAME(sales.issuedate) AS 'Month', Count(Month (date(sales.issuedate))) AS 'Sale' From sales Group by Month(date(sales.issuedate))" I look for the solution on the NET but no luck. Please help me out. good day :)
-
Hi All, I am using monthname() function for particular boundfield for a gridview in ASP.NET2.0. When I display it It shows "system.byte[]" in the cell instead of particular Month name. I am using MySQL database and the command is "SELECT MONTHNAME(sales.issuedate) AS 'Month', Count(Month (date(sales.issuedate))) AS 'Sale' From sales Group by Month(date(sales.issuedate))" I look for the solution on the NET but no luck. Please help me out. good day :)
-
which method u r using to retrieve value from database. like executenonquery etc.. Better if u can paste the code here.
Hi, I used sqldatasource. The following is the command. I hope this is the ans for your question.
-
Hi, I used sqldatasource. The following is the command. I hope this is the ans for your question.
-
Hi G, I am displaying the data in a boundfield of a GridView. There is no error. It works fine. But It just does not showing the right format of the result. The result should be the name of the months. But It is showing "System.Byte[]" instead. The result ---------------------------------¬ Months ¦ Number of Sales ¦ --------------¦------------------¦ System.Byte[] ¦ 11 ¦ --------------¦------------------¦ System.Byte[] ¦ 37 ¦ ---------------------------------- -- modified at 5:49 Wednesday 28th November, 2007
-
Hi G, I am displaying the data in a boundfield of a GridView. There is no error. It works fine. But It just does not showing the right format of the result. The result should be the name of the months. But It is showing "System.Byte[]" instead. The result ---------------------------------¬ Months ¦ Number of Sales ¦ --------------¦------------------¦ System.Byte[] ¦ 11 ¦ --------------¦------------------¦ System.Byte[] ¦ 37 ¦ ---------------------------------- -- modified at 5:49 Wednesday 28th November, 2007
-
I assign the return data from sql statement which is string (because when I extract MONTHNAME from date it would return a string). So there should not be System.Byte[] in the cell of the gridview.:doh: