vb.net error

[douglas]

I am getting the error "system.argumentException; Column ' test_id2' does
not belong to table Table. At System.Data.GetDataColumn( string columnname0
at system.data.datarow.get_item(string columnName).

This error is occuring right after I set the parametervalues in the report
object of the Crystal report.(Note this a visual basic.net 2005 windows form
application.)


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim cryRpt As New ReportDocument
Dim sql As String
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As SqlDataAdapter
Dim ds As New DataSet
Dim i As Integer
Dim test_id1 As Integer
Dim test_id2 As Integer
'located crystal report from
Dim strReportPath As String = "C:\tstReport.rpt"
connetionString = "Data Source=sourcename;Initial
Catalog=databasename;User ID=uname;Password=pwd"
connection = New SqlConnection(connetionString)

sql = "select * from tstTable"
Try
'For i = 0 To ds.Tables(0).Rows.Count - 1

cryRpt.load(strReportPath)

test_id1 = ds.Tables(0).Rows(i).Item("test_id1")

test_id2 = ds.Tables(0).Rows(i).Item("test_id2")


cryRpt.SetParameterValue("@Parm_id1", test_id1)
cryRpt.SetParameterValue("@Parm2_id", test_id2)
cryRpt.SetDatabaseLogon("uname", "pwd")
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Refresh()


Next
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub

The value for the first parameter @Parm_1d1 value to the crystal report
version 11 is correct. However, when trying to access the second @Parm_1d2
parameter ,the values past to the crystal report is not correct.

Can you tell me what is causing the problem?

Thanks!

 

[Tim Patrick]

This is probably a stupid question, but have you verified that there is actually
a column named "test_id2" in your "tstTable" table? Without access to the
tstReport.rpt definition, it's hard to verify that your data source correctly
matches the report definition of the table. Can you verify that everything
matches up?

 

[douglas]

Tim:

I changed the coloumn definitions and it fixed the problem!

Thanks!