Extract info from census bureau

[lildiapaz]

How, do i extract first and last names from the census bureau website and add it into an sql 2000 table in c# windows application

Here's what i have attempted so far:

//class1.c



using System;

using System.Collecti ons.Generic;

using System.Text;

using System.Net;

using System.IO;



namespace Project_3

{

class Class1

{

static void main(string[] args)

{

StringBuilder str = new StringBuilder() ;

byte[] buffer = new byte[65535];



//request page

HttpWebRequest request = (HttpWebRequest )

WebRequest.Crea te("http://www.census.gov/genealogy/names/dist.female.fir st");



//execute web page

HttpWebResponse response =(HttpWebRespon se)

request.GetResp onse();



//read data from web page

Stream read_stream = response.GetRes ponseStream();



string temp = null;

int ct = 0;



do

{

//fill buffer

ct = read_stream.Rea d(buffer, 0, buffer.Length);

if (ct != 0)

{

temp = Encoding.ASCII. GetString(buffe r, 0, ct);



//append

str.Append(temp );

}

} while (ct > 0);



}

}

}
Any help will be appreciated
Thanks, :)