登录查询学生信息

     学生信息的登录查询涉及到数据库的连接和调用数据库中的数据

 

1.连接数据库,并且向数据库发送数据，接收返回的数据

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

namespace StudentRegister
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //设定下拉列表当前选定想的索引为0，即第一个
            this.cmbAward.SelectedIndex = 0;
            this.cmbClass.SelectedIndex = 0;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            #region 获取用户输入
            string Id = this.txbId.Text;//获取学号
            string name = this.txbName.Text;//获取姓名
            //获取性别
            string gender = "";
            if (radioMan.Checked)
            {
                gender = radioMan.Text;
            }
            if (radioWoman.Checked == true)
            {
                gender = radioWoman.Text;
            }
            //获取手机
            string mobile = this.txbMobile.Text;
            //获取地址
            string address = this.txbAddress.Text;
            //获取高考成绩
            string grade = this.txbGrade.Text;
            //获取奖品
            string award = this.cmbAward.Text;
            //获取系别
            string stu_class = this.cmbClass.Text;
            #endregion

            #region 向数据库插入数据
            string sqlserstr = "Data Source=PC-20130723IUDE;Initial Catalog=MyTest;User ID=sa;Password=yhb@163";
            SqlConnection conn = new SqlConnection(sqlserstr);
            conn.Open();   

            //连接数据库
           

            //SqlCommand的CommandText存储的是向数据库发送的sql命令
            SqlCommand cmd = new SqlCommand();
            //将命令对象与连接对象进行关联，命令对象才知道向哪台服务器，哪个数据库发送sql命令
            cmd.Connection = conn;
            cmd.CommandText = "insert into T_StudentInfo(Stu_Id,Stu_Name,Stu_Mobile,Stu_Address,Stu_Gender,Stu_Class,Stu_Grade,Stu_Award) values(@id,@name,@mobile,@address,@gender,@class,@grade,@award)";
            #region 参数替换
            cmd.Parameters.AddWithValue("@id", Id);
            cmd.Parameters.AddWithValue("@name", name);
            cmd.Parameters.AddWithValue("@mobile", mobile);
            cmd.Parameters.AddWithValue("@address", address);
            cmd.Parameters.AddWithValue("@gender", gender);
            cmd.Parameters.AddWithValue("@class", stu_class);
            cmd.Parameters.AddWithValue("@grade", grade);
            cmd.Parameters.AddWithValue("@award", award);
            #endregion

            //ExecuteNonQuery方法用来向数据库发送sql命令
            cmd.ExecuteNonQuery();
            MessageBox.Show("注册成功");
            #endregion

        }
    }
}

2.查询数据库中的数据  ，

        private void btnSelect_Click(object sender, EventArgs e)
        {
            string sqlserver = "Data Source=SXVPTNJT9Q07YYP;Initial Catalog=student;User ID=sa;Password=abcdef";
            SqlConnection conn = new SqlConnection(sqlserver);
            conn.Open();       // 同样必须先连接数据库

            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from student2 where StudentName=@studentname or Mobile=@mobile";
            cmd.Parameters.AddWithValue("@studentname",txtPName.Text);
            cmd.Parameters.AddWithValue("@mobile",txtPName.Text);

            SqlDataAdapter adar = new SqlDataAdapter(cmd);
            DataTable data = new DataTable();
            adar.Fill(data);

            conn.Close();
            conn.Dispose();
            cmd.Dispose();

            this.dataGridView1.DataSource = data;

  数据库中表 的建立

create table Table_name

(

create table student2
(
Id varchar(32) primary key,    //  字段名 数据类型 ,
StudentName varchar(32) not null,
sex char(4),
Mobile varchar(32),
SAddress varchar(32),
XiBie varchar(32),
Prizes varchar(32),
Score varchar(8),
)

)