locked
problem with access connection with crystal report RRS feed

  • Question


  •             Dim oAdapter As OleDb.OleDbDataAdapter
                Dim TbMilkMan As dSetMilkMan.TbMilkManDataTable
                Dim oTableMapping As Common.DataTableMapping

                Dim Sql As String
                Sql = "Select MMName From TbMilkManInfo"

                oAdapter = New OleDb.OleDbDataAdapter(Sql, gConnectionString)
                TbMilkMan = New dSetMilkMan.TbMilkManDataTable
                oTableMapping = New Common.DataTableMapping("TbMilkManDataTable", "TbMilkManInfo")
                oTableMapping.ColumnMappings.Add("MMName", "MMName")
                oAdapter.Fill(TbMilkMan)

                Dim rMilkMan As New MilkManReport
                rMilkMan.SetDataSource(TbMilkMan.DefaultView)
               /*here am getting the login dialog form of database . tell me how to enter the database
                F.CrystalReportViewer1.ReportSource = (rMilkMan)

                F.ShowDialog()

    Monday, March 8, 2010 7:49 AM