Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I can print all list items in the list in the SPGridView:

          SPList list = witryna.Lists["Szczegoly"];
          SPListItemCollection items = list.Items;
          gvListItems.DataSource = items.GetDataTable();
          gvListItems.DataBind();

But nothing shows when I want to show specific list items filtered by inputs and dropdowns:

 string SPGridViewQuery = "<Where><And><Eq><FieldRef Name='{0}' /><Value Type='DateTime'>{1}</Value></Eq><Eq><FieldRef Name='Pracownik' /><Value Type='Text'>{2}</Value></Eq></And></Where>";

        var querySzukajacaRekordowTegoSamegoPracownika = new SPQuery();
        if (sprawdzanieUserow())
        {
            querySzukajacaRekordowTegoSamegoPracownika.Query = String.Format(SPGridViewQuery, "Dzien", TextBox3.Text, DropDownList1.SelectedItem.Text);
        }
        else
        {
            querySzukajacaRekordowTegoSamegoPracownika.Query = String.Format(SPGridViewQuery, "Dzien", TextBox3.Text, Microsoft.SharePoint.SPContext.Current.Web.CurrentUser.LoginName.ToLower());
        }
        SPListItemCollection listaRekordowTegoSamegoPracownika = witryna.Lists["Szczegoly"].GetItems(querySzukajacaRekordowTegoSamegoPracownika);

        gvListItems.DataSource = listaRekordowTegoSamegoPracownika.GetDataTable();

        gvListItems.DataBind();

I want only retreive the matching list items and show them in SPGridView. How can I do that?

share|improve this question
1  
Your code looks right, do you know which filter is causing no rows to show? Try to simplify the code down til you can narrow down exactly what is going on –  Ryan Erickson May 9 '13 at 22:21
    
First of all I will try look at CAML Query. –  Grzegorz Z May 10 '13 at 8:48
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.