Retrieve data from Sharepoint list to ASPX page

Question

I have a sharepoint list named Products with the following columns:

• ProductID
• Name
• Price.

In ASPX page there are 3 text boxes that will hold the data for each corresponding column as shown below:

textbox1 = productID

textbox2 = Name

textbox3 = Price

The list has 3 products registered with appropriate data. The text boxes in the ASPX page should be populated with data for each product. The data has to be retrieved from the list and bound to the text box using C#.

Answer 1

Use the following code to get all items from the list. Once you have the ListItemCollection, you can access value of each list item and bind it to the text box.

 SPWeb web = SPContext.Current.Web;
 SPList docList = web.Lists.GetList(enter list ID here, true);
 SPListItemCollection items = docList.GetItems();
 foreach(SPItem item in items)
 {
     textbox1.text = item.ID;
     textbox1.text = item["Name"];
     textbox1.text = item["Price"]; 
 }      

Answer 2

You can retrieve the SharePoint list data using client-object model in ASPX page very easily. here is the link to Access SharePoint list data using Client Object Model