frmbookmanager.cs

一个图书馆管理系统

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 BookManage
{
    public partial class frmbookManager : Form
    {
        private SqlConnection objSqlConnection;
        private SqlDataAdapter objSqlDataAdapter;
        private DataSet objDataSet;
        int i;
        int h;
        public frmbookManager()
        {
            InitializeComponent();
        }

        private void frmbookManager_Load(object sender, EventArgs e)
        {
            objSqlConnection = new SqlConnection("server=(local);database=Book;Integrated Security=SSPI;");
            objDataSet = new DataSet();
            objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo", objSqlConnection);
            objSqlDataAdapter.Fill(objDataSet, "bookInfo");
            this.txtbiao.Text = "bookInfo";
        }

        private void btnOPen_Click(object sender, EventArgs e)
        {
            if (this.txtbiao.Text.Equals(""))
            {
                MessageBox.Show("请输入你要打开的表!");
            }
            else
            {
                if (this.txtbiao.Text.Equals("bookInfo"))
                {
                    dbgname.DataSource = objDataSet.Tables[0].DefaultView;
                }
                else
                {
                    MessageBox.Show("该表不存在!");
                    txtbiao.Text = "";
                    txtbiao.Focus();
                }
            }
        }

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

        private void btnguanli_Click(object sender, EventArgs e)
        {
            i = dbgname.CurrentRowIndex;
            frmguanli obja = new frmguanli(i);
            obja.Show();
        }

        private void btnsousuo_Click(object sender, EventArgs e)
        {
            frmsousuo objs = new frmsousuo();
            objs.Show();
        }

        private void btnfengmian_Click(object sender, EventArgs e)
        {
            h = dbgname.CurrentRowIndex;
            frmfengmian objm = new frmfengmian(h);
            objm.Show();
        }
    }
}