Matt,
I did try and verify that it identified anything other than my permissions.
Below is the code to my Main.aspx page and my Main.aspx.cs page. It is pretty simple logic that runs fine when the Main.aspx page loads on the production server but won't recognize changes on the test server - the permissions seem to default to my own. I checked to be sure I wasn't accidentally passing local Client controls when I published from my desktop to the test server and I wasn't:
Page Name is Main.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Main.aspx.cs" Inherits="MyWebPage.WebForm2"%>
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
This is on the Main.aspx.cs page:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.WebControls;
using System.Security.Principal;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Configuration;
namespace MyWebPage.Main
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var username = User.Identity.Name;
SqlConnection MyConnection = new SqlConnection("server=ServerName\\sql2008;database=DatabaseName;Trusted_Connection=True;");
SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SP_Name", MyConnection);
MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MyDataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar, 40));
MyDataAdapter.SelectCommand.Parameters["@username"].Value = (username);
MyDataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@userrole", SqlDbType.VarChar, 40));
MyDataAdapter.SelectCommand.Parameters["@userrole"].Direction = ParameterDirection.Output;
DataSet DS = new DataSet();
MyConnection.Open();
MyDataAdapter.Fill(DS, "UsersRole");
Session.Add("Role", DS);
string userrole = null;
userrole = MyDataAdapter.SelectCommand.Parameters[1].Value.ToString();
string role1 = "Admin";
string role2 = "User";
string role3 = "Managers";
string role4 = "PowerUser";
//TextBox1.Text = MyDataAdapter.SelectCommand.Parameters[1].Value.ToString();
//Label1.Text = MyDataAdapter.SelectCommand.Parameters[1].Value.ToString();
if (userrole == role1)
{
Server.Transfer("Main.aspx", true);
}
else if (userrole == role2)
{
Server.Transfer("UserMainPage.aspx", true);
}
else if (userrole == role3)
{
Server.Transfer("ManagerMainPage.aspx", true);
}
else if (userrole == role4)
{
Server.Transfer("PowerUserMainPage.aspx", true);
}
else
{
Server.Transfer("NewUserMainPage.aspx", true);
}
MyConnection.Close();
}
}
}
}