A strange problem with SQL query fro getting field names

Hello All,

I have been trying to get this code work, but I could not. Every thing seems going well. However, The result of running the sql query is strange. It shows the field names twice.
Eg:) if you have a table called "newtable" that has two fields[Custnumber, Custname], you will get somthing like this [Custnumber, Custname Custnumber, Custname]. I have tried many times, but I couldn't fix it.

 Sub Page_Load(sender As Object, e As EventArgs) handles Mybase.Load
 if not page.Ispostback then
 try
 Sqlconnection = New Sqlconnection (connectionString)
 querystring = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNs
 WHERE TABLE_NAME = 'Newtable'"
 SqlCommand = New SqlCommand(queryString, Sqlconnection)
 SqlConnection.Open
 dataReader = SqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
 while dataReader.Read()
 Tablefields_txt.text += dataReader.Getstring(0) & ", "
 End while
 catch ex as Exception
 msgbox("An error has occured: " + ex.Message,0, "Error Message")
 finally
 SqlConnection.Close()
 End try
End if

Any help , pleaseCheck this bit. I assume this might have an impact on your problem.

Tablefields_txt.text += dataReader.Getstring(0) & ", "|||I have tried this:
Dim temp as string
while dataReader.Read()

temp += dataReader.Getstring(0) & ", "

End while

Tablefields_txt.text = temp

I think the problem might be from the querystring "select ....." , but i do know how to deal with it . I need help|||As I posted in your other thread, the problem is due to the "handles Mybase.Load". Remove this and you should see the results you expect.

Terri