笔记8：winfrom连接数据库DBHelp

来源：互联网发布：人工智能可视化编辑：程序博客网时间：2024/05/19 03:42

 1 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 DBHelf12     {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 }

0 0