protected void AddUser()
{
string username = Username.Text.Trim();
string password = Password.Text.Trim();
string sql1 = String.Format("insert into [user_info](username, password) values('{0}', '{1}')", username, password);
//string sql2 = "select * from [user_info] where username = @username and password = @password";
//string sql3 = "select * from [user_info] where username = @username and password = @password";
//string tmp = String.Format("select count([user_id]) from [user_info] where [username] = '{0}'", username);
string all = "select * from [user_info]";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@username", Username.Text.Trim()),
new SqlParameter("@password", Password.Text.Trim())
};
try
{
Connector msConn = ConnecterFactory.GetConnector("TestDB");
msConn.ManageDataOffMode("insert", "user_info", username, password);
DataSet ds = msConn.GetDataSet(all);
ViewData1.DataSource = ds;
ViewData1.DataBind(); // this case, has no bug. why?
}
catch (Exception ex)
{
prompt.InnerText = ex.Message;
}
}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
string username = Username.Text.Trim();
string password = Password.Text.Trim();
string sql1 = String.Format("insert into [user_info](username, password) values('{0}', '{1}')", username, password);
string all = "select * from [user_info]";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@username", Username.Text.Trim()),
new SqlParameter("@password", Password.Text.Trim())
};
try
{
Connector msConn = ConnecterFactory.GetConnector("TestDB");
msConn.ManageDataOffMode("update", "user_info", 7, username, password);
DataSet ds = msConn.GetDataSet(all);
ViewData1.DataSource = ds;
ViewData1.DataBind(); // this case, has no bug. why?
}
catch (Exception ex)
{
prompt.InnerText = ex.Message;
}
}
protected void DeleteBtn_Click(object sender, EventArgs e)
{
string username = Username.Text.Trim();
string password = Password.Text.Trim();
string all = "select * from [user_info]";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@username", Username.Text.Trim()),
new SqlParameter("@password", Password.Text.Trim())
};
try
{
Connector msConn = ConnecterFactory.GetConnector("TestDB");
msConn.ManageDataOffMode("delete", "user_info", username, password);
DataSet ds = msConn.GetDataSet(all);
ViewData1.DataSource = ds;
ViewData1.DataBind();
}
catch (Exception ex)
{
prompt.InnerText = ex.Message;
}
}
protected void SignInBtn_Click(object sender, EventArgs e)
{
mssql.CreateConnection();
try
{
// 连接模式访问
// mssql.OpenDb();
string username = Username.Text.Trim();
string password = Password.Text.Trim();
string[] arr = { "@username", "@password", "10", "10", username, password };
string[] arr1 = { username, password, "10", "10" };
ViewData1.DataSource = mssql.SelectData("select * from user_info where username = @username and password = @password", arr1);
ViewData1.DataBind();
mssql.CloseReader(); // 关闭reader
//ViewData2.DataSource = mssql.SelectData("*", "user_info", arr);
//ViewData2.DataBind();
//mssql.CloseReader(); // 关闭reader
mssql.CloseDb();
}
catch (Exception ex)
{
prompt.InnerText = ex.Message;
}
}