Learn from scratch - Basics Page 4/7

private void btnLogin_Click(object sender, e)
{
// Check the correctness of the input first
if ( == || () == "")
{
("＜script language=javascript>alert("Account cannot be empty")＜/script>");
return;
}
if ( == || () == "")
{
("＜script language=javascript>alert("No password entered")＜/script>");
return;
}

string strConnection = ["SqlDatabase1"];
string sqlMember = "SELECT MemberName ,[Password] FROM Member "
+ " WHERE MemberName = "" + () + """
+ " AND [Password] = "" + () + """;

// Connect to the SqlServer database
SqlConnection conn = new SqlConnection(strConnection);
// Create SqlCommand
SqlCommand cmd = ();
= sqlMember;
();
// Create DataReader
SqlDataReader dr = ();

// Determine whether DataReader is an empty record
if ()
{
("＜script language=javascript＞alert("" + + "Welcome!")＜/script＞");
}
else
{
("＜script language=javascript>alert("This member cannot be found, or the password is incorrect.")＜/script>");
}

// Don't forget to close DataReader
();

();
}