读写SqlServer数据库 - (第四讲)
视频讲解如下：
CSDN源码下载
https://download.csdn.net/download/gs1069405343/18335273
网盘下载地址，提取码：1ctc
https://pan.baidu.com/s/1lMKPsrUh4hC_VwHaFRIZOQ
这里给大家讲解一下在winform环境下如何读写SqlServer数据库的。
这里需要安装如下两个NuGet程序包
Microsoft.EntityFrameworkCore 3.1.10
Microsoft.EntityFrameworkCore.SqlServer 3.1.10
安装完之后需要将Microsoft.Data.SqlClient 更新成2.1.2版本
界面设计如下
using mssql.mssql;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
namespace mssql
{
public partial class Form1 : Form
{
MyDbContext MyDb = new MyDbContext();
public Form1()
{
InitializeComponent();
InitMsSql();
}
/// <summary>
/// 初始化Mysql
/// </summary>
private void InitMsSql()
{
MyDb.Database.EnsureCreated();
}
/// <summary>
/// 读取
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
List<data> datas = MyDb.Tb_data.ToList();
dataGridView1.Rows.Clear();
foreach (data d in datas)
{
int addr = 0;
int index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[addr++].Value = d.id;
dataGridView1.Rows[index].Cells[addr++].Value = d.text;
}
}
/// <summary>
/// 写入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string text = textBox1.Text;
data d = new data()
{
text = text
};
MyDb.Tb_data.Add(d);
MyDb.SaveChanges();
}
}
}
// 如何操作读取存储过程数据
// OK
// @BCTYPE 班次
// @BDATE 开始时间
// @EDATE 结束时间
//string sql3 = string.Format(" EXEC [dbo].[Pr_QdScDaySelect] " +
// "@BCTYPE=N'{0}',@BDATE=N'{1}',@EDATE=N'{2}'"
// , "全班", "2020-12-05", "2020-12-06");
//List<QdScDaySelect> Pr_QdScDaySelect_t = Res.MyDB.Pr_QdScDaySelect.FromSql(sql3).ToList();using Microsoft.EntityFrameworkCore;
namespace mssql.mssql
{
public class MyDbContext : DbContext
{
public DbSet<data> Tb_data { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
string str = $"Server=127.0.0.1;Database=test; User=root;Password=123456;Trusted_Connection=True;";
optionsBuilder.UseSqlServer(str);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
}
}namespace mssql.mssql
{
public class data
{
public int id { get; set; }
public string text { get; set; }
}
}
