数据库作业笔记之 SqlAdapter获取数据

SqlDataAdapter da = new SqlDataAdapter("select s_name as '名称', s_address as '地址',s_seatnum as '坐席数', s_functions as '功能' from Stadium",connectionstr);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridViewStadiumInfo.DataSource = ds.Tables[0];