Multi DataGridView Data to Crystal Report
Hi,
Could you plz make a tutorial or project on "How to be shown the Multi DataGridView data in CrystalReportView" in VB.NET ?
Thanks
USE [dbperson] GO /****** Object: Table [dbo].[tblperson] Script Date: 11/10/2019 11:15:11 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblperson]( [PersonID] [INT] IDENTITY(1,1) NOT NULL, [Fname] [nvarchar](50) NULL, [Lname] [nvarchar](50) NULL ) ON [PRIMARY] GO
SQL Server
libraries.
Imports System.Data.SqlClient
Dim con As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;Database=dbperson;trusted_connection=true;") Dim cmd As SqlCommand Dim da As SqlDataAdapter Dim dt As DataTable Dim sql As String
Private Sub displayData(sql As String, dtg As DataGridView) Try con.Open() cmd = New SqlCommand() da = New SqlDataAdapter dt = New DataTable With cmd .Connection = con .CommandText = sql End With With da .SelectCommand = cmd .Fill(dt) End With dtg.DataSource = dt Catch ex As Exception MsgBox(ex.Message) Finally con.Close() da.Dispose() End Try End Sub
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load sql = "SELECT Fname as Firstname, Lname as Lastname FROM tblperson" displayData(sql, DataGridView1) End Sub
'first name Private Sub RadioButton1_CheckedChanged(sender As Object, e As EventArgs) Handles RadioButton1.CheckedChanged sql = "SELECT Fname as Firstname FROM tblperson" displayData(sql, DataGridView1) End Sub 'last name Private Sub RadioButton2_CheckedChanged(sender As Object, e As EventArgs) Handles RadioButton2.CheckedChanged sql = "SELECT Lname as Lastname FROM tblperson" displayData(sql, DataGridView1) End Sub 'all Private Sub RadioButton3_CheckedChanged(sender As Object, e As EventArgs) Handles RadioButton3.CheckedChanged sql = "SELECT Fname as Firstname, Lname as Lastname FROM tblperson" displayData(sql, DataGridView1) End Sub