Database

----------------------------------
NodeID | Node             | Parent
----------------------------------
0      | Parent           |
1      | Programming      | 0
2      |C                 |1
3      |C++               |1
4      |Java              |1
5      |J2ee              |4
6      | Win32            |2 
7      | Win32            |1 
----------------------------------

+Parent
 |-+ Programming
 |   |+ C 
 |     |- Win32
 |   |-C++
 |   |-C#
 |   |+ Java
 |     |-J2EE

<br />
DECLARE @PostalCode varchar(10)<br />
DECLARE @Number int<br />
SET @Number = 0<br />
<br />
WHILE @Number < 100000<br />
BEGIN<br />
	/* Format PostalCode */<br />
	IF LEN(@Number) = 1<br />
	BEGIN<br />
		SET @PostalCode = '0000' + CAST(@Number AS varchar)<br />
	END<br />
	ELSE<br />
	IF LEN(@Number) = 2<br />
	BEGIN<br />
		SET @PostalCode = '000' + CAST(@Number AS varchar)<br />
	END<br />
	ELSE<br />
	IF LEN(@Number) = 3<br />
	BEGIN<br />
		SET @PostalCode = '00' + CAST(@Number AS varchar)<br />
	END<br />
	ELSE<br />
	IF LEN(@Number) = 4<br />
	BEGIN<br />
		SET @PostalCode = '0' + CAST(@Number AS varchar)<br />
	END<br />
	ELSE<br />
	IF LEN(@Number) = 5<br />
	BEGIN<br />
		SET @PostalCode = CAST(@Number AS varchar)<br />
	END<br />
<br />
	/* Insert PostalCode */<br />
	INSERT INTO Wzip_Detail(PostalCode)<br />
	VALUES(@PostalCode)<br />
<br />
	/* Increment number */<br />
	SET @Number = @Number + 1<br />
END<br />

DECLARE @PostalCode varchar(10)
DECLARE @Number int
DECLARE @cTemp varchar(10)
SET @Number = 0

WHILE @Number < 100000
BEGIN
   /* Format PostalCode */
   SET @cTemp = CAST(@Number as VARCHAR(10)) 
   SET @PostalCode = REPLICATE('0',5-LEN(@cTemp)) + @cTemp

   /* Insert PostalCode */
   INSERT INTO Wzip_Detail(PostalCode)
   VALUES(@PostalCode)

   /* Increment number */
   SET @Number = @Number + 1
END

<br />
string[] strNumbers = { "1", "2", "3", "4", "5"};<br />
string strResult = string.Join(",", strNumbers);<br />

using(SqlConnection conn = new SqlConnection("conn string"))
{
    conn.Open();
 
    SqlCommand cmd = new SqlCommand("UPDATE Customers SET Phone = @Phone WHERE CustomerId = @ID",
        conn);
 
    cmd.Parameters.Add("@Phone", newPhoneNumber);
    cmd.Parameters.Add("@ID", customerId);
 
    cmd.ExecuteNonQuery();
}

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico