Sharepoint 2010 List Column to be fetched in Web part

Question

0.00/5 (No votes)

See more:

SharePoint2010

Hello,
I am new to the Sharepoint 2010 development, and have a requirement where in the Visual Web part i have a dropdown and this dropdown needs to be popluated with the Column values of another list.
Being precise, the Dropdownlist_projectName should be populated from the Name Column of a list named "Project". I was trying to work with the below piece of code but i don't know where i am going wrong-

C#

SPQuery ratecardQuery = new SPQuery();

            ratecardQuery.ViewFields = "<FieldRef Name='Project_x0020_Name'/>";
            ratecardQuery.ViewFieldsOnly = true;
            ratecardQuery.Query = "<Where><Eq><FieldRef Name=\"Project Name\"/><Value Type=\"Text\"></Value></Eq></Where>";

            SPList resourceRateList = SPContext.Current.Web.Lists["Project"];
            SPListItemCollection item = resourceRateList.GetItems(ratecardQuery);

            DataTable tmpTable = new System.Data.DataTable();
            tmpTable = item.GetDataTable();

When i debug the code, i see tmpTable coming as null.
Please help.

Posted 7-Oct-13 3:33am

adityasahver

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

adityasahver · Accepted Answer · 2013-10-08T04:11:00

I dont know why the community dint gave any response but here is the solution-

C#

SPQuery query = new SPQuery();
               query.ViewFieldsOnly = true;
               query.ViewFields = "<fieldref name="Project_x0020_Name" />";
               using (SPSite site = new SPSite(SPContext.Current.Web.Url))
               {
                   using (SPWeb web = site.OpenWeb())
                   {
                       SPList list = web.Lists["Project"];
                       if (list != null)
                       {
                           DataTable dt = new DataTable();
                           dt = list.GetItems(query).GetDataTable();
                           DropDownList1.DataSource = dt;
                           DropDownList1.DataValueField = "Project_x0020_Name";
                           DropDownList1.DataTextField = "Project_x0020_Name";
                           DropDownList1.DataBind();
                           DropDownList1.Items.Insert(0, "--Select Project Name--");

                       }
                   }

               }

Sharepoint 2010 List Column to be fetched in Web part

1 solution

Solution 1

Add your solution here

Preview 0

Sharepoint 2010 List Column to be fetched in Web part

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us