Click here to Skip to main content
15,897,131 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow do i convert Excel database file to Sql server database file Pin
cynara23-May-07 18:55
cynara23-May-07 18:55 
Questionhow can i convert rtf document to HTML document ... Pin
koolprasad200323-May-07 18:46
professionalkoolprasad200323-May-07 18:46 
AnswerRe: how can i convert rtf document to HTML document ... Pin
Johan Hakkesteegt23-May-07 21:18
Johan Hakkesteegt23-May-07 21:18 
GeneralRe: how can i convert rtf document to HTML document ... Pin
koolprasad200323-May-07 22:47
professionalkoolprasad200323-May-07 22:47 
GeneralRe: how can i convert rtf document to HTML document ... Pin
Johan Hakkesteegt24-May-07 0:13
Johan Hakkesteegt24-May-07 0:13 
GeneralRe: how can i convert rtf document to HTML document ... Pin
koolprasad200324-May-07 0:49
professionalkoolprasad200324-May-07 0:49 
GeneralRe: how can i convert rtf document to HTML document ... Pin
Johan Hakkesteegt24-May-07 1:42
Johan Hakkesteegt24-May-07 1:42 
Questiontext to speech Pin
Sonia Gupta23-May-07 18:30
Sonia Gupta23-May-07 18:30 
I was trying to make a text to speech program .for that i am writing the following code.

Public Class Form1<br />
<br />
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        If (TextBox1.Text.Trim <> "") Then<br />
            TextBox1.Text = CType(TextBox1.Text.Trim, Integer)<br />
            Dim no As Integer = CType(TextBox1.Text.Length, Integer)<br />
            If (no <= 0) Then Exit Sub<br />
            Select Case no<br />
                Case 1<br />
                    MessageBox.Show(ones(TextBox1.Text))<br />
                Case 2<br />
                    MessageBox.Show(tens(TextBox1.Text))<br />
                Case 3<br />
                    MessageBox.Show(Hundered(TextBox1.Text))<br />
                Case 4<br />
                    MessageBox.Show(Thousand(TextBox1.Text))<br />
                Case 5<br />
                    MessageBox.Show(TenThousand(TextBox1.Text))<br />
                Case 6<br />
                    MessageBox.Show(Lakh(TextBox1.Text))<br />
                Case 7<br />
                    MessageBox.Show(TenLakh(TextBox1.Text))<br />
                Case 8<br />
                    MessageBox.Show(Crore(TextBox1.Text))<br />
                Case 9<br />
                    MessageBox.Show(tenCrore(TextBox1.Text))<br />
            End Select<br />
        End If<br />
    End Sub<br />
