forum

Home / DeveloperSection / Forums / When ever a redirect page automatically send sms World wide using asp.net?

When ever a redirect page automatically send sms World wide using asp.net?

anil babu 3940 09-Oct-2012
I have URL like this http://127.0.0.1:81/Redirect.aspx?TagId=1,
In that I am passing querystring parameter value comming from database,
Based on tad id It will display Another column is their in database(URL)

My question is I want to changing query string parameter One page will open(That page url comming from database table)along with that one I will send sms to number based on TagId

MYProgram:
Page1.aspx
<asp:GridView ID="QS1" runat="server" AutoGenerateSelectButton="True" AutoGenerateColumns="false"
        onselectedindexchanging="GvDept_SelectedIndexChanging">
        
.cs
protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=<>;Initial Catalog=productdb;Persist Security Info=True;User ID=<>;Password=<>");

        SqlDataAdapter da = new SqlDataAdapter("select * from redirecturl", con);

        DataSet ds = new DataSet();
        da.Fill(ds, "redirecturl");
        QS1.DataSource = ds.Tables["redirecturl"];
        QS1.DataBind();
        QS1.DataKeyNames = new string[] { "Tagid" };
    }
    protected void GvDept_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        QS1.SelectedIndex = e.NewSelectedIndex;

        string Dno = QS1.SelectedValue.ToString();        
        Response.Redirect("~/Page2.Aspx?TagId="+Dno);
        
    }
Page2.aspx
<div>
    <asp:GridView ID="QS2" runat="server" 
        EmptyDataText="There Are No Employees In Selected Department" 
            AutoGenerateColumns="false" Width="99px">
        
        <br />
        
        <iframe width="100%"  runat="server" id="ifrmBrs">your browser does not support IFRAMEs</iframe>

    </div>
.cs
String URL = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        string Dno = Request.QueryString["TagId"];
        
        SqlConnection con = new SqlConnection(@"Data Source=<>;Initial Catalog=productdb;Persist Security Info=True;User ID=<>;Password=<>");

       

        SqlCommand cmd = new SqlCommand("select coupounurl from redirecturl where Tadid=" + Dno, con);

        con.Open();
        
        SqlDataReader dr = cmd.ExecuteReader();
        QS2.DataSource = dr;
        QS2.DataBind();
        dr.Close();

        object drReader = cmd.ExecuteScalar();
        if (drReader != null)
        {
            URL = drReader.ToString();
        }

        con.Close();
        if (!String.IsNullOrEmpty(URL))
        {
            //Use Iframe if it works               
            ifrmBrs.Attributes["src"] =URL;
}
}
I am trying this one
My QUESTION IS tABLE Tagid coupounurl phonenumber 1 http://page4.aspx 655666666 2 http://page5.aspx 67867668 3 http://page6.aspx 6868769879 Based on tag id Redirect perticular url, In redirect perticular url based on TagId I want to send sms to perticular pnonenumber(Worldwide) I dont known idea on sending sms plz help me ........

Updated on 14-Oct-2012

Can you answer this question?


Answer

2 Answers

Liked By