title: Modify sqldatasource selected data before binding?
body: <ol>
  <li><p>how can i access the my sqldatasource selected datasource for modification and adding for example new datacolumns  before binding??</p></li>
  <li><p>where is the best place to perform these modifications ?</p></li>
  <li><p>I guess SqlDataSource1_Selected is the right place, but i don't know how ?</p></li>
  </ol>
  
  <p>----------updated---------</p>
  
  <p>I found how to to access the selected data to show the total record but my questions is still not solved</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          DataTable dt = ((DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty)).Table;
          LabelTotal.Text = string.Format("{0} items found", dt.Rows.Count);
      }
  }
  </code></pre>