personalinfoquery.cs

这是一个图书馆管理用的简化系统

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

namespace BMS
{
    public partial class PersonalInfoQuery : Form
    {
        public PersonalInfoQuery()
        {
            InitializeComponent();
        }

        private void PersonalInfomag_Load(object sender, EventArgs e)
        {
            
            string selectstr = "select readerid as 读者编号,readername as 姓名,readersex as 性别,readxi as 系别,readerbanji as 班级,readerphone as 联系电话,Readerdegree as 身份证号,addpeople as 添加人,addtime as 添加时间 from Reader where readerid='"+Value.CurrentLoger1+"'";
            DataSet ds = new DataSet();
            ds = Operator.SelectSql(selectstr);
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            string sele = "select Readerid as 读者编号,Readername as 姓名,Bookid as 图书编号,Bookname as 图书名称,Borrowtime as 借书时间,LimitReturntime as 限还时间,Returntime as 还书时间,Money as 罚款,IsReturn as 是否还书,Operater as 操作员 from BRinf where Readerid='"+Value.CurrentLoger1+"'";
            DataSet DS = new DataSet();
            DS = Operator.SelectSql(sele);
            this.dataGridView2.DataSource = DS.Tables[0].DefaultView;

        }

    }
}