各位前辈,小弟是初学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;
sqlcommand连接并更新SQLServer数据库小实例
最新推荐文章于 2023-10-23 02:25:28 发布