I've performed a lot of searching/reading, and cannot find a solution to my problem. First off, I'm far from a coding expert. I currently have a custom coded step to connect to SQL Server, run a Query (select/join/etc.), and print the result to the log. This works:
SqlConnection thisConnection = <connection string)>
thisConnection.Open();
Log.WriteLine(thisConnection.Database);
SqlCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText = <SQL query>
SqlDataReader thisReader = thisCommand.ExecuteReader();
while (thisReader.Read())
{
Log.WriteLine("BarcodeId: " + (String) thisReader["BarcodeId"]);
}
thisReader.Close();
thisConnection.Close();
The result from above writes my expected result to the log. Now, I want to use this result to data bind a test input box further down in the script. I've tried playing with set/getextracted values, etc. I know how to do this if extracting an HTML TextContent into a DataBindVariable, but unsure how to do the same with a result from SQL query (coded database step). Thanks in advance.