SELECT บน MSSQL แล้วเป็น ???? ค่ะ แก้ไขยังไงคะ ตัว ฐานข้อมูลเป็น SQL_Latin1_General_CP1_CI_AS ค่ะ คือจะ select แล้วทำ case กับภาษาไทย

   Public Shared Function GetSimpleThai() As String

        Dim SQLCommandStr As String = "SELECT CONVERT(NVARCHAR(10),'งง');"
        Dim MyConn As SqlConnection = New SqlConnection(SQlConnectionString)
        Dim MyCommand = New SqlCommand(SQLCommandStr, MyConn)
        Dim retStr As String
        
        Dim UniCodeEncode As Encoding = Encoding.Unicode
        Dim MyEncode As Encoding = Encoding.Default

        Try
            MyConn.Open()
            Dim acceptByes As Byte() = UniCodeEncode.GetBytes(MyCommand.ExecuteScalar().ToString())
            retStr = Convert.ToBase64String(acceptByes)
            'retStr = MyCommand.ExecuteScalar().ToString()

        Catch ex As Exception
            retStr = "Error"
            Throw New Exception(ex.Message)
        Finally
            If Not (MyConn Is Nothing) Then MyConn.Close()
        End Try

        Return retStr

    End Function

Dim acceptByes As Byte() = UniCodeEncode.GetBytes(MyCommand.ExecuteScalar().ToString())
retStr = System.Text.Encoding.UTF8.GetString(acceptByes)

using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("xxx"))
            {
                string strSql = "SELECT @gg";
                conn.Open();
                System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSql, conn);
                cmd.Parameters.Add("@gg", SqlDbType.NVarChar).Value = "งง";
                System.Data.SqlClient.SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                if (drd.Read())
                {
                    string s = drd[0].ToString();
                }
                drd.Close();
            }