/// <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();
}
}
}