Sunday, April 27, 2014

Visual Basic .NET Tutorial 53 -How to import excel file to datagridview ...







Public Class Form1


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        
        Try

            Dim MyConnection As System.Data.OleDb.OleDbConnection
            Dim dataSet As System.Data.DataSet
            Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
            Dim path As String = "C:\\Users\\dwishika\\Desktop\\vids\\excel\\Book1.xlsx"

            MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;")
            MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection)

            dataSet = New System.Data.DataSet
            MyCommand.Fill(dataSet)
            DataGridView1.DataSource = dataSet.Tables(0)

            MyConnection.Close()
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try

    End Sub
End Class












---------------------------------------

Importing Any Excel Spreadsheet into a DataGridView - C#
VB.NET - Importing Excel File to dataGridView
import Excel File to VB.NET.net DataGridView
Import Excel To DatagridView
Import Data from Excel to DataGridView in VB.NET
import from excel to datagridview
VB.NET DataGridView Loading data from Excel
importing excel file into datagridview  How to get data from excel sheet to datagridview in VB.NET importing RowName and ColumnName from an excelfile posts
Import Excel file to DataGridView‎ VB.NET
Saving DataGrid View to Excel and opening Excel to
How to import data from Excel to Datagrid‎
How to Export Datagridview contents to Excel - VB.NET

Visual Basic .NET Tutorial 53 -How to import excel file to datagridview ...







Public Class Form1


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        
        Try

            Dim MyConnection As System.Data.OleDb.OleDbConnection
            Dim dataSet As System.Data.DataSet
            Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
            Dim path As String = "C:\\Users\\dwishika\\Desktop\\vids\\excel\\Book1.xlsx"

            MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;")
            MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection)

            dataSet = New System.Data.DataSet
            MyCommand.Fill(dataSet)
            DataGridView1.DataSource = dataSet.Tables(0)

            MyConnection.Close()
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try

    End Sub
End Class












---------------------------------------

Importing Any Excel Spreadsheet into a DataGridView - C#
VB.NET - Importing Excel File to dataGridView
import Excel File to VB.NET.net DataGridView
Import Excel To DatagridView
Import Data from Excel to DataGridView in VB.NET
import from excel to datagridview
VB.NET DataGridView Loading data from Excel
importing excel file into datagridview  How to get data from excel sheet to datagridview in VB.NET importing RowName and ColumnName from an excelfile posts
Import Excel file to DataGridView‎ VB.NET
Saving DataGrid View to Excel and opening Excel to
How to import data from Excel to Datagrid‎
How to Export Datagridview contents to Excel - VB.NET

Visual Basic .NET Tutorial 52 - How to Display Google Maps in VB.NET






Imports System.Text
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim street As String = TextBox_street.Text
        Dim city As String = TextBox_city.Text
        Dim state As String = TextBox_state.Text
        Dim zip As String = TextBox_zip.Text

        Try
            Dim queryAddress As New StringBuilder
            queryAddress.Append("http://maps.google.com/maps?q=")

            If TextBox_street.Text <> String.Empty Then
                queryAddress.Append(street + "," & "+")
            End If
            If TextBox_city.Text <> String.Empty Then
                queryAddress.Append(city + "," & "+")
            End If
            If TextBox_state.Text <> String.Empty Then
                queryAddress.Append(state + "," & "+")
            End If
            If TextBox_zip.Text <> String.Empty Then
                queryAddress.Append(zip + "," & "+")
            End If

            WebBrowser1.Navigate(queryAddress.ToString)

        Catch ex As Exception
            MessageBox.Show("Unable to retrive date")
        End Try

    End Sub
End Class








---------------------------------------------------------------

Show Your Data on Google Map using VB.NET
How to add google maps in a VB.NET  Program
VB.NET  - how to display address in google map
Display Google Map in Windows Form - VB.NET  / C Sharp
display google maps in VB.NET  application
VB.NET  And Google Maps - VB.NET
Integrating Google Maps with VB.NET
Embed Google Maps in VB.NET
how to show locations in a Google map
Google Maps in VB.NET  Web Application

Monday, April 7, 2014

