资源简介


资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;

/// 
/// 数据库帮助类
/// 

public class DBHelper
{
    private static string ConnStr = “server=.;uid=sa;pwd=sa;database=TicketSystemDB“;
    /// 
    /// 执行添加、删除、修改的方法
    /// 

    /// 
    /// 
    /// 
    public static int ExecuteNonQuery(string sql params SqlParameter[] paras)
    {

        using (SqlConnection conn = new SqlConnection(ConnStr))
        {
            //打开数据库连接
            conn.Open();
            //创建执行脚本的对象
            SqlCommand command = new SqlCommand(sql conn);
      

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2019-08-29 10:09  TicketSystem\
     目录           0  2019-08-29 10:09  TicketSystem\.vs\
     目录           0  2019-08-29 10:09  TicketSystem\.vs\TicketSystem\
     目录           0  2019-08-29 10:10  TicketSystem\.vs\TicketSystem\v15\
     文件       24576  2019-08-30 11:21  TicketSystem\.vs\TicketSystem\v15\.suo
     目录           0  2019-08-29 10:10  TicketSystem\.vs\TicketSystem\v15\Server\
     目录           0  2019-08-30 09:54  TicketSystem\.vs\TicketSystem\v15\Server\sqlite3\
     文件           0  2019-08-29 10:10  TicketSystem\.vs\TicketSystem\v15\Server\sqlite3\db.lock
     文件      585728  2019-08-30 10:36  TicketSystem\.vs\TicketSystem\v15\Server\sqlite3\storage.ide
     文件       32768  2019-08-30 09:54  TicketSystem\.vs\TicketSystem\v15\Server\sqlite3\storage.ide-shm
     文件     4120032  2019-08-30 11:21  TicketSystem\.vs\TicketSystem\v15\Server\sqlite3\storage.ide-wal
     目录           0  2019-08-30 10:53  TicketSystem\TicketSystem\
     文件        1134  2019-08-29 10:09  TicketSystem\TicketSystem.sln
     文件         187  2019-08-29 10:09  TicketSystem\TicketSystem\App.config
     目录           0  2019-08-29 10:10  TicketSystem\TicketSystem\bin\
     目录           0  2019-08-29 10:25  TicketSystem\TicketSystem\bin\Debug\
     文件       20992  2019-08-30 10:51  TicketSystem\TicketSystem\bin\Debug\TicketSystem.exe
     文件         187  2019-08-29 10:09  TicketSystem\TicketSystem\bin\Debug\TicketSystem.exe.config
     文件       46592  2019-08-30 10:51  TicketSystem\TicketSystem\bin\Debug\TicketSystem.pdb
     目录           0  2019-08-29 10:10  TicketSystem\TicketSystem\bin\Release\
     文件        3618  2019-08-29 10:46  TicketSystem\TicketSystem\DBHelper.cs
     文件        3631  2019-08-30 10:53  TicketSystem\TicketSystem\MainForm.cs
     文件       12015  2019-08-30 10:27  TicketSystem\TicketSystem\MainForm.Designer.cs
     文件        7321  2019-08-30 10:27  TicketSystem\TicketSystem\MainForm.resx
     目录           0  2019-08-29 10:09  TicketSystem\TicketSystem\obj\
     目录           0  2019-08-30 10:27  TicketSystem\TicketSystem\obj\Debug\
     文件        1431  2019-08-30 09:58  TicketSystem\TicketSystem\obj\Debug\DesignTimeResolveAssemblyReferences.cache
     文件        7192  2019-08-30 10:10  TicketSystem\TicketSystem\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     文件           0  2019-08-29 10:09  TicketSystem\TicketSystem\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
     文件           0  2019-08-29 10:09  TicketSystem\TicketSystem\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
     文件           0  2019-08-29 10:09  TicketSystem\TicketSystem\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
............此处省略22个文件信息

评论

共有 条评论