Retreive Last column name

[waely]

hi,
can someone give me a tip how to, in my select statment, retreive my last column name and then if's not equal to certain value to add column to table?

example
if last column is year 2005 (Y05) I want to retrive this value and compare it to this year and if it doesn't match then add (Y06) column.

thank you very much.

 

[waely]

sorry, I forgot to mention that I'm using VB.net with Sql server backend. thanks

 

[ca8msm]

What object are you using to store the data that is returned?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[waely]

I'm using datasets and dataadapter

 

[ca8msm]

Well, without testing it, I guess it would go along the lines of:

        If myDataSet.Tables(0).Columns(dt.Columns.Count - 1).ColumnName = System.DateTime.Now.Year.ToString Then
            myDataSet.Tables(0).Columns.Add(System.DateTime.Now.AddYears(1).Year.ToString)
        End If

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[waely]

thank you.