Visual Basic .NET Tutorial 50 - Add table into existing PDF using iText...





Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            Dim pdfDoc As New Document()
            Dim pdfWrite As PdfWriter =
            PdfWriter.GetInstance(pdfDoc,
                                  New FileStream("Simple.pdf", FileMode.Create))
            pdfDoc.Open()

            Dim table As New PdfPTable(3)
            Dim cell As New PdfPCell(New Phrase("Header spanning 3 columns"))
            cell.Colspan = 3
            cell.HorizontalAlignment = 1
            '0=Left, 1=Centre, 2=Right
            table.AddCell(cell)
            table.AddCell("Col 1 Row 1")
            table.AddCell("Col 2 Row 1")
            table.AddCell("Col 3 Row 1")

            table.AddCell("Col 1 Row 2")
            table.AddCell("Col 2 Row 2")
            table.AddCell("Col 3 Row 2")

            pdfDoc.Add(table)
           
            pdfDoc.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
       
    End Sub
End Class












-------------------------------------------------------

How to specify the position of the table in a pdf file using iTextsharp

VB.NET - iTextSharp table width 100% of page

iTextSharp-Introducing-Tables

iTextSharp - Introducing Tables

Creating PDF Tables using VB.NET

VB.NET  - How to set the cell width in itextsharp pdf creation

iTextSharp Tables

Sunday, April 6, 2014

Visual Basic .NET Tutorial 49 - Working with images in iTextSharp PDF file



Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            Dim pdfDoc As New Document()
            Dim pdfWrite As PdfWriter =
            PdfWriter.GetInstance(pdfDoc,
                                  New FileStream("Simple.pdf", FileMode.Create))
            pdfDoc.Open()
            pdfDoc.Add(New Paragraph("Show Image"))

            Dim img As Image = Image.GetInstance("vb36.png")
            img.ScalePercent(50.0F)
            img.ScaleToFit(250.0F, 250.0F)
            img.Border = Rectangle.BOX
            img.BorderColor = iTextSharp.text.BaseColor.GREEN
            img.BorderWidth = 10.0F
            pdfDoc.Add(img)

           
            pdfDoc.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
       
    End Sub
End Class














--------------------------------------------

VB.NET- ITextSharp - working with images

VB.NET - scaling images in iTextSharp

VB.NET - Cannot get SpacingAfter to work on image with iTextSharp

VB.NET - Adding an image to a PDF using iTextSharp and scale

VB.NET - itextsharp and images sizes

How can I insert an image with iTextSharp in an existing PDF

Extract images using iTextSharp

iTextSharp -- Working with images

iTextSharp: inserting an image?


Saturday, April 5, 2014

Visual Basic .NET Tutorial 48 - How to create Lists with iTextSharp PDF ...





Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Public Class Form1


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            Dim pdfDoc As New Document()
            Dim pdfWrite As PdfWriter =
            PdfWriter.GetInstance(pdfDoc,
                                  New FileStream("Simple.pdf", FileMode.Create))
            pdfDoc.Open()
            pdfDoc.Add(New Paragraph("Hello World"))

            Dim list As New List(list.UNORDERED)
            list.IndentationLeft = 30.0F
            list.Add(New ListItem("One"))

            list.Add("Two")
            list.Add("Three")
            list.Add("Four")
            list.Add("Five")
            'pdfDoc.Add(New Paragraph("List"))
            'pdfDoc.Add(list)

            Dim romanlist As New RomanList(True, 20)
            romanlist.IndentationLeft = 30.0F
            romanlist.Add(New ListItem("One"))

            romanlist.Add("Two")
            romanlist.Add("List")
            romanlist.Add(list)
            romanlist.Add("Three")
            romanlist.Add("Four")
        
            pdfDoc.Add(New Paragraph("RomanList"))
            pdfDoc.Add(romanlist)


            pdfDoc.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
       
    End Sub
End Class










Visual Basic .NET - iTextSharp creation of a pdf from a list

Generating PDF using ItextSharp

iTextSharp continued: lists, lines, pdf

checkbox list to itextsharp list

Tutorials on creating PDF files using Visual Basic .NET

Create PDF Files on fly in Visual Basic .NET sample code

creating pdf file in Visual Basic .NET

create pdf file from vb.net - MSDN - Microsoft‎

How to create PDF file on Visual Basic .NET or may be you know some

creating a pdf file with Visual Basic .NET - MSDN - Microsoft‎

Create Simple PDF File usingVisual Basic .NET

How to create PDF file in C#.Net  Open Source PDF Libraries in vb.net

