return a list view in visual webpart

Question

In have the following code which returns a list and binds it to my repeater.

Dim Partnership As SPList = web.Lists("PartnersMedia")
rptPartnership.DataSource = Partnership.Items.GetDataTable()
rptPartnership.DataBind()

This is returning all the items in the list, what I want is a particular item so I have created a view which displays the 1 item. Can i access the view in a similar way to above?

TIA.

S

Answer 1

Build a CAML query using SPQuery

Then you can use something like the following

Dim Partnership As SPList = web.Lists("PartnersMedia") 
Dim query As New SPQuery()
query.Query = "<Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Completed</Value></Eq></Where>"
rptPartnership.DataSource = Partnership.GetItems(query).GetDataTable() 
rptPartnership.DataBind()