Question
Solution Preview
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
namespace E_Shopping{
public partial class About : System.Web.UI.Page
{
string ConnectedString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ButtonLogin_Click(object sender, EventArgs e)
{
// get username
string username = TextBoxLogin.Text;
// clear space
username.Trim();
string passwd = TextBoxPassword.Text;
string queryString = "select * from [user] where id = '" + username + "' and passwd = '" + passwd + "'";
DataTable dt = getQuery(ConnectedString, queryString);
if (dt.Rows.Count <= 0)
{
// no record matches
return;
}
Session["login"] = username;
}
private DataTable getQuery(string ConnStr, string query)
{
DataTable dt = new DataTable();
try
{
using (...