How to redirect a page based on if condition

Question

5.00/5 (1 vote)

See more:

I have "logintable" contains id,username,password
&
another table "userdetailtable" it contains id, and more columns.

I want to go userdetailedit.aspx page if user not filling the details in userdetailtable (first time login user) or particular id,records not present in userdetailtable.

OR

I want to go user home.aspx page if users detail are present in userdetailtable (already filling user)

---Now how to i use if condition in asp.net web page

What I have tried:

i tried many things

string s = "select id from logintable where exists (select id from userdetailtable where id = logintable.id)"

if (Session(["id"].ToString() == s.ToString())

Posted 11-Feb-18 21:26pm

Member 13673753

Updated 12-Feb-18 21:08pm

Add a Solution

Comments

ZurdoDev 12-Feb-18 14:27pm

This is very, very easy to do so where are you stuck? I do not understand.

Laxmidhar tatwa technologies 13-Feb-18 1:58am

In where condition send session data.
U can use count statement

Richard Deeming 13-Feb-18 10:12am

NEVER store passwords in plain text!

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

1 solution

Add a Solution

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

Rajesh Pandya · Answer 1 · 2018-02-12T21:03:00

You can code as below for redirect page based on condition:

protected void btn_login_Click(object sender, EventArgs e)
{
	try
	{
		System.Data.SqlClient.SqlDataAdapter sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter("your query", "connectionstring");	
		DataSet dsResult = new DataSet();
		sqlDataAdapter.Fill(dsResult);

		if (dsResult.Tables[0].Rows.Count > 0)
		{
			redirect to home.aspx
		}
		else
		{
			redirect to userdetailedit.aspx
		}
	}
	catch (Exception ex)
	{
		throw ex;
	}
}

How to redirect a page based on if condition

1 solution

Solution 1

Add your solution here

Preview 0

How to redirect a page based on if condition

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us