Two List boxes to move item between them (Asp.Net 2.0)

This is common funcationality that we want mostly when developing web sites. First list box will show all the available items and second list box will show only selected items by user.
User may wants to move items
one by one or
multiple selected items may want to move second list box or
all the items want to move second list list box.

protected void groupSetRight_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < AvailableGroupListBox.Items.Count; i++)
{
if (AvailableGroupListBox.Items[i].Selected == true)
{
myGroupListBox.Items.Add(AvailableGroupListBox.Items[i]);
AvailableGroupListBox.Items[i].Selected = false;
AvailableGroupListBox.Items.Remove(AvailableGroupListBox.Items[i]);
i--;
}
}
}


protected void allGroupSetRight_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < AvailableGroupListBox.Items.Count; i++)
{
myGroupListBox.Items.Add(AvailableGroupListBox.Items[i]);
AvailableGroupListBox.Items.Remove(AvailableGroupListBox.Items[i]);
i--;
}

}


protected void groupSetLeft_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < myGroupListBox.Items.Count; i++)
{
if (myGroupListBox.Items[i].Selected == true)
{
AvailableGroupListBox.Items.Add(myGroupListBox.Items[i]);
myGroupListBox.Items.Remove(myGroupListBox.Items[i]);
i--;
}
}

}


protected void allGroupSetLeft_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < myGroupListBox.Items.Count; i++)
{
AvailableGroupListBox.Items.Add(myGroupListBox.Items[i]);
myGroupListBox.Items.Remove(myGroupListBox.Items[i]);
i--;
}
}

T-Sql Simple Transactions

USE NORTHWIND

GO

/*

 * Create a stored procedure to delete a product.

 */

CREATE PROCEDURE dbo.ttDeleteProduct

(

@ProductID int

)

AS

BEGIN TRANSACTION

DELETE FROM [Order Details] WHERE ProductID=@ProductID

IF @@ERROR <> 0

ROLLBACK TRANSACTION

ELSE

BEGIN

DELETE FROM Products WHERE ProductID=@ProductID

IF @@ERROR <> 0

ROLLBACK TRANSACTION

ELSE

COMMIT TRANSACTION

END

GO

Reading a xml file

using System.Xml.Io;

StreamReader sr = new StreamReader (@”cars.xml”);
XmlTextReader xr = new XmlTextReader(sr);
XmlDocument xd = new XmlDocument();
xd.Load(xr);
xd.InnerText; // volvo4401996sunnyfb152002
xd.FirstChild.InnerText; // version=”1.0” encoding=”utf-8”
xd.FirstChild.NextSibiling.InnerText; // volvo4401996sunnyfb152002

-------XmlNode
Xmlnode xn = xd.FirstChild.NextSibling;
xn.InnerText; // volvo4401996sunnyfb152002
xn.FirstChild.InnerText; // volvo4401996
xn.FirstChild. FirstChild.InnerText; //Volvo

------X-Path Expression
XmlNodeList carlotItems1 = xd.selectNodes(“Carlot”);
XmlNodeList carlotItems = xd.selectNodes(“Carlot/Car”);
XmlNode make = carlotItems.Item(0).SelectSingleNode(“make”); //volvo