problem in unboundstring crystal report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

my code is as below.


Dim cn As New ADODb.Connection
Dim cmd As New ADODb.Command

Private Sub Report_Initialize()
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test\TEST.
mdb;Persist Security Info=False"
cmd.ActiveConnection = cn
cmd.CommandType = adCmdText
cmd.CommandText = "select * from Table1"
Database.AddADOCommand cn, cmd
UnboundString3.MaxNumberOfLines = 2
UnboundString3.SetUnboundFieldSource "{ado.ID}"
UnboundString4.SetUnboundFieldSource "{ado.FNAME}"
End Sub

i want to do it with recordset ...
plz help

.

Relevant Pages

  • howto use insertCmd for DataAdapter?
    ... Private Sub btn1_click ... Dim cmd As New OleDBCommandValues ... a data adapter component from ... >I can see data from the Access mdb in the grid. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Create a SQL Database or Tables in SQL Database using VB.net
    ... > Dim conn As SqlConnection ... > Private Sub Form1_Load(ByVal sender As System.Object, ... > Dim cmd As New SqlCommand ... > delete tables or modify the records in the database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Create a SQL Database or Tables in SQL Database using VB.net
    ... > Dim conn As SqlConnection ... > Private Sub Form1_Load(ByVal sender As System.Object, ... > Dim cmd As New SqlCommand ... > delete tables or modify the records in the database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: "Incorrect syntax near" problems
    ... I'm getting the following error when I try to execute the function below: ... Private sub LoadListSet() ... Dim cmd as New SqlCommand ... In SQL Enterprise Manager the stored proc works just fine. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Creating temporary tables at run-time in SQL using VB.Net
    ... > Dim conn As SqlConnection ... > Private Sub Form1_Load(ByVal sender As System.Object, ... > Private Sub CreateDataBase() ... > Dim cmd As New SqlCommand ...
    (microsoft.public.dotnet.languages.vb)