I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax required to loop through the rows in that particular table and concatenate each output into my string variable in the code block. The server name is "SQL2008T1" and the table name is "dbo.tblVSeriesList".
All I really need is how to declare the variables to connect in the code block and then how to iterate through each record. If anyone can push me the right way I would really appreciate it.