query_stuinfo.cs

利用vs2008+sql2000开发的小型学生信息系统

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 StudentInfoMS
{
    public partial class query_stuinfo : Form
    {
        public query_stuinfo()
        {
            InitializeComponent();
        }

        private void btn_go_Click(object sender, EventArgs e)
        {
            string connstr = "Data Source=localhost;Initial Catalog=mystuInfoDB;Integrated Security= true;";
            DataSet studataset = new DataSet();
            SqlConnection mysqlconnection = new SqlConnection(connstr);
            SqlDataAdapter sda;
            string para = txt_info.Text.ToString();
            string cmdstr = null;
            if (para.Equals("") == false)//部分查询信息输入的情况下
            {
                if (rb_sid.Checked)
                {
                    cmdstr = "getstuInfoBySid " + para;//调用存储过程getstuInfoBySid

                }
                else if (rb_sname.Checked)
                {
                    cmdstr = "getstuInfoBySname " + para;
                }
                else if (rb_jiguan.Checked)
                {
                    cmdstr = "getstuInfoByJiguan " + para;
                }
                else if (rb_class.Checked)
                {
                    cmdstr = "getstuInfoByClass " + para;
                }
                else if (rb_proname.Checked)
                {
                    cmdstr = "getstuInfoByProname " + para;
                }
            }
            else//部分查询信息未输入 则调用getAllStuInfo返回所有学生信息
            {
                cmdstr = "getAllStuInfo";
            }
            try
            {
                 sda = new SqlDataAdapter(cmdstr, mysqlconnection);
                 sda.Fill(studataset, "stuinfo");
                 dataGridView1.DataSource = studataset.Tables["stuinfo"];
             }
             catch (Exception ex)
             {
                  MessageBox.Show("请检查您的输入或者数据库连接情况！","注意",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
             }
             finally
             {
                 mysqlconnection.Close();
             }

            }

        
    }
}