Retrieving the values from the list view SharePoint 2010 using object model

Question

I have a list (tick_gen) which has a view called "tick_dView" this view just has one row. How can I fetch the value of "Tick_id" column using SharePoint object model?

Answer 1

At first get a view, next create an SPQuery object using this view's query and then get your item.
Code will look like this one:

var view = list.Views["tick_dView"];
var query = new SPQuery();
query.Query = view.Query;
query.RowLimit = view.RowLimit;
var item = list.GetItems(query).Cast<SPListItem>().FirstOrDefault();
if(item != null)
{
   var tickId = item["Tick_id"];
}

You can also pass view directly into spquery constructor (and ommit 3 and 4th lines), but doing this you must be sure, that Tick_id field is present in the tick_dView. If not, you will need to specify additional view fields for spquery.