Report Control - reportcontrol and database

Print Page | Close Window

reportcontrol and database

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=19927
Printed Date: 30 November 2024 at 10:52am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: reportcontrol and database

Posted By: ray2012
Subject: reportcontrol and database
Date Posted: 09 July 2012 at 5:57am

hi,

I am new to this control and I was wondering if there is any way to read each row of my reportcontrol and register the value of each item to a ms access database. I tried the following code, but it's not working:

    For i = 1 To RptControl.Rows.Count - 1
        .AddNew
        .Fields("Field1") = RptControl.Rows.Row(i).Record.Item(0).Value
        .Fields("Field2") = RptControl.Rows.Row(i).Record.Item(1).Value
        .Fields("Field3") = RptControl.Rows.Row(i).Record.Item(2).Value
        .Fields("Field4") = RptControl.Rows.Row(i).Record.Item(3).Value
        .Update
    Next

please let me know what am I doing wrong?

thank you,