readerinforquery.cs

用C#与SQL2005写的一个简单的图书管理系统.主要功能:图书及学生信息的添加修改与删除 图书的借出与归还 图书信息的模糊查询.

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

namespace BooksM.InforQuery
{
    public partial class ReaderInforQuery : Form
    {
        public ReaderInforQuery()
        {
            InitializeComponent();
        }

        private void ReaderInforQuery_Load(object sender, EventArgs e)
        {
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select * from ReaderInfor where  "
                + "ReaderID like '"
                + textBox1.Text.ToString().Trim() + "%' and ReaderName like '%"
                + textBox2.Text.ToString().Trim() + "%' and ContactNum like '%"
                + textBox3.Text.ToString().Trim() + "%' and CONVERT(varchar(100),RegistDate,120)  like '%"
                + textBox4.Text.ToString().Trim() + "%'";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }
        }


    }
}