事先在窗体上加入
datagridview(如命名为
dg)
代码写在按钮单击事件中
string
upcmd
=
"select
......."
sqlconnection
conn
=
new
sqlconnection("连接字符串");
sqlcommand
cmd
=
new
sqlcommand(upcmd,
conn);
conn.open();
sqldatareader
reader
=
cmd.executereader();
datatable
dt
=
new
datatable("user");
dt.load(reader);
dg.datasource
=
dt;
reader.close();
conn.close();