I want to send sms in all contact list in combobox using at command

43 views Asked by At

Here is my code

'FOR DISPLAY ALL CONTACT NUMBERS IN COMBOBOX Private Sub BroadcastSMS_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    Try
        Dim lnard As New MySqlConnection("server = localhost; userid = root; password = 12345; DATABASE = sms;")
        Dim da As MySqlDataAdapter = Nothing
        Dim DT As New DataTable
        Dim sql As String = " "
        sql = "select distinct contactNumber from students" 
        lnard .Open()
        da = New MySqlDataAdapter(sql, lnard)
        da.Fill(DT)

        With combobox1
            .DataSource = DT
            .DisplayMember = "contactNumber "
            .ValueMember = "contactNumber "
        End With
        lnard .Close()
    Catch ex As Exception

    End Try

' FOR SENDING SMS

    Try
        If SerialPort1.IsOpen Then
            SerialPort1.Close()
        End If


        Dim message As String
        '' message = tbUserName.Text
        message = " Notification : " + " " + tbMessage.Text
        SerialPort1.Open()
        If SerialPort1.IsOpen() Then
            SerialPort1.Write("AT" & vbCrLf)
            SerialPort1.Write("AT+CMGF=1" & vbCrLf)
            SerialPort1.Write("AT+CMGS=" & Chr(34) & combobox1.Text & Chr(34) & vbCrLf)
            SerialPort1.Write(message & Chr(26))
            MsgBox("Message Sent")
            SerialPort1.Close()
0

There are 0 answers