how to send message

I guess, you want to get the data from the DB and sent the data as SMS. I'm not sure what type of data you are retrieve from DB. I hope it may be any password/code or some thing like that. Also, the data size will be from 1 to 120 char length.

You can get the data from the DB, you could do some thing like below:

        public DataTable GetAllStudents()
        {
            DataTable dt = new DataTable();
            string strConString = "Data Source=(local);Initial Catalog=MyDB;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(strConString))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from tblStudents", con);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                con.Close();
            }
            return dt;
        }

In order to sent SMS the below post can be helpful for you:

http://www.aspdotnetchamp.com/2013/11/learn-by-experience-sms-gateways.html

http://www.aspdotnetchamp.com/2015/08/how-to-send-sms-from-aspnet-web.html

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
any na,esspace for message send
What you meant exactly? Add some more clarity on your question.
0
Gokul10y ago
any na,esspace for message send
0
Rajeesh Menoth10y ago
Hi,

Check the following reference :

http://www.ozekisms.com/index.php?owpn=309
0
Francis Susaimichael10y ago
I guess, you want to get the data from the DB and sent the data as SMS. I'm not sure what type of data you are retrieve from DB. I hope it may be any password/code or some thing like that. Also, the data size will be from 1 to 120 char length.
You can get the data from the DB, you could do some thing like below:
        public DataTable GetAllStudents()
        {
            DataTable dt = new DataTable();
            string strConString = "Data Source=(local);Initial Catalog=MyDB;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(strConString))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from tblStudents", con);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                con.Close();
            }
            return dt;
        }

In order to sent SMS the below post can be helpful for you:

http://www.aspdotnetchamp.com/2013/11/learn-by-experience-sms-gateways.html

http://www.aspdotnetchamp.com/2015/08/how-to-send-sms-from-aspnet-web.html
0