using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
namespace 库存管理系统
{
class DBHelf
{
//增删改
public int sqlDS(String sql)
{
string Conn = "server=.;integrated security=true;database=GoodsManager";
SqlConnection sqlconn = new SqlConnection(Conn);
SqlCommand sqlcomm = new SqlCommand(sql, sqlconn);
sqlconn.Open();
int i = sqlcomm.ExecuteNonQuery();
sqlconn.Close();
return i;
}
//查询
public DataTable sqlCha(string sql)
{
DataTable table = new DataTable();
string Conn = "server=.;integrated security=true;database=GoodsManager";
SqlConnection sqlconn = new SqlConnection(Conn);
SqlCommand sqlcomm = new SqlCommand(sql, sqlconn);
SqlDataAdapter da = new SqlDataAdapter(sqlcomm);
da.Fill(table);
return table;
}
}
}