using System;
using System.Data;
using System.Data.SqlClient;
namespace StuMS
{
public class DBHelper
{
static string conStr ="server=.;uid=sa;pwd=123456;database=stuDB";//server为服务器,uid为数据库登入用户名,pwd为用户密码
//数据库的增,删,改
public static int Update(string sql)
{
int num = 0;
using (SqlConnection conn = new SqlConnection(conStr))
{
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
num = cmd.ExecuteNonQuery();
}
return num;
}
//数据库表格DataGridView的查找
public static DataTable Query(string sql)
{
DataTable table = new DataTable();
using(SqlConnection conn = new SqlConnection(conStr))
{
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
sda.Fill(table);
}
return table;
}
//非DataGrideView数据库的查询方法
public static object Selected(string sql)
{
object obj = null;
using(SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
obj=cmd.ExecuteScalar();
}
return obj;
}
}
C#Winfrom增删改查数据库的调用方法
最新推荐文章于 2021-12-07 07:24:28 发布