C#

SELECT UID as [User ID], UNAME as [User Name], UADD as [User Address] 
FROM tblUserInfo

		<br />
ButtonArray btnArray;<br />
ButtonArray tempArray;<br />
<...><br />
private void Form1_Load(object sender, System.EventArgs e)<br />
{<br />
btnArray = new ButtonArray(this);<br />
tempArray = new ButtonArray(this);<br />
}<br />

using System;<br />
<br />
namespace ButtonArray<br />
{<br />
	/// <summary><br />
	/// Summary description for ButtonArray.<br />
	/// </summary><br />
	public class ButtonArray : System.Collections.CollectionBase<br />
	{<br />
		private readonly System.Windows.Forms.Form HostForm;<br />
		<br />
		public System.Windows.Forms.Button AddNewButton()<br />
		{<br />
			// Create a new instance of the Button class.<br />
			System.Windows.Forms.Button aButton = new System.Windows.Forms.Button();<br />
			<br />
			// Add the button to the collection's internal list.<br />
			this.List.Add(aButton);<br />
			<br />
			// Add the button to the controls collection of the form <br />
			// referenced by the HostForm field.<br />
			HostForm.Controls.Add(aButton);<br />
			<br />
			// Set intial properties for the button object.<br />
			aButton.Top = Count * 25;<br />
			aButton.Left = 100;<br />
			aButton.Tag = this.Count;<br />
			aButton.Text = "Button " + this.Count.ToString();<br />
			<br />
<br />
			aButton.Click += new System.EventHandler(ClickHandler);<br />
			<br />
			return aButton;<br />
		}<br />
		public ButtonArray(System.Windows.Forms.Form host)<br />
		{<br />
			HostForm = host;<br />
			this.AddNewButton();<br />
		}<br />
		<br />
		public System.Windows.Forms.Button this [int Index]<br />
		{<br />
			get<br />
			{<br />
				return (System.Windows.Forms.Button) this.List[Index];<br />
			}<br />
			<br />
			set<br />
			{<br />
				this.List[Index] = value;<br />
			}<br />
		}<br />
		<br />
		public void RemoveX(int iRemoveX)<br />
		{<br />
			// Check to be sure there is a button to remove.<br />
			if (this.Count > 0)<br />
			{<br />
				// Remove the button indexed with the value of iRemoveX<br />
				HostForm.Controls.Remove(this[iRemoveX-1]);<br />
				this.List.RemoveAt(this.Count-1);<br />
			}<br />
		}<br />
		<br />
		public void RemoveButton()<br />
		{<br />
			// Check to be sure there is a button to remove.<br />
			if (this.Count > 0)<br />
			{<br />
				// Remove the last button added to the array from the host form <br />
				// controls collection. Note the use of the indexer in accessing <br />
				// the array.<br />
				HostForm.Controls.Remove(this[this.Count -1]);<br />
				this.List.RemoveAt(this.Count -1);<br />
			}<br />
		}<br />
		<br />
		public void FlushArray()<br />
		{<br />
			// Check to be sure there is a button to remove.<br />
			if (this.Count > 0)<br />
			{<br />
				for(int iButtonIndex = this.Count; iButtonIndex > 0; iButtonIndex--)<br />
				{<br />
					// Remove the button indexed with the value of iRemoveX<br />
					HostForm.Controls.Remove(this[iButtonIndex-1]);<br />
					this.List.RemoveAt(iButtonIndex-1);<br />
				}<br />
			}<br />
		}<br />
		<br />
		public void ClickHandler(Object sender, System.EventArgs e)<br />
		{<br />
			System.Windows.Forms.MessageBox.Show("You have clicked button " + <br />
				((System.Windows.Forms.Button) sender).Tag.ToString());<br />
		}<br />
	}<br />
}

protected override void Paint(System.Drawing.Graphics g, System.Drawing.Rectangle bounds, CurrencyManager source, int rowNum, System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush, bool alignToRight) <br />
       { <br />
          DataRowView view = (DataRowView) source.Current;<br />
          System.Drawing.Color myColour = Color.White;<br />
          numberFormatInfo = new NumberFormatInfo();<br />
	      numberFormatInfo.CurrencySymbol = "$";<br />
	      numberFormatInfo.NumberDecimalDigits = 0;<br />
	      numberFormatInfo.CurrencyDecimalDigits = 0;<br />
	      numberFormatInfo.CurrencyNegativePattern = 1;<br />
          <br />
          //object o = this.GetColumnValueAtRow(source, rowNum);<br />
          <br />
          <br />
          string[] str = view.DataView.Table.Rows[rowNum]["IndentLevel"].ToString().Split('~');<br />
          /*<br />
          if (rowNum < 4) {<br />
             this.Format = "n";<br />
             this.FormatInfo = numberFormatInfo;<br />
          } else {<br />
             this.Format = "c";<br />
             this.FormatInfo = numberFormatInfo;<br />
          } <br />
          */<br />
          <br />
          <br />
          <br />
          // --- Main Heading ---<br />
          if (str.Length == 1) {<br />
             myColour = Color.Coral;<br />
          } else if (str.Length == 2) {<br />
             // --- Sub Headings ---<br />
             if (str[1] == "1" || str[1] == "4") {<br />
                myColour = Color.PaleGoldenrod;<br />
             // --- Net Sum Headings ---<br />
             } else if (str[1] == "7") {<br />
                myColour = Color.Lavender;<br />
             // --- Other Headings ---<br />
             } else {<br />
                myColour = Color.Wheat;<br />
             }<br />
          // --- Populated Rows ---<br />
          } else if (str.Length == 3) {<br />
             myColour = Color.SeaShell;<br />
          } else {<br />
             myColour = Color.Thistle;<br />
          }<br />
		  <br />
		  // ----------------------------<br />
		  // ------ Paint the Row -------<br />
		  // ----------------------------<br />
          try{ <br />
             backBrush = new SolidBrush(myColour); <br />
          } <br />
          catch(Exception) {} <br />
          finally {<br />
             base.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight); <br />
          } <br />
       }