drawback.aspx.cs

小型物理试验管理系统Management system for small-scale physical experiments

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Drawback : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection myconnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        DBConnection conn = new DBConnection();
        string number = TextBox1.Text.ToString();
        string name = TextBox2.Text.ToString();
        string email = TextBox3.Text.ToString();
        string sql = "select * from yonghu where number ='" + number + "'and name='" + name + "'and email='" + email + "'";
        SqlDataReader rs = conn.ExecuteReader(sql);
        if (rs.Read())
        {
            string tag = rs["tag"].ToString();

            if (tag == "true")
            {
                Label6.Text = rs["pwd"].ToString();
            }
            else
            {
                Label6.Text = "不存在此用户!";
            }
        }
        else 
        {
            Label6.Text = "您输入的信息有误!";
        }
    }
}