SMS

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. 

Answer 1

User-1636183269 posted

http://forums.asp.net/p/1542598/3762239.aspx#3762239

http://forums.asp.net/p/1459384/3777721.aspx#3777721 

Answer 2

User-1636183269 posted

http://forums.asp.net/p/1534413/3722707.aspx#3722707 

Answer 3

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

Answer 4

User364663285 posted

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