Redirect to Page after fetching its URL from database in ASP.Net

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Jun 17, 2013 07:12 AM
Forum: User Controls
Answer: 2
Views: 5220

I have House_info Table in database

Id	Name	Behcode	Password	T_name
1	Sara	1111	1212	Store
2	Jack	2222	4545	Estate

and I have Admin.aspx page

in this page I have EnterBTN Button and 2 Textbox TxtBeh and TxtPass here users enter Behcode and Password and when they click on EnterBTN Button it go to other page

below is EnterBTN Event code

 protected void EnterBTN_Click(object sender, ImageClickEventArgs e)
    {
        string data = Server.UrlEncode(Txtbeh.Text);
        SqlCommand _cmd = new SqlCommand("EnterStore", _cn);
        _cmd.CommandType = CommandType.StoredProcedure;
        _cn.Open();

        _cmd.Parameters.AddWithValue("@Behcode", Txtbeh.Text);
        _cmd.Parameters.AddWithValue("@PassWord", Txtpass.Text);
        bool isValid = aspcap.Validate(Txtc.Text.Trim());
        if (isValid)
        {
            int count = Convert.ToInt32(_cmd.ExecuteScalar());
            if (count > 0)
            {
                Session["Login"] = true;
               
                Session["BehCode"] = Server.UrlEncode(Txtbeh.Text);
                Response.Redirect("Managers.aspx?BehCode=" + Server.UrlEncode(Txtbeh.Text));

            }
            else
            {
                Session["Login"] = null;
                Session["MessageError"] = true;
                lblcap.Visible = false;

            }


        }

        else
        {
            lblcap.Visible = true;

        }


        _cn.Close();

        Alert();

    }

here if users enter correct Behcode and password it go to Manager.aspx page

I want if users enter correct behcode and password if their T_name was =Store it go to Manager.aspx page And if their T_name was Estate it go to Estate.aspx page

How I can do it ?

BestRegards

RkHirpar...

0 1

Reply
ANSWER
User: RkHirpara
Replied: on Jun 18, 2013 05:12 AM
Report

Hi Nedash,

You need to update your SP as below,.

DECLARE @tbl TABLE
(
	Id INT
	,Name VARCHAR(50)
	,Behcode VARCHAR(50)
	,Password VARCHAR(50)
	,T_name VARCHAR(50)
)

INSERT INTO @tbl
SELECT 1, 'Sara', '1111' ,'1212' ,'Store'
UNION ALL
SELECT 2, 'Jack' ,'2222' ,'4545' ,'Estate'
--------------------------------------
-- INPUT PARAMETERS
DECLARE @Behcode VARCHAR(50),
		@PassWord VARCHAR(50)
		
SELECT @Behcode = '1111', @PassWord = '1212'
--------------------------------------
DECLARE @RedirectionPage VARCHAR(50)
SELECT @RedirectionPage = (CASE WHEN T_name = 'Store' THEN 'Manager.aspx' WHEN T_name = 'Estate' THEN 'Estate.aspx' ELSE NULL END) FROM @tbl
	WHERE Behcode = @Behcode AND [Password] = @PassWord
	
SELECT @RedirectionPage

Here you will get Page Name so use string.Format in

Response.Redirect("Managers.aspx?BehCode=" + Server.UrlEncode(Txtbeh.Text));

above line of code, but before that check for string.IsNullOrEmpty()

Update your this event accordingly.

Thanks and Regards,

Rk_Hirpara

RkHirpar...

0 6

Reply
ANSWER
User: RkHirpara
Replied: on Jun 21, 2013 11:32 PM
Report

Hi Neda,

Below the line,

url = string.Format("{0}?BehCode={1}", url, Server.UrlEncode(Txtbeh.Text));

Add line

Responce.Redirect(url)

Thanks and Regards,

Rk_Hirpara.

Redirect to Page after fetching its URL from database in ASP.Net

Company

Explore

Follow us

Contact Us