Click here to Skip to main content
15,347,117 members
Home / Discussions / ASP.NET
   

ASP.NET

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder12-Jul-09 22:39
cofounderChris Maunder12-Jul-09 22:39 
Questionaspnet core use TempData error! Pin
Member 940386815-Jun-22 20:21
MemberMember 940386815-Jun-22 20:21 
AnswerRe: aspnet core use TempData error! Pin
Richard Deeming15-Jun-22 21:20
mveRichard Deeming15-Jun-22 21:20 
AnswerRe: aspnet core use TempData error! Pin
Mycroft Holmes16-Jun-22 12:41
professionalMycroft Holmes16-Jun-22 12:41 
QuestionSELECT DISTINCT Pin
kjell.ek19-May-22 3:16
Memberkjell.ek19-May-22 3:16 
SELECT DISTINCT does not work the way I want.
SELECT DISTINCT works for the class column but not for name_event column
If "MyId" is e.g. CW and there are 4 lines there but name_event should only be 2 pcs, but it shows 4 pcs

Now display:
World Championships
French Champioships
World Championships
World Championships


It should be:
World Championships
French Champioships

What am I doing wrong?





VB
<pre>        Dim MyDataAdapter As New SqlDataAdapter("SELECT DISTINCT class, nationality, name_event from statistics_results Where class = @class", MyConnection)

        MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@class", SqlDbType.VarChar, 10))
        MyDataAdapter.SelectCommand.Parameters("@class").Value = MyId

        Try
            Dim dt As New DataTable()
            MyDataAdapter.Fill(dt)

            Dim natlist = dt.AsEnumerable().[Select](Function(r) r("nationality").ToString())
            Dim natvalue As String = String.Join("- ", natlist)
            litNat.Text = natvalue

            Dim eventlist = dt.AsEnumerable().[Select](Function(r) r("name_event").ToString())
            Dim eventvalue As String = String.Join("<br>", eventlist)
            litEvent.Text = eventvalue

        Catch exc As SqlException

        Finally
            MyConnection.Close()
            MyConnection.Dispose()

        End Try


AnswerRe: SELECT DISTINCT Pin
Ron Nicholson19-May-22 6:21
professionalRon Nicholson19-May-22 6:21 
AnswerRe: SELECT DISTINCT Pin
Member 1562749519-May-22 11:11
MemberMember 1562749519-May-22 11:11 
GeneralRe: SELECT DISTINCT Pin
Richard Deeming19-May-22 21:42
mveRichard Deeming19-May-22 21:42 
GeneralRe: SELECT DISTINCT Pin
kjell.ek20-May-22 2:58
Memberkjell.ek20-May-22 2:58 
GeneralRe: SELECT DISTINCT Pin
Alaren23-Jun-22 5:23
MemberAlaren23-Jun-22 5:23 
QuestionMilliseconds from excel Pin
kjell.ek16-May-22 10:10
Memberkjell.ek16-May-22 10:10 
AnswerRe: Milliseconds from excel Pin
Richard Deeming16-May-22 21:35
mveRichard Deeming16-May-22 21:35 
GeneralRe: Milliseconds from excel Pin
kjell.ek16-May-22 23:15
Memberkjell.ek16-May-22 23:15 
QuestionASP.NET Gridview load data Pin
Herman<T>.Instance28-Apr-22 3:16
MemberHerman<T>.Instance28-Apr-22 3:16 
AnswerRe: ASP.NET Gridview load data Pin
Richard Deeming28-Apr-22 4:40
mveRichard Deeming28-Apr-22 4:40 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance2-May-22 0:47
MemberHerman<T>.Instance2-May-22 0:47 
GeneralRe: ASP.NET Gridview load data PinPopular
Dave Kreskowiak2-May-22 2:12
mveDave Kreskowiak2-May-22 2:12 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance2-May-22 3:23
MemberHerman<T>.Instance2-May-22 3:23 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 4:46
MemberHerman<T>.Instance3-May-22 4:46 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 5:31
mveRichard Deeming3-May-22 5:31 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 5:38
MemberHerman<T>.Instance3-May-22 5:38 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 5:48
mveRichard Deeming3-May-22 5:48 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 7:12
MemberHerman<T>.Instance3-May-22 7:12 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 21:38
mveRichard Deeming3-May-22 21:38 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 22:03
MemberHerman<T>.Instance3-May-22 22:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.