url redirection in ASP.NET [Resolved]

sorry,By mistake i am copying that Insert statement,
data in correctly their in database

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

@Anilbabu.M
Mark As Answer, if this helps u.

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

You can use query strings to pass values from one page to another. It will also show that in the url.

G. S.
.Net Developer

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

I am Trying But It Displying Only Column value,
But I want Open That value (EX:www.google.com) open Google website

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

When you will get the value, then using Request.QueryStrings(""), get the url i.e. www.google.com and then redirect to that page using
Server.Transfer("www.google.com")

G. S.
.Net Developer

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

@Anilbabu.M
you want to redirect on another web site ??? ( url from database )

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

yes ,
I want Load the page after,I am passing one Parameter TagId, basing on the TagId(column) display The corresponding Another column(EX:sitename) value(Ex:www.google.com) ,
For example I am passing TagId=1 That corresponding Sitename(column) value(ww.google.con) directly That website will open,
That my task

EX:
TagId sitename

1 www.google.com
2 www.gmail.com
3 www.asp.net

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

I am trying This example below Attaching Project using dept table basing on dept table deptno base displaydname as a web address
 Download source file

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Try this

 if (!IsPostBack)

        {

            if (Request.QueryString["TagId"] != null)

            {

                string PageName = "http://www.google.com";  // Value from Database based on Your Query String ID.

                Response.Redirect(PageName);

            }

        }

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Hey Anilbabu,

using Query Strings get the TagId = 1 value from the previous page, now by using this TagId = 1, get the url from the database.
Now when you will get the url just call Server.Transfer("Name of the url");

G. S.
.Net Developer

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Thank you for giving Answer my question,
its working normal redirecting ,

This value not coming from DB table,
once check my Attachment example sourcecode based on deptno column dname value(Www.google.com)will displa in Browser,

Send complete example sourcecode

Thank you,
anil

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Give me the Complete source code

Thank you,
anil

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

please find attached source code.

or Change ur GridView Design

 

<asp:GridView ID="GvEmp" runat="server" 

 EmptyDataText="There Are No Employees In Selected Department" AutoGenerateColumns="false">

 <Columns>

     <asp:TemplateField HeaderText="Redirect URL">

       <ItemTemplate>

        <a href='<%#"http://"+Eval("Dname") %>'><%#Eval("Dname") %></a>

       </ItemTemplate>

       </asp:TemplateField>

    </Columns>

 </asp:GridView>

 Download source file

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Thank you so much,
I have a one more Question
I have select That particular Deptno immediately open that particular website in Dname column value, it is possible???

In my example is open Next page after selecting after it open ,

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Try this,

string Dno = Request.QueryString["Dno"];

SqlConnection con = new SqlConnection(

@"Data Source=WIN-6B644RU4JEH\SQLEXPRESS;Initial Catalog=anil;Integrated Security=True");

SqlCommand cmd = new SqlCommand("select Dname from DEPT where Deptno=" + Dno, con);

con.Open();

SqlDataReader dr = cmd.ExecuteReader();

string PageName = "http://" + dr[0].ToString(); 

con.Close();

Response.Redirect(PageName);

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Where to write that code
I am writting that code in second form but
Getting an error
error is:Invalid attempt to read when no data is present.

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

if u are getting error "Invalid attempt to read when no data is present."
it means your query will return Null value.

try this on second page load event.

       string Dno = Request.QueryString["Dno"];

                SqlConnection con = new SqlConnection(

                @"Data Source=WIN-6B644RU4JEH\SQLEXPRESS;Initial Catalog=anil;Integrated Security=True");

                SqlDataAdapter da = new SqlDataAdapter("select Dname from DEPT where Deptno=" + Dno, con);

                DataSet ds = new DataSet();

                da.Fill(ds);

                if (ds.Tables[0].Rows.Count > 0)

                {

                    string PageName = "http://" + ds.Tables[0].Rows[0]["Dname"].ToString();

                    Response.Redirect(PageName);

                }

                else

                {

                    // No Record found

                }

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Getting an error
Error is:can't find the server at dname

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

@ Anilbabu check ur database connectivity with sql or table data
Try this sample hard code on page load it will redirect u to www.google.com

  

                DataTable dt = new DataTable();

                dt.Columns.Add("Dname", typeof(string));

                dt.Rows.Add("www.google.com");



                if (dt.Rows.Count > 0)

                {

                    string PageName = "http://" + dt.Rows[0]["Dname"].ToString();

                    Response.Redirect(PageName);

                }

                else

                {

                    // No Record found

                }

Note : Bind ur sql data with DataTable.

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

there is no problem in database&connection,
Its working fine but i am select any one google ony will open,

What i am selecting that only will open corresponding dname value

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Please share ur Database Table structure with Data.

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

USE [anil]
GO

/****** Object: Table [dbo].[DEPT] Script Date: 08/08/2012 16:38:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DEPT](
[Deptno] [int] NOT NULL,
[Dname] [varchar](50) NULL,
[Loc] [varchar](50) NULL,
CONSTRAINT [PK_DEPT] PRIMARY KEY CLUSTERED
(
[Deptno] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

*********
INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(10,'www.google.com','vja')
GO
INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(10,'www.asp.net','gun')
GO
INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(10,'www.gmail.com','ong')
GO

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

check above in ur insert query, deptno are the same in all rows.
so insert Unique Deptno in all rows
For eg:

INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(1 ,'www.google.com','vja')
GO
INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(2 ,'www.asp.net','gun')
GO
INSERT INTO [anil].[dbo].[DEPT]
([Deptno]
,[Dname]
,[Loc])
VALUES
(3 ,'www.gmail.com','ong')
GO

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

sorry,By mistake i am copying that Insert statement,
data in correctly their in database

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator

Any idea solve my problem plz

zzcc

Anilbabu.M, if this helps please login to Mark As Answer. | Alert Moderator