SqlCommand thisCommand = thisConnection.CreateCommand(); thisCommand.CommandText = "select distinct claimid,claimno, claimdocumenttypeid from ClaimDocument cd1 inner join Claim c on c.ID = cd1.ClaimID where cd1.RecordStatus = 1 and cd1.claimdocumenttypeid = 1 and c.claimno = Data("Claimno");
1 Answer, 1 is accepted
0
Hi Pavan,
Cody
the Telerik team
I apologize for the delay getting back to you on this.
How do i refer to the data in the datasource.
There are a couple of ways. The most direct method is the Data object e.g.
Data["Claimno"];
This will fetch the current value of the column Claimno from the current row from the datasource bound to the test.
You can also get at all of the data for the current row using:
ExecutionContext.CurrentDataRow
This will return the entire DataTable object containing all the data rows that will be used throughout the life of the test:
ExecutionContext.DataSource
Looking at your code I think the only error is you need to use [ ] instead of ( ) characters.
Cody
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Test Studio Trainings