Web Forms :: Redirect A User Based On Column In Database?

Feb 15, 2011

I have an employee list in MSSQL. I have an online punch clock. In the DB there is a column called punch_clock. I would like to redirect a user to a different page if there is a 0 in this column. I have the code below so far. Not sure where to go from here.

[Code]....

View 5 Replies


Similar Messages:

How To Redirect Page Based On User

Jul 22, 2010

i created a web application which has a media player in between,but when i open the application on my ipad or ipod, the video doesnt play as the video player doesnt support ipod and ipad,,

i found out a way with which i can play it but how can i redirect the page based on the client side.

i would like to know a C# code to know what kind of browser the user is using.

View 2 Replies

C# - Redirect To Url Based On User Data?

Sep 8, 2010

When someone logs on to my site. I want to direct them to their own home page. If the user has the id of 1. They would go to[URL] I already have the login and id setup. I am not sure how to incorporate it into the url.

View 2 Replies

Security :: Want To Redirect The User After The Log In Based On His Role?

Mar 17, 2011

i want to redirect the user after the log in based on his role. e.g. admin, userI already read the other threads.. I already used this:

[Code]....

And this:

[Code]....

I also tried the above codes on the Page_Load event.

View 7 Replies

Security :: Want To Redirect User Based On The Login ID?

Jan 26, 2010

i am using asp.net membership. when users arrive at my sight they can enter user name and password.

I then want to redirect them to a page called "MyAccountPage.aspx" which is unique to them. could someone post the c sharp code that I can use to capture the Unique Id of the user is it best to then pass this as a parameter to a control on the aspx page that displays data for that user. am I correct in thinking that I need a UserId column in my data table as well.

View 1 Replies

Security :: How To Redirect Logged In User Based On Role

Nov 25, 2010

I want to know how can i redirect a user to a different page when he tries to access a page restricted to another role?

The scenario is as follows:

I have a folder "Gestao" that only allows users in role "Administrator"

[Code]....

If an anonymous user tries to access that folder he is redirected to the login page, but if a logged in user whose role is "friend" tries to access this folder he is also redirected to the login page. I want to redirect him to a page showing a message that he has no permission to access that page/area.

How can I do that? Should i have code on the Page_load event of the login page checking the user role and then redirect him to the correct page? Or is there some otherway to do this?

View 2 Replies

Web Forms :: Display Content On Page Based On Column In Database?

Jan 7, 2011

i am using MSSQL Server 2005 with VB in my codebehind. I have an application that I have written as a time tracking system that uses SQL Membership provider to secure the site with forms authentication. I want to add additional functionality to the site. My company has a intranet SharePoint site. I want to add something on the front page of the SharePoint site that will allow the users to clock-in/out without having to login to the application. I have a users table that is not part of the SQL Membership Provider that holds detailed information about the employees. There is a column in that table that identifies users as being able to use the clock-in system. I want to be able to display a clock-in/out button on the paged based on that column. Not all users have the ability to clock-in as their time does not need to be tracked.

View 3 Replies

Security :: How To Redirect To Specific Page Based On User Roles

Sep 12, 2010

I am using Formsauthentication. My situation is as per below:

the login form has codebehind :

