Comments by Member 9171128 (Top 7 by date)

You are under standing my question?
plz tell me any modifications in the above code,
Sending sms us,uk and India also
How can i implement that one
plz help me

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 ........
I am pure in ENGLISH

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

HOW IT IS POSSIBLE?