code to select columns stsrting with same letter

[padhminiatluri]

please tell the code to select all the columns starting with same letter in asp.net using vb actually my query is working in sql server but i want to know the syntax which works in .net using vb

[shweta123]

Hi,

You can try this code,

con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;password=;Initial Catalog=Pubs;Data Source=."
con.Open()

da = New OleDbDataAdapter("Select * from Authors", con)

da.Fill(ds)
Dim col(10) As DataColumn
Dim i As Integer = 0
For Each c As DataColumn In ds.Tables(0).Columns
If UCase(c.ColumnName).StartsWith("A") Then

col(i) = c

i = i + 1
End If
Next
con.Close()


Is it the same thing you are looking for?