Example for updating list in Sharepoint 2010

1. Mark sure you have sharepoint 2010 and visual studio 2010. Here, i installed sharepoint 2010 and vs2010 RC on my windows7 x64.

 

2. Create Products list in SP. the list contain 3 columns (Item, Nation, Price)

Item               Nation            Price

IPhone           US                   100

IPad               US                   800

E71                China               500

Moto              China               600

 

3. Add the list to a new page. it should be added in a webpart.

 

4. Create an empty sharepoint solution then add a webpart feature in it.

 

5. See the code

[ToolboxItemAttribute(false)] public class ListControllerWebpart : WebPart { protected override void CreateChildControls() { // Add discount button Button btn1 = new Button(); btn1.Text = "Adding discount"; btn1.Click += new EventHandler(btn1_Click); this.Controls.Add(btn1); // adding tax For China Button Button btn2 = new Button(); btn2.Text = "Adding Tax For China"; btn2.Click += new EventHandler(btn2_Click); this.Controls.Add(btn2); } protected void btn1_Click(object sender, EventArgs e) { // You can not use the clause like following /* * using(SPWeb web = SPContext.Current.Web) * { * doing something. * } * because this will release the SPContex.Current.Web object as well and the site will crash. */ SPWeb myweb = SPContext.Current.Web; SPList productList = myweb.Lists["Products"]; if (productList != null) { foreach (SPListItem item in productList.Items) { item["Price"] = Convert.ToDouble(item["Price"]) * 0.9; item.Update(); } this.Page.Response.Redirect(productList.DefaultViewUrl); } } void btn2_Click(object sender, EventArgs e) { SPWeb myweb = SPContext.Current.Web; SPList productList = myweb.Lists["Products"]; SPQuery queryChina = new SPQuery(productList.DefaultView); // define the fields returned in the query queryChina.ViewFields = "<FieldRef Name='Price' />"; // define the query. queryChina.Query = "<Where><Contains><FieldRef Name='Nation' /><Value Type='Text'>China</Value></Contains></Where>"; // update the list foreach (SPItem item in productList.GetItems(queryChina)) { item["Price"] = Convert.ToDouble(item["Price"]) * 2; item.Update(); } } }

 

6. deploy and add the webpart to your page. then run it.