Determining Sql Column name?

[Jeff]

The code below will correctly locate the last entry in a particular SQL Table in VWeb 2005 with VB.

How can I determine the column name associated with the column number x?

Dim tempA As System.Data.DataView
tempA = GetPriorAnswers()
Dim x As Integer
Dim temp As Integer = Session("Pointer")
For i As Integer = 1 To 10000
x = temp - i
If Len(tempA.Item(0)(x).ToString) 0 Then
Exit For
End If
Next
<at this point, x is the column number for the last entry in the table - what code will return the column name?>

Thanks in advance

Jeff


--
Posted via a free Usenet account from http://www.teranews.com

[rowe_newsgroups]

Check out http://support.sas.com/ctx/samples/index.jsp?sid=817
About midway down it talks about using the schema data to retrieve this
(with ADO.Net)

Thanks,

Seth Rowe

Jeff wrote:

The code below will correctly locate the last entry in a particular SQL Table in VWeb 2005 with VB.

How can I determine the column name associated with the column number x?

Dim tempA As System.Data.DataView
tempA = GetPriorAnswers()
Dim x As Integer
Dim temp As Integer = Session("Pointer")
For i As Integer = 1 To 10000
x = temp - i
If Len(tempA.Item(0)(x).ToString) 0 Then
Exit For
End If
Next
<at this point, x is the column number for the last entry in the table - what code will return the column name?>

Thanks in advance

Jeff


--
Posted via a free Usenet account from http://www.teranews.com

[Cor Ligthert [MVP]]

Jeff,

http://msdn.microsoft.com/library/de...tabletopic.asp

dim dcname as string = TempA.ToTable.DataColumns(x).Columnname

http://msdn.microsoft.com/library/de...nnametopic.asp

I hope this helps,

Cor

"Jeff" <no**@none.comschreef in bericht
news:45***********************@free.teranews.com.. .

>
The code below will correctly locate the last entry in a particular SQL
Table in VWeb 2005 with VB.

How can I determine the column name associated with the column number x?

Dim tempA As System.Data.DataView
tempA = GetPriorAnswers()
Dim x As Integer
Dim temp As Integer = Session("Pointer")
For i As Integer = 1 To 10000
x = temp - i
If Len(tempA.Item(0)(x).ToString) 0 Then
Exit For
End If
Next
<at this point, x is the column number for the last entry in the table -
what code will return the column name?>

Thanks in advance

Jeff


--
Posted via a free Usenet account from http://www.teranews.com

[rowe_newsgroups]

Sorry, guess I read your post wrong (got thrown off by the post title)
- I thought you were looking for the column name of a SQL Server table.

Thanks,

Seth Rowe

Cor Ligthert [MVP] wrote:

Jeff,

http://msdn.microsoft.com/library/de...tabletopic.asp

dim dcname as string = TempA.ToTable.DataColumns(x).Columnname

http://msdn.microsoft.com/library/de...nnametopic.asp

I hope this helps,

Cor

"Jeff" <no**@none.comschreef in bericht
news:45***********************@free.teranews.com.. .

The code below will correctly locate the last entry in a particular SQL
Table in VWeb 2005 with VB.

How can I determine the column name associated with the column number x?

Dim tempA As System.Data.DataView
tempA = GetPriorAnswers()
Dim x As Integer
Dim temp As Integer = Session("Pointer")
For i As Integer = 1 To 10000
x = temp - i
If Len(tempA.Item(0)(x).ToString) 0 Then
Exit For
End If
Next
<at this point, x is the column number for the last entry in the table -
what code will return the column name?>

Thanks in advance

Jeff


--
Posted via a free Usenet account from http://www.teranews.com

[Cor Ligthert [MVP]]

Jeff,

You are right if the select is renaming the table names, as long as that is
not done, this is correct.

Another way is using this.

http://www.vb-tips.com/dbpages.aspx?...c-e9d7983c1e05

I hope this helps,

Cor

"rowe_newsgroups" <ro********@yahoo.comschreef in bericht
news:11**********************@e3g2000cwe.googlegro ups.com...

Sorry, guess I read your post wrong (got thrown off by the post title)
- I thought you were looking for the column name of a SQL Server table.

Thanks,

Seth Rowe

Cor Ligthert [MVP] wrote:

>Jeff,

http://msdn.microsoft.com/library/de...tabletopic.asp

dim dcname as string = TempA.ToTable.DataColumns(x).Columnname

http://msdn.microsoft.com/library/de...nnametopic.asp

I hope this helps,

Cor

"Jeff" <no**@none.comschreef in bericht
news:45***********************@free.teranews.com. ..

>
The code below will correctly locate the last entry in a particular SQL
Table in VWeb 2005 with VB.

How can I determine the column name associated with the column number
x?

Dim tempA As System.Data.DataView
tempA = GetPriorAnswers()
Dim x As Integer
Dim temp As Integer = Session("Pointer")
For i As Integer = 1 To 10000
x = temp - i
If Len(tempA.Item(0)(x).ToString) 0 Then
Exit For
End If
Next
<at this point, x is the column number for the last entry in the
table -
what code will return the column name?>

Thanks in advance

Jeff


--
Posted via a free Usenet account from http://www.teranews.com

[Jeff]

The "DataColumns" part of your syntax didn't work, but the following minor modification did.
ColName = tempA.ToTable.Columns(x).ColumnName()

Thanks. ...not sure why the original didn't work, but perhaps related to something I would need to import first?

Jeff
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message news:%2****************@TK2MSFTNGP02.phx.gbl...

Jeff,

http://msdn.microsoft.com/library/de...tabletopic.asp

dim dcname as string = TempA.ToTable.DataColumns(x).Columnname

http://msdn.microsoft.com/library/de...nnametopic.asp

I hope this helps,

Cor

--
Posted via a free Usenet account from http://www.teranews.com

[Cor Ligthert [MVP]]

Jeff,

This works however I made a mistake while typing, now you are copying the
table first my intention was

ColName = tempA.Table.Columns(x).ColumnName()

Than it is just using the table,
Cor

"Jeff" <no**@none.comschreef in bericht
news:45***********************@free.teranews.com.. .

>
The "DataColumns" part of your syntax didn't work, but the following minor
modification did.
ColName = tempA.ToTable.Columns(x).ColumnName()

Thanks. ...not sure why the original didn't work, but perhaps related to
something I would need to import first?

Jeff
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>Jeff,

http://msdn.microsoft.com/library/de...tabletopic.asp

dim dcname as string = TempA.ToTable.DataColumns(x).Columnname

http://msdn.microsoft.com/library/de...nnametopic.asp

I hope this helps,

Cor

--
Posted via a free Usenet account from http://www.teranews.com