主要分为三部分:
(1) 配置文件
(2)Program.cs
(3)SQLHelper.cs
//--------------------------------------1 配置文件-----------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<connectionStrings>
<add name="sql" connectionString="server=.;database=MySecondDB;uid=sa;pwd=520;"/>
</connectionStrings>
</configuration>
//--------------------------------------2 Program.cs---------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace _11SQLHelper
{
class Program
{
static void Main(string[] args)
{
// 对数据库的增删改查
// 创建数据库
//string createtable = "create table Test0806(id int not null, name nvarchar(10), pwd varchar(10))";
//int res = JKLibrary.SQLHelper.ExecuteNonQuery(createtable);
//Console.WriteLine(res);
// 插入数据