I have written this coad at page load:
And I have added two parameter fields BillID and Name to Crystal Report rpt1.

Dim cnn As MySqlConnection
        cnn = New MySqlConnection("SERVER=cltserver;username=root;pa ssword=;DATABASE=bizSPHERE")
        If cnn.State <> ConnectionState.Open Then cnn.Open()
        Dim sql As String
        sql = "select BillId, VenderID from tblbillMaster"
        Dim dA As New MySqlDataAdapter(sql, cnn)
        Dim DS As New DataSet
        dA.Fill(DS, "tblBillMaster")

        Dim CR As rpt1
        CR = New rpt1

        Dim myDBConInfo As New ConnectionInfo

        With myDBConInfo
            .ServerName = "cltserver"
            .DatabaseName = "Bizsphere"
            .UserID = "root"
            .Password = ""
        End With

        Dim myTableLogOnInfo As New TableLogOnInfo
        myTableLogOnInfo.ConnectionInfo = myDBConInfo

        Dim datarow As DataRow
        Dim i As Int16

        For Each datarow In DS.Tables(0).Rows

            Field.ParameterFieldName = "BillID"
            DisVal.Value = datarow(0)
            Field.CurrentValues.Add(DisVal)

            Field = New ParameterField
            DisVal = New ParameterDiscreteValue

            Field.ParameterFieldName = "name"
            DisVal.Value = datarow(1)
            Field.CurrentValues.Add(DisVal)
            Fields.Add(Field)
        Next

        CrystalReportViewer1.ParameterFieldInfo = Fields

        CrystalReportViewer1.ReportSource = CRYRpt1

        cnn.Close()

This coad is working correctly but the problem is that Only last record is adding to crystal report.No error is Coming.
So what should i do get all records.

regards

jeevan

What is DisVal?

I don't see any "x = New y" statements in your loop. Usually when you do looping of this nature, you need to create a new object at the beginning, otherwise all the iterations of the loop are going to use the same instance of an object. When you add that object to a collection, it might not get added any more than once, depending on the object type. This appears to be what's happening with your situation.

Why not just use a DataSet a s the datasource for your report and avoid the looping all toghether?