ObjectDataSource in c# Code Behind?

Question

Is it possible to read the data provided by an ObjectDataSource created in code behind? Take the following for instance:

ObjectDataSource myObjectDataSource= new ObjectDataSource();
myObjectDataSource.SelectParameters.Add(new SessionParameter("createdDate", TypeCode.String, "FilterCreated"));

How could you then get the rows from this? For example in a Dataset you would do something like:

foreach (DataRow dr in myDataset.Tables[0].Rows) {
     string abc = dr["myColumn"];
}

Not sure if this helps. But there is a method named "Select()" which returns an IEnumerable which you can use and iterate the collection. — Parthasarathy
– Parthasarathy, Commented Feb 12, 2015 at 11:07

Pranay Rana · Accepted Answer · 2015-02-12 11:15:20Z

3

you can try like this , convert objectdatasource to dataset and than read that

private DataSet ConvertObjectSourceToDataSet(ObjectDataSource ods)
{
   var ds = new DataSet();
   var dv = (DataView)ods.Select();
   if (dv != null && dv.Count > 0)
   {
     var dt = dv.ToTable();
     ds.Tables.Add(dt);
   }
  return ds;
}

Code source : http://www.aspdotnet-suresh.com/2010/09/how-to-bind-dataset-with.html

edited Feb 12, 2015 at 11:15

answered Feb 12, 2015 at 11:06

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

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

1 Comment

Apqu Over a year ago

I have to say that you are awesome! Superb answer and one I will definitely be reusing in the future I'm sure +1 :-)

Collectives™ on Stack Overflow

ObjectDataSource in c# Code Behind?

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