I added a new String field called ip_adr on both View_ticket and New Ticket forms by adding the new field in the tickets table and in the following files :
ticket.aspx, new_ticket.aspx, new_ticket.aspx.cs, db.designer.cs and Tickets.cs
I had correct results on both View Ticket and New Ticket but when I launched My issues form I had the following error :
The text data type cannot be selected as DISTINCT because it is not comparable.
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The text data type cannot be selected as DISTINCT because it is not comparable.
Line 54: }
Line 55: gvMy.DataSource = myTickets;
Line 56: gvMy.DataBind();
Line 57: gvGroup.DataSource = groupTickets;
Line 58: gvGroup.DataBind();
Source File: c:\Inetpub\wwwroot\Slick-Ticket\my_issues.aspx.cs Line:
What have to adjust more to correct this problem. Please Advice.