---------------------------------------------------------------------------------------------
Public Class frmStillPendingVehicles
Private Sub btnGenerate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGenerate.Click
Dim strsql As String = ""
strsql = "select trasactionID,VehicleNumber,VehicleType,format(INDATE,'dd/MM/yyyy') as VehicleINDATE ,format(INDATE,'HH:mm:ss') as VehicleINTIME from tblcollection where OUTDATE is NULL" ' and INDATE>=#" & DtFrom.Value.Date & "# and INDATE<#" & DTto.Value.AddDays(1).Date & "# "
Dim m_ds As New DataSet
Dim m_db As New CDataAccess
m_ds = m_db.getdata(strsql, strconnection)
If Not m_ds Is Nothing Then
DataGridView1.DataSource = m_ds.Tables(0)
Else
MsgBox("No Records found", MsgBoxStyle.Information)
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim m_excel As String = ""
If SfdlgDownload.ShowDialog() = Windows.Forms.DialogResult.OK Then
ExportDataToExcel(SfdlgDownload.FileName, DataGridView1)
End If
End Sub
Public Sub ExportDataToExcel(ByVal FilePath As String, ByVal DataGrid As DataGridView)
Dim _mFileStream As New IO.StreamWriter(FilePath, False)
Try
_mFileStream.WriteLine("")
_mFileStream.WriteLine("")
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
For x As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
For i As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
_mFileStream.WriteLine(String.Format("
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
For intRow As Integer = 0 To DataGrid.RowCount - 2
_mFileStream.WriteLine(String.Format("
For intCol As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
_mFileStream.WriteLine(String.Format("
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.Close()
_mFileStream.Dispose()
_mFileStream = Nothing
Catch ex As Exception
_mFileStream.Close()
_mFileStream.Dispose()
_mFileStream = Nothing
MessageBox.Show("Error While Exporting Data To Excel. Error : " & ex.Message)
End Try
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Close()
End Sub
End Class
Guest UserPosted Aug 5, 2014, 9:17 PM
so use Spire.PDF nuget package, I'm sure it'll help you https://www.nuget.org/packages/Spire.PDF/