locked
SMS RRS feed

  • Question

  • User364663285 posted

    Hi,
    Is there any .NET or third party utility, that we can use to directly send out SMS message to one phone number from the SQL database? Pls note that the phone number is also with the different country codes. 

    Monday, April 12, 2010 11:00 PM

All replies

  • Monday, April 12, 2010 11:49 PM
  • User364663285 posted

    Thanks for the feedbacks. I check these codes from the following link. I wanna know how we could handle the problem with different country codes.
    private void Send_Click(object sender, System.EventArgs e)
    {
        try
        {
            SmsTest.net.webservicex.www.SendSMS smsIndia=
                  new SmsTest.net.webservicex.www.SendSMS();
            SmsTest.com.webservicex.www.SendSMSWorld smsWorld = 
             new SmsTest.com.webservicex.www.SendSMSWorld();
            if(rdoType.SelectedValue == "1")
                smsIndia.SendSMSToIndia(txtMobileNo.Text.Trim(),
                        txtEmailId.Text.Trim(), txtMessage.Text);
            else
                smsWorld.sendSMS(txtEmailId.Text.Trim(),
                        txtCountryCode.Text.Trim(),
                        txtMobileNo.Text.Trim(), txtMessage.Text);
            lblMessage.Visible = true;
            lblMessage.Text="Message Send Succesfully";
        }
        catch(Exception ex)
        {
            lblMessage.Visible = true;
            lblMessage.Text="Error in Sending message"+ex.ToString();
        }
    }

    private void rdoType_SelectedIndexChanged(object sender, System.EventArgs e)
    {
        if(rdoType.SelectedValue =="1")
            txtCountryCode.Enabled = false;
        else
            txtCountryCode.Enabled = false;
    }

    http://www.codeproject.com/KB/aspnet/SendingSMS.aspx

    And I also prefer the way for handling this in the DB

    Tuesday, April 13, 2010 12:50 AM
  • User364663285 posted

    Is it possible that we can also send the SMS from the triggers in the database? 

    Wednesday, April 14, 2010 11:21 PM