笔记8：winfrom连接数据库DBHelp
时间：2021-07-01 10:21:17
帮助过：2人阅读
using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Data.Sql;
6 using System.Data.SqlClient;
7 using System.Data;
8
9 namespace 库存管理系统
10 {
11 class DBHelf
12 {
13 //增删改
14 public int sqlDS(String sql)
15 {
16 string Conn =
"server=.;integrated security=true;database=GoodsManager";
17 SqlConnection sqlconn =
new SqlConnection(Conn);
18 SqlCommand sqlcomm =
new SqlCommand(sql, sqlconn);
19
20 sqlconn.Open();
21 int i =
sqlcomm.ExecuteNonQuery();
22 sqlconn.Close();
23 return i;
24 }
25 //查询
26 public DataTable sqlCha(
string sql)
27 {
28 DataTable table =
new DataTable();
29 string Conn =
"server=.;integrated security=true;database=GoodsManager";
30 SqlConnection sqlconn =
new SqlConnection(Conn);
31 SqlCommand sqlcomm =
new SqlCommand(sql, sqlconn);
32
33 SqlDataAdapter da =
new SqlDataAdapter(sqlcomm);
34 da.Fill(table);
35 return table;
36 }
37 }
38 }
笔记8：winfrom连接数据库DBHelp
标签：
