database.cs

来自「这是一个C#开发的手机管理系统」· CS 代码 · 共 35 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WindowsApplication2
{
    class Database
    {
        SqlConnection conn;
        SqlCommand sc;
        SqlDataAdapter sda;
        string url = "server=.;database=手机销售管理系统;uid=sa";
        DataSet ds;  

        public DataSet query(string sql,string tablename)
        {
            ds = new DataSet();
            conn = new SqlConnection(url);
            conn.Open();
            sda = new SqlDataAdapter(sql, conn);
            sda.Fill(ds, tablename);
            return ds;
        }

        public void insert(string sql)
        {
            conn = new SqlConnection(url);
            conn.Open();
            sc = new SqlCommand(sql, conn);
            sc.ExecuteNonQuery();
        }
    }
}