非断开式访问

最新推荐文章于 2024-07-13 18:10:19 发布

⁡ 筱泠Sinorei

最新推荐文章于 2024-07-13 18:10:19 发布

阅读量40

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/qq_55950968/article/details/134687270

版权

蓝奏云：https://wwhe.lanzouq.com/b058nxsmf 密码:yousa

图例

所对应的控件名称

控件内代码（.cs文件中）

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.Configuration;
using System.Data.SqlClient;

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

   
        }
            
        private int current = 1;
        string conStr = "Data Source=A301-20\\SQLEXPRESS;Integrated Security=True;database=studentmanage";
  
    private void label1_Click(object sender, EventArgs e)
        {

        }

        private void btnPrevious_Click(object sender, EventArgs e)
        {
            current--;
            ShowCurrentStudent();

        }
        private void ShowCurrentStudent() {
            string sql = "select * from studentInfo where num="+current;
            SqlConnection con = new SqlConnection(conStr);
            con.Open();
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
                txtNum.Text = reader.GetInt32(0).ToString();
                txtName.Text = reader.GetString(1);
                string sex = reader.GetInt32(0).ToString();
                if (sex == "0")
                {
                    rdbMale.Checked = true;
                }
                else {
                    rdbFemale.Checked = true;
                }
            
            
            }

            reader.Close();
            con.Close();
        
        
        
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ShowCurrentStudent();
        }

        private void btnNext_Click(object sender, EventArgs e)
        {
            current++;
            ShowCurrentStudent();
        }

        private void btnConnect_Click(object sender, EventArgs e)
        {
            string conStr = "Data Source=A301-20\\SQLEXPRESS;Integrated Security=True;database=studentmanage";
            SqlConnection con = new SqlConnection(conStr);
            con.Open();
            MessageBox.Show("连接成功");
            con.Close();

        }

        private void btnInsert_Click(object sender, EventArgs e)
        {
            string sex = "0";
            if (rdbFemale.Checked)
            { sex = "1"; }

            SqlConnection con = new SqlConnection(conStr);
            SqlCommand cmd = new SqlCommand("insert into studentInfo(num,namem,sex) values(@num,@namem,@sex)", con);
            cmd.Parameters.AddWithValue("@num", null);
            cmd.Parameters.AddWithValue("@name", txtName.Text);
            cmd.Parameters.AddWithValue("@num", sex);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("成功增加一条数据！");
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(conStr);
            SqlCommand cmd = new SqlCommand("delete from studentInfo where num=@num", con);
            cmd.Parameters.AddWithValue("@num", Convert.ToInt32(txtNum.Text));
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("成功删除一条数据！");
        }
        
    }
}