Modify sqldatasource selected data before binding?

Question

how can i access the my sqldatasource selected datasource for modification and adding for example new datacolumns before binding??
where is the best place to perform these modifications ?
I guess SqlDataSource1_Selected is the right place, but i don't know how ?

----------updated---------

I found how to to access the selected data to show the total record but my questions is still not solved

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);
    }
}

Note that doing this causes the SELECT command to run twice (in the usual databind and in your code to explicitly call it again) - which will be inefficient if the query is heavy. — Ryan
– Ryan, Commented Jul 21, 2018 at 13:47

Pankaj Agarwal · Accepted Answer · 2011-01-12 05:55:42Z

2

It will be better if you bind GridView using your custom code at .cs page rather than use SqlDataSource.

At .cs page you can perform your operation with datatable before bind gridview.

answered Jan 12, 2011 at 5:55

Pankaj Agarwal

11.4k12 gold badges46 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Iman Over a year ago

thanks , currently i am doing as you said in some more complicated pages and now i need that modifications for some simpler report pages that i use only sqldatasource and objectdatasources in a simple way

Collectives™ on Stack Overflow

Modify sqldatasource selected data before binding?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related