label textbox使用sqldatasource 绑定数据

sqldatasource返回dataset

DataView dvSql = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView drvSql in dvSql)
{
Label1.Text = drvSql["FirstName"].ToString();
}

sqldatasource返回datareader
 OleDbDataReader rdrSql =
                   (OleDbDataReader)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
while (rdrSql.Read())
{
Label2.Text = rdrSql["LastName"].ToString();

}
rdrSql.Close();