Using Result of SQL Coded Step as a Data Bind Variable

[Korey]

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. 

[Boyan Boev]

Hi Korey,

If I understand correctly the result is this row of code: 

(String) thisReader["BarcodeId"]

Am I correct?

If so you should put this into an extracted variable. You should add a single row into the While loop:

while (thisReader.Read())
{
       Log.WriteLine("BarcodeId: " + (String) thisReader["BarcodeId"]);
       SetExtractedValue("extractedID", (String) thisReader["BarcodeId"]);
}

When you want to use that variable you should use:

object myData = GetExtractedValue("extractedID");

Let me know if that helps.


Regards,
Boyan Boev
Telerik by Progress

 

[Korey]

Boyan,

Sorry for the late reply -- as I was out for the holidays. 

Thanks for your suggestion.  I'll give it a try. 

 

 

 

[Korey]

This worked great!  Thanks again!

[Boyan Boev]

Hi Korey,

Happy to hear that.

If you need further assistance please let us know.

Regards,
Boyan Boev
Telerik by Progress