program.cs

来自「数据访问框架.用于选择不同数据源的操作.包含了所有的ADO.NET的操作.不知道」· CS 代码 · 共 41 行

using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Text;

namespace ConsoleAbstract
{
    class Program
    {
        static void Main(string[] args)
        {
            DataBaseAbstract db = ConnectDatabase();
            int data =Convert.ToInt32( Console.ReadLine());
            DbParameter[] par=db.CreateParameter(data);
            string data1 = Console.ReadLine();
            string data2 = Console.ReadLine();
            par[0].ParameterName = "data1";
            par[0].Value = data1;
            par[1].ParameterName = "data2";
            par[1].Value = data2;
            string insert = "insert into sd values(@data1,@data2)";
            try
            {
                if (db.ExecuteNonQuery(System.Data.CommandType.Text, insert, par)==1)
                    Console.WriteLine("添加数据成功");
                else
                    Console.WriteLine("添加数据不成功");
            }
            catch (Exception ex)
            {
                throw ex;
            }
            db.Close();
        }
        static SqlDataBase ConnectDatabase()
        {
            return new SqlDataBase();
        }
    }
}