Creating pdf files at runtime inVisual Basic .NET

.NET PDF Component - Create Convert PDF Files in Visual Basic .NET

Searches related to create pdf file c# create doc fileVisual Basic .NET create pdf file java create html c# c# itextsharp create pdf create pdf asp.net c# using itextsharp itextsharp tutorial c# itextsharp text to pdf

Visual Basic .NET Tutorial 48 - How to create Lists with iTextSharp PDF ...





Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Public Class Form1


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            Dim pdfDoc As New Document()
            Dim pdfWrite As PdfWriter =
            PdfWriter.GetInstance(pdfDoc,
                                  New FileStream("Simple.pdf", FileMode.Create))
            pdfDoc.Open()
            pdfDoc.Add(New Paragraph("Hello World"))

            Dim list As New List(list.UNORDERED)
            list.IndentationLeft = 30.0F
            list.Add(New ListItem("One"))

            list.Add("Two")
            list.Add("Three")
            list.Add("Four")
            list.Add("Five")
            'pdfDoc.Add(New Paragraph("List"))
            'pdfDoc.Add(list)

            Dim romanlist As New RomanList(True, 20)
            romanlist.IndentationLeft = 30.0F
            romanlist.Add(New ListItem("One"))

            romanlist.Add("Two")
            romanlist.Add("List")
            romanlist.Add(list)
            romanlist.Add("Three")
            romanlist.Add("Four")
        
            pdfDoc.Add(New Paragraph("RomanList"))
            pdfDoc.Add(romanlist)


            pdfDoc.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
       
    End Sub
End Class










Visual Basic .NET - iTextSharp creation of a pdf from a list

Generating PDF using ItextSharp

iTextSharp continued: lists, lines, pdf

checkbox list to itextsharp list

Tutorials on creating PDF files using Visual Basic .NET

Create PDF Files on fly in Visual Basic .NET sample code

creating pdf file in Visual Basic .NET

create pdf file from vb.net - MSDN - Microsoft‎

How to create PDF file on Visual Basic .NET or may be you know some

creating a pdf file with Visual Basic .NET - MSDN - Microsoft‎

Create Simple PDF File usingVisual Basic .NET

How to create PDF file in C#.Net  Open Source PDF Libraries in vb.net

Creating pdf files at runtime inVisual Basic .NET

.NET PDF Component - Create Convert PDF Files in Visual Basic .NET

Searches related to create pdf file c# create doc fileVisual Basic .NET create pdf file java create html c# c# itextsharp create pdf create pdf asp.net c# using itextsharp itextsharp tutorial c# itextsharp text to pdf

Wednesday, April 2, 2014

Visual Basic .NET Tutorial 47 - iTextSharp : How to create PDF file in ...







Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Public Class Form1


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button_CREATE_PDF.Click
        Dim pdfDoc As New Document()
        Dim pdfWrite As PdfWriter = PdfWriter.GetInstance(pdfDoc, New FileStream("Simple.pdf", FileMode.Create))

        pdfDoc.Open()
        pdfDoc.Add(New Paragraph("Hello World"))
        pdfDoc.NewPage()
        pdfDoc.Add(New Paragraph("Hello World Again"))
        pdfDoc.Close()
    End Sub
End Class






---------------------------------------------------------------------------------

Tutorials on creating PDF files using VB:NET

Create PDF Files on fly in VB:NET sample code

creating pdf file in VB:NET

create pdf file from VB:NET.net - MSDN - Microsoft‎

How to create PDF file on C# or may be you know some

creating a pdf file with Visual Basic .NET  - MSDN - Microsoft‎

Create Simple PDF File using Visual Basic .NET

How to create PDF file in Visual Basic .NET .Net  Open Source PDF Libraries in C#

Creating pdf files at runtime in Visual Basic .NET

.NET PDF Component - Create Convert PDF Files in Visual Basic .NET

Searches related to create pdf file c# create doc file c# create pdf file java create html c# c# itextsharp create pdf create pdf asp.net c# using itextsharp itextsharp tutorial c# itextsharp text to pdf

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Stuff I use to make videos

Windows notebook - http://amzn.to/2ADOPrW

Apple MacBook Pro - http://amzn.to/2AC0WG2

Microphone - http://amzn.to/2AC1kV0

notebook mouse - http://amzn.to/2BmeZ2d