<br />
    Private Function tenCrore(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (Not CInt(digit.Substring(0, 2)) = 0) Then<br />
            str = tens(digit.Substring(0, 2)) & " Crore "<br />
        End If<br />
        If (Not CInt(digit.Substring(2, 7)) = 0) Then<br />
            Return str & TenLakh(digit.Substring(2, 7))<br />
        Else<br />
            Return str<br />
        End If<br />
    End Function <br />
<br />
    Private Function Crore(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (Not CInt(digit.Substring(0, 1)) = 0) Then<br />
            str = ones(digit.Substring(0, 1)) & " Crore "<br />
        End If<br />
        If (Not CInt(digit.Substring(1, 7)) = 0) Then<br />
            Return str & TenLakh(digit.Substring(1, 7))<br />
        Else<br />
            Return str<br />
        End If<br />
    End Function<br />
<br />
    Private Function TenLakh(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (Not CInt(digit.Substring(0, 2)) = 0) Then<br />
            str = tens(digit.Substring(0, 2)) & " Lakh "<br />
        End If<br />
        If (Not CInt(digit.Substring(2, 5)) = 0) Then<br />
            Return str & TenThousand(digit.Substring(2, 5))<br />
        Else<br />
            Return str<br />
        End If<br />
    End Function<br />
<br />
    Private Function Lakh(ByVal digit As String) As String<br />
        Dim str As String = CType(digit, String)<br />
        Return ones(str.Substring(0, 1)) & " Lakh " & TenThousand(str.Substring(1, 5))<br />
    End Function<br />
<br />
    Private Function TenThousand(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (Not CInt(digit.Substring(0, 2)) = 0) Then<br />
            str = tens(digit.Substring(0, 2)) & " Thousand "<br />
        End If<br />
        If (Not CInt(digit.Substring(2, 3)) = 0) Then<br />
            Return str & Hundered(digit.Substring(2, 3))<br />
        Else<br />
            Return str<br />
        End If<br />
    End Function<br />
 <br />
    Private Function Thousand(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (Not CInt(digit.Substring(0, 1)) = 0) Then<br />
            str = ones(digit.Substring(0, 1)) & " Thousand "<br />
        End If<br />
        If (Not CInt(digit.Substring(1, 3)) = 0) Then<br />
            Return str & Hundered(digit.Substring(1, 3))<br />
        Else<br />
            Return str<br />
        End If<br />
<br />
        ' Return ones(str.Substring(0, 1)) & " Thousand " & Hundered(str.Substring(1, 3))<br />
    End Function<br />
<br />
    Private Function Hundered(ByVal digit As String) As String<br />
        Dim str As String = ""<br />
        If (CInt(digit.Substring(0, 1) > 0)) Then<br />
            str = ones(digit.Substring(0, 1)) & " Hundred "<br />
        End If<br />
        If (CInt(digit.Substring(1, 2) > 0)) Then<br />
            If (CInt(digit.Substring(1, 2)).ToString.Length = 1) Then<br />
                Return (str & " " & ones(digit.Substring(1, 2)))<br />
            Else<br />
                Return (str & " " & tens(digit.Substring(1, 2)))<br />
            End If<br />
<br />
<br />
        Else<br />
            Return str<br />
        End If<br />
    End Function<br />
<br />
    Private Function tens(ByVal digit As String) As String<br />
        Dim digt As Integer = Convert.ToInt32(digit)<br />
        Dim name As String = ""<br />
        Select Case (digt)<br />
            Case 10<br />
                name = "Ten"<br />
            Case 11<br />
                name = "Eleven"<br />
                Exit Select<br />
            Case 12<br />
                name = "Twelve"<br />
                Exit Select<br />
            Case 13<br />
                name = "Thrirteen"<br />
                Exit Select<br />
            Case 14<br />
                name = "Fourteen"<br />
                Exit Select<br />
            Case 15<br />
                name = "Fifteen"<br />
                Exit Select<br />
            Case 16<br />
                name = "Sixteen"<br />
                Exit Select<br />
            Case 17<br />
                name = "Seventeen"<br />
                Exit Select<br />
            Case 18<br />
                name = "Eighteen"<br />
                Exit Select<br />
            Case 19<br />
                name = "Nineteen"<br />
                Exit Select<br />
            Case 20<br />
                name = "Twenty"<br />
                Exit Select<br />
            Case 30<br />
                name = "Thity"<br />
                Exit Select<br />
            Case 40<br />
                name = "Fourty"<br />
                Exit Select<br />
            Case 50<br />
                name = "Fifty"<br />
                Exit Select<br />
            Case 60<br />
                name = "Sixty"<br />
                Exit Select<br />
            Case 70<br />
                name = "Seventy"<br />
                Exit Select<br />
            Case 80<br />
                name = "Eighty"<br />
                Exit Select<br />
            Case 90<br />
                name = "Ninty"<br />
                Exit Select<br />
            Case Is > 20<br />
                Dim str As String = CType(digit, String)<br />
                name = tens(str.Substring(0, 1) & "0") & " " & ones(str.Substring(1, 1))<br />
        End Select<br />
        Return name<br />
    End Function<br />
<br />
    Private Function ones(ByVal digit As String) As String<br />
<br />
        Dim digt As Integer = Convert.ToInt32(digit)<br />
        Dim name As String = ""<br />
        Select Case (digt)<br />
            Case 0<br />
                name = "Zero"<br />
            Case 1<br />
                name = "One"<br />
                Exit Select<br />
            Case 2<br />
                name = "Two"<br />
                Exit Select<br />
            Case 3<br />
                name = "Three"<br />
                Exit Select<br />
            Case 4<br />
                name = "Four"<br />
                Exit Select<br />
            Case 5<br />
                name = "Five"<br />
                Exit Select<br />
            Case 6<br />
                name = "Six"<br />
                Exit Select<br />
            Case 7<br />
                name = "Seven"<br />
                Exit Select<br />
            Case 8<br />
                name = "Eight"<br />
                Exit Select<br />
            Case 9<br />
                name = "Nine"<br />
                Exit Select<br />
        End Select<br />
        Return name<br />
    End Function<br />
<br />
    Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress<br />
        If (e.KeyChar = "1" Or e.KeyChar = "2" Or e.KeyChar = "3" Or e.KeyChar = "4" _<br />
        Or e.KeyChar = "5" Or e.KeyChar = "6" Or e.KeyChar = "7" Or e.KeyChar = "8" _<br />
        Or e.KeyChar = "9" Or e.KeyChar = "0" Or e.KeyChar = Chr(Keys.Back)) Then<br />
            e.Handled = False<br />
        Else<br />
            e.Handled = True<br />
        End If<br />
    End Sub<br />
End Class


for text to speech i was thinking to create a audio files for each of the following numbers.

0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,30,40,50,60,70,80,90

Now My Question is
1. Am I think right to create the audio files for each of the above numbers ?
2. Which audio extention file(.wav , mp3 .. etc ) will be useful .I meant which takes less space.
AnswerRe: text to speech Pin
_Damian S_23-May-07 18:45
professional_Damian S_23-May-07 18:45 
QuestionRe: text to speech Pin
Sonia Gupta23-May-07 18:49
Sonia Gupta23-May-07 18:49 
AnswerRe: text to speech Pin
_Damian S_23-May-07 18:54
professional_Damian S_23-May-07 18:54 
AnswerRe: text to speech Pin
Christian Graus23-May-07 20:07
protectorChristian Graus23-May-07 20:07 
QuestionRe: text to speech Pin
Sonia Gupta23-May-07 20:20
Sonia Gupta23-May-07 20:20 
AnswerRe: text to speech Pin
Christian Graus23-May-07 21:27
protectorChristian Graus23-May-07 21:27 
QuestionRe: text to speech Pin
Sonia Gupta23-May-07 21:48
Sonia Gupta23-May-07 21:48 
AnswerRe: text to speech Pin
Dave Kreskowiak24-May-07 4:47
mveDave Kreskowiak24-May-07 4:47 
Questionbutton click Pin
Sonia Gupta23-May-07 18:20
Sonia Gupta23-May-07 18:20 
AnswerRe: button click Pin
_Damian S_23-May-07 18:32
professional_Damian S_23-May-07 18:32 
QuestionRe: button click Pin
Sonia Gupta23-May-07 18:42
Sonia Gupta23-May-07 18:42 
AnswerRe: button click Pin
_Damian S_23-May-07 18:52
professional_Damian S_23-May-07 18:52 
QuestionRe: button click Pin
Sonia Gupta23-May-07 19:39
Sonia Gupta23-May-07 19:39 
QuestionRe: button click Pin
Sonia Gupta23-May-07 19:53
Sonia Gupta23-May-07 19:53 
AnswerRe: button click Pin
_Damian S_23-May-07 19:57
professional_Damian S_23-May-07 19:57 
AnswerRe: button click Pin
Ch_Shahzad iqbal24-May-07 2:16
Ch_Shahzad iqbal24-May-07 2:16 
AnswerRe: button click Pin
shally_7924-May-07 2:22
shally_7924-May-07 2:22 

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.