在VS2019里面 C# 和SqlSerer的勾兑

1)WIN10  64 专业版系统,Sqlserver2008 ,全部安装好

2)通过SQL Server Management Studio  新建一个数据库 ,然后在库里面新建一个表

3)在VS2019里面,添加Sql Server

 4)打开属性

 

 

就可以找到链接字符串

 

 以上完成准备工作,下面就可以进入代码环节

(Data Source=DESKTOP-1GHN2NO;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False)(链接字符,各有区别,不必在意)

 

https://www.cnblogs.com/vaevvaev/p/6898891.html

 

5)在VS2019 里面新建C#的窗口程序

命名空间如下:

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

 

缺啥 补啥

 

 

6)SqlConnection myconnection;//定义一个数据库连接对象

 

 

7)打开数据, 就是一个按钮的点击事件响应函数

private void button1_Click(object sender, EventArgs e)
{
try

{

myconnection = new SqlConnection("Data Source=DESKTOP-1GHN2NO;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite");

myconnection.Open(); //打开数据库

label1.Text = "数据库连接成功!";

}

catch (Exception ee)

{

MessageBox.Show("数据库连接失败!" + ee.ToString());

}
}

 

8)插入数据

private void button_insert_Click(object sender, EventArgs e)
{
try
{
//String Gsz_Time = DateTime.Now.Hour.ToString()+'_'+ DateTime.Now.Minute.ToString()+ '_'+ DateTime.Now.Second.ToString();

string GSZ_ID = "7";
string GSZ_Time = DateTime.Now.Hour.ToString() + '_' + DateTime.Now.Minute.ToString() + '_' + DateTime.Now.Second.ToString();
string GSZ_ACC = "7";
string insertCommand = "insert into Table_Gsz (ID,Time,Data_ACC) values('"+ GSZ_ID + "','"+GSZ_Time+"','"+GSZ_ACC+"')" ;
SqlCommand command = new SqlCommand(insertCommand, myconnection);
command.ExecuteNonQuery();

}
catch (Exception ee)
{
MessageBox.Show("插入数据库!" + ee.ToString());

}

}

 

时间相关:https://www.cnblogs.com/huanglong/archive/2012/03/26/2417487.html

 

9)查询

 

private void button3_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
string sql = "select * from Table_Gsz";
SqlDataAdapter adp = new SqlDataAdapter(sql, myconnection);
adp.Fill(ds);
}
catch (Exception ee)
{
MessageBox.Show("查询数据库!" + ee.ToString());
}

 

 

 

 

 10)关闭

private void button2_Click(object sender, EventArgs e)
{
try
{
myconnection.Close();
myconnection.Dispose();
}
catch (Exception ee)
{
MessageBox.Show("关闭数据库连接!" + ee.ToString());
}


}

posted @ 2021-06-16 10:02  wenluderen  阅读(184)  评论(1编辑  收藏  举报