usersearchform.cs

aTm机 daima认真阅读您的文件包然后写出其具体功能(至少要20个字)。尽量不要让站长把时间都花费在为您修正说明上。压缩包解压时不能有密码。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Bank
{
    public partial class UserSearchform : Form
    {

        string money = "";
        string id = "";
        public UserSearchform()
        {
            InitializeComponent();
        }

        private void UserSearchbtnEnter_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void UserSearchform_Load(object sender, EventArgs e)
        {
            NewLook();
        }

        public void NewLook()
        {
            string sql = "select * from users";
            try
            {
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                DBHelper.connection.Close();
                DBHelper.connection.Open();
                SqlDataReader dataReader = command.ExecuteReader();
                Mainform mainform = new Mainform();
                /*
                 验证部分
                */
                if (!dataReader.HasRows)
                {
                    MessageBox.Show("对不起，没有任何用户，请先创建用户", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
                }
                while (dataReader.Read())
                {
                    id = (string)dataReader["id"];
                    if (HelperSend.LoginID == id)
                    {
                        money = dataReader["money"].ToString();
                        UserSearchtxtLast.Text = money;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据库出错了！\n\n" + ex, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
            }
            finally
            {
                DBHelper.connection.Close();
            }
        }
    }
}