sqlcommand连接并更新SQLServer数据库小实例

各位前辈,小弟是初学C#不久 写了一个用SqlCommand联接和更新数据库的例子.和大家交流一下看看那些地方需要优化.

引入的STU类:
using System;
using System.Collections.Generic;
using System.Text;

namespace CLA_STU
{
    public class STU
    {
        private Guid STU_ID;
        public Guid M_STU_ID
        {
            get {
                return STU_ID;
            }
            set {
                STU_ID = value;
            }
        }
        private string STU_NAME;
        public string M_STU_NAME
        {
            get {
                return STU_NAME;
            }
            set {
                STU_NAME = value;
            }
        }
        private Guid CLA_ID;
        public Guid M_CLA_ID
        {
            get {
                return CLA_ID;
            }
            set {
                CLA_ID = value;
            }
        }
        private string AIHAO;
        public string M_AIHAO
        {
            get {
                return AIHAO;
            }
            set {
                AIHAO = value;
            }
        }
        private string GENDER;
        public string M_GENDER
        {
            get {
                return GENDER;
            }
            set {
                GENDER = value;
            }
        }
    }
}

Form1中的内容:
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;
using CLA_STU;                   
using CLASS_Object;

namespace STUDENT_Management
{
    public partial class NAME : Form
   
    {
      
        public string SHOU_NAME = "";                 //声明姓名
        public string SHOU_comboBox = "";             //声明班级
        public Guid   G_SHOU_comboBox;
        public Guid   G_1;                            //用于存储班级代号(Guid类型)
        public Guid   G_2;
        public Guid   G_3;
        public string SHOU_GENDER = "";               //声明性别
        public string SHOU_LIKE = "";                 //声明爱好      
        public string Y_SHOU_ID_String = "";
        public Guid   Y_SHOU_ID;                      //使用删除功能和更新功能是用到的Guiid类型的Stu_id主键;
        //联接StudentM数据库方法
        public SqlConnection CONN_Method()
        {
            string connString = @"Data Source=(local)/SQLExpress;Initial Catalog=StudentM;Integrated Security=SSPI;";
            SqlConnection conn = new SqlConnection(connString);
            return conn;
        }
        //清空所用选项和输入框方法   
        public void Box_void()
        {   //姓名
            this.XM.Text = "";
            //班级
            this.comboBoxCLASS.Text = "";
            //性别
            this.NV.Checked = false;
            this.NAN.Checked = false;
            //爱好
            this.YUNDONG.Checked = false;
            this.YOUXI.Checked = false;
            this.DUSHU.Checked = false;
           

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值