每个人都。
I have a little issue with selecting value from the dropdown list. When user enters his/her credentials and selects the datasource name, they are all stored in session. When the user comes back to the login page later, I want him/her to see last selected datasource name. It works for the first time, but when I try to change the datasource name, it doesnt change but the value chosen before appears. Can you help me with this issue? Thanks!
违约。
public partial class _Default : System.Web.UI.Page
{
private dbConnection connection = new dbConnection();
private string[,] errorMessage =
{ {"Expired", "Unsuccessful", "Incorrect"},
{"Your Logon Session Has Expired", "Invalid Username or Password",
"Selected Data Source is not supported within this application"} };
protected void Page_Load(object sender, EventArgs e)
{
ddlDatabase.DataTextField = "Value";
ddlDatabase.DataValueField = "Key";
ddlDatabase.DataSource = dbList.GetDbList();
ddlDatabase.DataBind();
Response.Buffer = true;
if (Session["Error"] != null)
ErrorMessage();
if (Session["Datasource"] != null)
ddlDatabase.SelectedValue = Session["Datasource"].ToString();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string dataSource = ddlDatabase.SelectedValue;
string userID = txtUserID.Text;
string password = txtPassword.Text;
connection = new dbConnection(dataSource, userID, password);
if (connection.IsValid())
{
try
{
connection.GetConnection().Open();
Session["Username"] = userID;
Session["Password"] = password;
Session["Datasource"] = ddlDatabase.SelectedValue;
Response.Clear();
Response.Redirect("main.aspx", false);
}
catch (Exception ex)
{
lblSessionInfo.Text = ex.Message;
Session["Username"] = null;
Session["Password"] = null;
Session["Error"] = "Unsuccessful";
Response.Clear();
Response.Redirect("违约。");
}
}
else
{
Session["Username"] = null;
Session["Password"] = null;
Session["Datasource"] = null;
Session["Error"] = "Incorrect";
Response.Clear();
Response.Redirect(Request.Url.ToString(), true);
}
}
protected void ErrorMessage()
{
int length = errorMessage.Length / 2;
for (int i = 0; i < length; i++)
if (Session["Error"].ToString() == errorMessage[0, i])
lblSessionInfo.Text = errorMessage[1, i];
}
}
主编.aspx(记录仪)
public partial class main : System.Web.UI.Page
{
dbConnection connection = new dbConnection();
protected void Page_Load(object sender, EventArgs e)
{
Response.Buffer = true;
if (Session["Username"] == null)
{
Session["Error"] = "Expired";
Response.Clear();
Response.Redirect("违约。");
}
else
{
Session["Error"] = null;
}
Label1.Text = Session["Datasource"].ToString();
}
protected void btnLogout_Click(object sender, EventArgs e)
{
connection.GetConnection().Close();
Session["Username"] = null;
Session["Password"] = null;
Response.Clear();
Response.Redirect(Request.Url.ToString(), true);
}
}
dbList.cs
public class dbList
{
public static Dictionary<int, string> GetDbList()
{
//List<string> dataSources = new List<string>();
var dataSources = new Dictionary<int, string>();
RegistryKey reg = (Registry.LocalMachine).OpenSubKey("Software");
reg = reg.OpenSubKey("ODBC");
reg = reg.OpenSubKey("ODBC.INI");
reg = reg.OpenSubKey("ODBC Data Sources");
if (reg != null)
{
string[] items = reg.GetValueNames();
Array.Sort(items);
int i = 0;
foreach (string item in items)
{
dataSources.Add(i, item);
i++;
}
}
reg.Close();
return dataSources;
}
}
dbConnection.cs
public class dbConnection
{
private string[] dataSources = { "name1", "name2", "name3" };
public dbConnection() {}
public dbConnection(string dataSource, string userID, string password)
{
DataSource = dataSource;
UserID = userID;
Password = password;
}
public string DataSource { get; set; }
private string UserID { get; set; }
private string Password { get; set; }
public OracleConnection GetConnection()
{
OracleConnection connection = null;
string connectionString =
@"Data Source="+ DataSource +
";User ID=" + UserID +
";Password=" + Password +
";Unicode=True";
try
{
connection = new OracleConnection(connectionString);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
return connection;
}
public bool IsValid()
{
int trueCount = 0;
foreach (string dataSource in dataSources)
if (DataSource == dataSource) trueCount++;
if (trueCount > 0) return true;
else return false;
}
}