Thanks for your help. It works.

Hi All, I would like to get some ideas about for the java script as I am new to that area. I'd like to set up a script which will get the control id which is being focused and according to the control id I'd like to set a different message to a text box. If you have any link or ideas of your own, please share with me. The logic is I will have like 6 or 7 controls on the page with a master page.(I am using MS AJAX) When user changes the focus from control to control I would like to display the message in a text box. Like...If the focus is on textbox 1 The message will be "this is text box 1". And user changes the focus to textbox 2 , The message will be " This is text box2." please give me a hand.

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:

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, I used sqldatasource. The following is the command. I hope this is the ans for your question.

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 :)