Hi,
Could someone please point me in the right direction with this? I'd like to put the results of a query into an iEnumerable string and I have no idea of the best way to do this (sorry if this is obvious, it's not to me! :).
conn = "my conn string here"
conn.Open()
Dim strSql As String = "select fileName from myTable where id=@id"
Dim cmd As SqlCommand
cmd = New SqlCommand(strSql)
cmd.CommandType = CommandType.Text
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id
cmd.Connection = conn
'how can I put the results into an IEnumerable string?
conn.Close() '-- close DB
Many thanks for any pointers..
Mark
...
Go to the complete details ...