How to redirect to different pages using stored procedure in Asp.net c#

Question

4.00/5 (1 vote)

See more:

Dear All,

am working on Asp.net , C#, SqlServer 2005

In this project i have two panels 1)Admin 2)User
In Admin Folder I have all admin pages & in user folder i have all user pages.

now here am using store procedure to redirect to different pages
If admin Logged-in, it must redirect to admin pages &
If User Logged-in, it must redirect to user pages.

This is my code....

C#

protected void BtnLogin_Click(object sender, ImageClickEventArgs e)
   {
       DataTable dt = new DataTable();
       try
       {
           SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CollegeDataBaseConnectionString"].ConnectionString);
           SqlDataAdapter adp = new SqlDataAdapter("CHECK_UserAccounts_Proc", con);
           adp.SelectCommand.CommandType = CommandType.StoredProcedure;
           adp.SelectCommand.Parameters.Add("@USERNAME", SqlDbType.VarChar, 50).Value = TxtUserName.Text.Trim();
           adp.SelectCommand.Parameters.Add("@PASSWORD", SqlDbType.VarChar, 50).Value = TxtPassword.Text.Trim();
           adp.Fill(dt);


           if (dt.Rows.Count > 0)
           {

               Response.Redirect("~/User/Home.aspx");
           }
           else
           {
       ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Invalid UserName or Password');", true);
           }
       }
       catch (Exception ex)
       {
           Response.Write("Error occured : " + ex.ToString());
       }
       finally
       {
           dt.Clear();
           dt.Dispose();
       }
   }

This is my Stored Procedure
---------------------------

SQL

CREATE PROCEDURE [dbo].[CHECK_UserAccounts_Proc]
                        @USERNAME VARCHAR(50),
                        @PASSWORD VARCHAR(50)
AS
BEGIN
 SELECT * FROM UserInformation WHERE USERNAME COLLATE Latin1_general_CS_AS =@USERNAME AND [PASSWORD] COLLATE Latin1_general_CS_AS=@PASSWORD
END

Please can you help.

Thanks.

Posted 1-Dec-13 22:56pm

Member239258

Updated 1-Dec-13 23:00pm

Sampath Lokuge

v2

Add a Solution

Comments

Sampath Lokuge 2-Dec-13 4:59am

What happened when you use above code ?

Member239258 2-Dec-13 5:03am

its working but am redirecting only to user pages

I am admin it should redirect to admin pages, if am user it must redirect to user pages.

presently in my code, it is redirecting to only user pages,

i want to redirect to admin pages also..

Please help.

Thanks..

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2013-12-01T23:07:00

Solution 1

You have to maintain the User Role in your 'UserInformation' table.Then you can check the 'User Role' of the logged-in user and according to that value where redirect it to the relevant page.

On User Role column you can have 'Admin','User',etc...

Posted 1-Dec-13 23:07pm

Sampath Lokuge

Updated 1-Dec-13 23:10pm

v2

Comments

Member239258 2-Dec-13 5:10am

ya, already i have mentioned UserType in Table

By the way.., my SqlTable Fields are UserName,Password,UserType

Sampath Lokuge 2-Dec-13 5:12am

So then just test the 'UserType' column value and according to that value do the redirection.

Thanks7872 · Answer 2 · 2013-12-01T23:11:00

First suggestion : Don't store password directly in database either in plain text or in encrypted format.

As per as the answer is concerned,i can't see the code where you are trying to redirect the Admins. Redirection has nothing to do with stored procedure.Well,there are two solutions: one is to use Roles,for that see these links :

Authenticate User by Roles in ASP.NET[^]

Understanding Role Management[^]

Another one is to have one column as roles in database. After successful login,check the user's role in database and redirect it accordingly.

Naresh Pansuriya · Answer 3 · 2013-12-02T01:30:00

Below is snippet code from your full code, please tried like below

C#

if (dt.Rows.Count > 0)
           {
               if (dt.Rows[0].Columns["UserType"] == "Admin")
               {
                    Response.Redirect("~/Admin/Home.aspx");
               }
               else
               {
                    Response.Redirect("~/User/Home.aspx");
               }
           }
           else
           {
       ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Invalid UserName or Password');", true);
           }

How to redirect to different pages using stored procedure in Asp.net c#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0