C#数据库连接类

最新推荐文章于 2019-09-29 23:54:16 发布

vileboy

最新推荐文章于 2019-09-29 23:54:16 发布

阅读量814

点赞数

文章标签：数据库 c# dataset exception datagrid sql

本文链接：https://blog.csdn.net/vileboy/article/details/1543234

版权

/// <summary>
/// dataset ds =new dataset();
/// string sql="select * from [user]";
/// ds=dodatabase.getdataset(sql);
/// datagrid1.datasource=ds.tables[0].defaultview;
///以上四行为用02wangluo数据库中user表来填充dataset后绑定到datagrid1
///这是调用的getdataset方法-->此方法主要面对的是查(select)
/// </summary>
public class AccessDB
{
public AccessDB()
{
//
// todo: 在此处添加构造函数逻辑
//
}
public static DataSet getdataset(string sql)
{
  SqlConnection conn=new SqlConnection();
  DataSet ds=new DataSet();
  try
  {
  conn=new SqlConnection("server=130.199.100.160;uid=scdacf;pwd=scdacfhrsrs;database=hrs_acf");
  SqlDataAdapter sda=new SqlDataAdapter(sql,conn);
  sda.Fill(ds);
  return ds;
  }
  catch(Exception ex)
  {
  throw(ex);
  }
  finally
  {
  conn.Close();
  }
}
public static int executesql(string sql)
{
  SqlConnection conn=new SqlConnection();
  try
  {
  conn=new SqlConnection("server=130.199.100.160;uid=scdacf;pwd=scdacfhrsrs;database=hrs_acf");
  SqlCommand sqlcmd =new SqlCommand(sql,conn);
  conn.Open();
  return sqlcmd.ExecuteNonQuery();
  }
  catch(Exception ex)
  {
  throw ex;
  }
  finally
  {
  conn.Close();
  }
  }
}