取得SqlDataSource某欄的資料

  • 5531
  • 0
  • C#
  • 2013-09-25

取得SqlDataSource某欄的資料

DataView dvSql = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
        DataRow drvSql = dvSql[0].Row;
        lblCond.Text = "查詢年度:" + txtDATA_YEAR.Text + ",查詢分行:" + drvSql["BRNO"].ToString() + ",查詢日期:" + DateTime.Now.ToString("yyyy/MM/dd");