protected void LoginButton_Click(object sender, EventArgs e)
{
TextBox uname = Login1.FindControl("UserName") as TextBox;
TextBox pass = Login1.FindControl("Password") as TextBox;
CheckBox rm = Login1.FindControl("RememberMe") as CheckBox;
Literal fail = Login1.FindControl("Literal1") as Literal;
if (Membership.ValidateUser(uname.Text, pass.Text))

[Code].....

Now the problem is that when I try to login with proper credentials it first redirects to default.aspx( there is no such page in my project), after login again with same credentials it properly redirects to the correct page. Why such problem arises? to fix this?

View 6 Replies

Security :: Redirect User Based On Role To Specific Web Page?

Apr 22, 2010

I'm not sure if this is possible or not, I'm using Roles to limit what pages a user can access based on there assigned Role. My question, is there anyway to redirect the user to a specific web page based on thier role after they login.

For example:

If Bob logs in with Role="Automotive", I want him to be redirected to Auto.aspx.If sue logs in with Role="Clothing", i want her to be redirected to cloths.aspx.

View 8 Replies

Forms Data Controls :: Gridcontrol With Template Column Calling Function Change Image Based On Database True Or False ?

Jun 8, 2010

I am planning to use grid view control, before was using datagrid, planning on switching to gridview:


<asp:TemplateField HeaderText="Deleted">
<ItemTemplate>
<asp:Image id=ImgDeleted runat="server" Height="13px" Width="21px" ImageUrl='<%# [code]...

View 4 Replies

Web Forms :: Display User Specific Information From Database - Based On Login ID

Jan 7, 2011

I have a online game (written in ASP) which i have finally decided to convert to ASP.NET. However i cannot seem to link the login ID's of users to their specific details in the database. I.E when Joe Bloggs logs in, he will be shown the team information for just his club, not every club. in ASP I use code similar to this below

[Code]....

im not convinced that is the right syntax to be using, but when i execute the code in Query Builder it is showing me the correct data (that i expect to see). So im wondering if there is something else im missing? Is there something extra that i need to be adding in Web.Config file or elsewhere?

View 30 Replies

How To Add Code To Redirect My User On Successful Submit To My Database

Apr 23, 2010

How to add code to redirect my user on successful submit to my database.

Code...

Imports System.Data
Imports System.Data.SqlClient
Partial Class CPD_OnlineSurvey
Inherits System.Web.UI.Page
Public Sub UpdateOnlineSurvey(ByVal sender As Object, ByVal e As EventArgs)
Using conn As New SqlConnection()
conn.ConnectionString = ConfigurationManager _
.ConnectionStrings("wincts").ConnectionString
Using cmd As New SqlCommand()
cmd.CommandText = "update OnlineSurvey set IsSelected = " & _
"@IsSelected where QuestionId=@QuestionId"
cmd.Connection = conn
conn.Open()
For Each item As ListItem In ChkOnlineSurvey.Items
cmd.Parameters.Clear()
cmd.Parameters.AddWithValue("@IsSelected", item.Selected)
cmd.Parameters.AddWithValue("@QuestionId", item.Value)
cmd.ExecuteNonQuery()
Next
conn.Close()
End Using
End Using
End Sub
End Class

View 2 Replies

User Controls :: Redirect To Page After Fetching Its URL From Database

Jun 17, 2013

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();

[code]....

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.

View 1 Replies

Web Forms :: How To Validate A Gridview Column Based On Another Checkbox Column

Apr 6, 2010

I have a gridview which displays following columns:

TaskID, TaskDescription, IsComplete, DateOfCompletion

Now what I want to achieve is, when user clicks IsComplete checkbox, she must enter the date of completion. So, I want a validation (client side) on DateOfCompletion if the checkbox is selected (checked). And, I also want to use Validator Callout Extender
if possible.

How can I achieve this?

View 2 Replies

Show User Specific Data From Database Based On LoginID Username?

Jan 21, 2011

I am attempting to convert an online game i have written in ASP into ASP.NET,, but I am failing at a very early and probably a very amateurish stage.

I am using a Sample ASPX project. There is an ASPNETDB database included, when i register my username is added to the DB along with a userID and various other fields. This is stored in a table called aspnet_Users.

The Login Control is stored in a Site.Master file

<div class="loginDisplay">
<asp:LoginView ID="HeadLoginView" runat="server" EnableViewState="false"
onviewchanged="HeadLoginView_ViewChanged">
<AnonymousTemplate>
[ <a href="~/Account/Login.aspx" ID="HeadLoginStatus" runat="server">Log In</a> ]
</AnonymousTemplate>
<LoggedInTemplate>
Welcome <span class="bold"><asp:LoginName ID="HeadLoginName" runat="server" /></span>!
[ <asp:LoginStatus ID="HeadLoginStatus" runat="server" LogoutAction="Redirect" LogoutText="Log Out" LogoutPageUrl="~/"/> ]
</LoggedInTemplate>
</asp:LoginView>

I have created a new table called tblClubs, which stores information such as ClubName, StadiumCapacity etc
I added a field called 'Owner' and this is directly related to the UserName field in the aspnet_Users table

What I am trying to solve is to show user specific information from the database, based on their LoginID.

i.e

My username is Laclerque and my club is called Racing Mongoose, the stadium capacity is 9500.. the information for each User needs to be different and just show the information that is relevant to them.

obviously in the longer term, there is going to be 100's of these associations required for the full game, but not until i can get my head around the basics of how to set this information. I tend to work better when i can see a working sample, and then adapt things to suit my needs.

View 1 Replies

DataSource Controls :: Search Various Database Columns Based On User's Input?

Nov 18, 2010

I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.

I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.

What's the best way to do a search?

I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches

[Code]....

for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches

[Code]....

for three textboxes, there are 8 combinations,

Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?

View 1 Replies

User Controls :: Enable Disable DropDownList Items Based On Database Values

Mar 20, 2014

May i know how to create the control function in asp.net  to control the values ?

Based on the DB table, it active is Y then enable values  in dropdownlist , if N then disable the values. 

View 1 Replies

Data Controls :: Change Value Of GridView BoundField Column Based On Value From Another Column

May 7, 2015

I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?

I have to add some columns which is not in the table and assign the values from code behind to that particular column

View 1 Replies

Web Forms :: Redirect Website Based On Selected Text?

Oct 18, 2010

how can i redirect to a different website if label1.text is "www.micro" and gridview selected row column(0) text is "soft.com"?

[Code]....

Neither did this

[Code]....

View 2 Replies

Web Forms :: Redirect To Page Based On The Number Or Index Entered In TextBox?

Jul 5, 2012

If I enter any number in a TextBox I want to open some .aspx page. I don't want to click on any button. How should I do this in asp.net?

View 1 Replies

Web Forms :: On Logout Redirect User To Login Page If User Clicks Back Button Of The Browser

Jul 9, 2010

after user loggs out if he clicks the browsers back button then users had to be redirected to login page

doenst matter how many time the user clicks on back button take him to login page

how to achieve this let me know

View 6 Replies

Forms Data Controls :: Link Checkbox With Bit Column, So Bit Column In SQL Database Gets Updated?

Mar 6, 2011

I'm currently working on a small project and therefore created a gridview, including one bit column which has been linked with a checkbox in both the itemtemplate as the edititemtemplate (autopostback = true).Databinding for these two checkboxes has been linked (two-way) to the bit column.Now I want to display the gridview to end-users. They should be able to just click on the checkbox so they value in the database column gets changed as well (as I want to run update queries behind it), but not passing via the command column 'EDIT'.=> problem I'm having now is that the bit column in the database doesn't get updated.

View 3 Replies

Redirect Based On IP Address?

Feb 2, 2010

I need to redirect some users based on their ip address to specific page else they would be redirected to another page my code is as below.

string myIP = HttpContext.Current.Request.UserHostAddress.ToString();

switch(myIP)

{ [code]....

View 2 Replies

How To Redirect Based On Selection Of DropDownList

Jul 26, 2010

I have a TextBox1 and a Search button in my application with this following code:
protected void Button1_Click(object sender, EventArgs e) {
Response.Redirect("~\searchpage.aspx?PatientNRIC=" + TextBox1.Text); }

Which means, if the user type ONLY IC NO:S1234567D, then when click it will show the patient detailview. So I now I'm doing almost the same thing but now I have a TextBox2 and a DropDownList1. Inside DropDownList1, I have "Name", "IC No", "Test_Date". So for an example, I type "S1234567D" in the textbox1, and I choose "IC No" in DropDownList1 it should redirect me to a page of the S1234567D's patient detailview. How could I do my code?

View 2 Replies

Security :: Redirect To Different Folders Based On Roles?

Jul 4, 2010

I have implemented membership and enable role based on. I have 2 roles "admin" and "super_admin" and once the user login, I want to redirect them to different folder based on their role. My guess is, the redirection need to be determined once the user clicked login on the login control and here is my code.

[Code]....

However, whenever the user login (regardless of admin or super_admin) the page keeps redirection to Anyone/Default.aspx.

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved