using MySql.Data.MySqlClient;
protected void btn_login_Click(
object sender, EventArgs e) {
string mySqlCon = ConfigurationManager.ConnectionStrings[
"MySqlCon"].ConnectionString; MySqlConnection myCon =
new MySqlConnection(mySqlCon);
try { myCon.Open(); MySqlCommand selSql =
new MySqlCommand(
"Select * From tt.table Where uname=@uname", myCon); selSql.Parameters.Add(
"@uname", MySqlDbType.VarChar, 32).Value =
this.txt_name.Text.Trim(); MySqlDataReader mydr = selSql.ExecuteReader();
while (mydr.Read()) {
if (mydr.HasRows) { Response.Write(
"<script type='text/javascript'>alert('" + mydr.GetString(0) +
"') </script>"); } } myCon.Close(); mydr.Close(); }
catch (Exception ex) { Response.Write(
"<mce:script type='text/javascript'>alert(" + ex.ToString() +
")</mce:script>"); } }