myspace.myclass mystr = new myspace.myclass();
mystr.sql = "select uid as '用户名',pwd as '密码',sj as '创建时间' from yhb where uid<>'admin'";
mystr.table = "yhb";
DataSet ds = new DataSet();
ds = mystr.sqlbd(mystr.sql, mystr.table);
dataGrid1.DataSource = ds.Tables[mystr.table];
\\自定义类
public DataSet sqlbd(string sql,string table)
{
SqlDataAdapter myadp = new SqlDataAdapter(sql, mysql);