Hello,

 

I am using the CuteChat, integrated with an existing user membership database. The UserName field in my aspnet_Users table is a numeric value. However, I want to display the full name of the users in the Chat window where all the UserNames of the users who are online are displayed. The full name is in a seperate Members table.

 

Please suggest how can I do this?

 

Thanks in advance for your help.

You need to implement the method to get a beautiful dispplay name:

//Return user's display name
public string GetUserDisplayName(string useruniquename)

Code Example

Thanks Adam for your quick response. Here is how I have implemented this method:

 

        Dim MemberName As String = ""

        Dim cmd As New SqlCommand
        cmd.Connection = New SqlConnection(GetConnectionString(Nothing))
        cmd.CommandText = "SELECT FirstName,LastName FROM Members WHERE MemberID = " & useruniquename
        cmd.Connection.Open()
        Try
            Dim sdr As SqlDataReader = cmd.ExecuteReader()
            Try
                Do While sdr.Read()
                    MemberName = sdr.GetString(0) & " " & sdr.GetString(1)
                Loop
            Finally
                sdr.Close()
            End Try
        Finally
            cmd.Connection.Close()
        End Try

        Return MemberName

 

However I am still getting the value coming from the DisplayName field of the CuteChatUser table. Am I missing something?

 

Thanks.

It should work. You need to try another user name to test this change.

 

For example, you usually login your application as "admin". Now you need to test it using another username "John".

 

The simple way to test it:

 

 public string GetUserDisplayName(string useruniquename)
 {
    return useruniquename + "test";
 }