Showing posts with label Visual Basic. Show all posts
Showing posts with label Visual Basic. Show all posts

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

Monday, March 31, 2014

Visual Basic .NET Tutorial 45 - How To Use DataGridView (Remove rows)





Private Sub REMOVE_ROW_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        If DataGridView1.SelectedRows.Count > 0 Then
            For i As Integer = DataGridView1.SelectedRows.Count - 1 To 0 Step -1
                DataGridView1.Rows.RemoveAt(DataGridView1.SelectedRows(i).Index)

            Next
        Else
            MessageBox.Show("No rows to select")
        End If

    End Sub










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

Searches related to how to use datagridview add row

vb datagridview add row

datagridview disable add row

datagridview select entire row

datagridview set selected row

datagridview scroll to selected row

datagridview selected row index

Searches related to how to use datagridview add row visual basic

visual basic net datagridview add row

visual basic 2010 datagridview add row

visual basic datagridview selected row index

datagridview select last row

datagridview select first row


Sunday, March 30, 2014

Visual Basic .NET Tutorial 44 - How To Use DataGridView (Adding rows)




































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

Searches related to how to use datagridview add row

vb datagridview add row

datagridview disable add row

datagridview select entire row

datagridview set selected row

datagridview scroll to selected row

datagridview selected row index

Searches related to how to use datagridview add row visual basic

visual basic net datagridview add row

visual basic 2010 datagridview add row

visual basic datagridview selected row index

datagridview select last row

datagridview select first row

MySQL VB.NET Tutorial 19 : How to use DateTimePicker and save date in D...

Sunday, March 23, 2014

MySQL VB.NET Tutorial 14 : Search data in database and Filter in datagri...





Private Sub Search_txt_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search_txt.TextChanged

        Dim DV As New DataView(dbDataSet)
        DV.RowFilter = String.Format("name Like '%{0}%'", Search_txt.Text)
        DataGridView1.DataSource = DV

    End Sub










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

Code for searching data from database using Visual Basic

Visual Basic Search in database VB.NET

how to search data in database in asp.net with Visual Basic VB.NET

how to search data with data grid in asp.net using Visual Basic VB.NET

how to make search in sql database in asp.net using Visual Basic

To Search The Data From Database Using Visual Basic.net(Visual Basic) VB.NET

Search as you type implementation in Visual Basicusing Sql Database

Visual Basic display data from database using sqlparameters VB.NET

Visual Basic - Displaying selected data in a datagridview VB.NET

Visual Basic - How to Display data in datagridview from access database VB.NET

updating data in database using datagridview Visual Basic

Datatable Search

Saturday, March 22, 2014

MySQL VB.NET Tutorial 9 : How to Link Combobox with Database values





Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader
        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "select *  from database.edata"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            While READER.Read
                Dim sName = READER.GetString("name")
                ComboBox1.Items.Add(sName)

            End While
            MysqlConn.Close()
        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()
        End Try

    End Sub














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

VB.Net: Filling a ComboBox with data stored in database

how to bind combobox to textbox in VB.NET

ComboBox and TextBox‎ VB.NET

How to show combo box selected value in a text box‎ VB.NET

selecting an item in combobox and display corresponding Populate combobox from  database VB.NET

How to get data in combobox from database?

Populating a Combobox from a Dictionary beginner

How to fill different ComboBoxes in a DataGridView  VB.NET

code add database column to datagridview combobox VB.NET

Populate combobox from database beginner

How to get data in combobox from database?

Populating a Combobox from a Dictionary Visual Basic

How to fill different ComboBoxes in a DataGridView

code add database column to datagridview combobox

Enter values into combobox from database‎ Visual Basic

Enter values into combobox from database‎ VB.NET

Retrive Data From Database Put Into A Combobox Visual Basic

Saving New Selection From Combobox To SQL Database

Set Datagridview Combobox Cell Value

Database Connections And Combo Boxes

Thursday, March 20, 2014

MySQL VB.NET Tutorial 8 : Deleting selected data from database





Private Sub Button_Delete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query ="Delete from database.edata where eid='" & TextBox_Eid.text &"'"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader

            MessageBox.Show("Data Deleted")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub














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

mysql - How to delete data from database by using Visual Visual VB.NET 2010 2011 2012 2013 visual studio tutorial best beginners

Delete Data from MySQL Database using Visual VB.NET Windows Forms Application Visual basic

Delete one or more records from a database Visual basic VB.NET

Delete data from Database Visual basic VB.NET

Update and Delete data in database using Visual basic C#

Deleting Data from an SQL Table Visual basic VB.NET






MySQL VB.NET Tutorial 8 : Deleting selected data from database





Private Sub Button_Delete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query ="Delete from database.edata where eid='" & TextBox_Eid.text &"'"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader

            MessageBox.Show("Data Deleted")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub














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

mysql - How to delete data from database by using Visual Visual VB.NET 2010 2011 2012 2013 visual studio tutorial best beginners

Delete Data from MySQL Database using Visual VB.NET Windows Forms Application Visual basic

Delete one or more records from a database Visual basic VB.NET

Delete data from Database Visual basic VB.NET

Update and Delete data in database using Visual basic C#

Deleting Data from an SQL Table Visual basic VB.NET






Monday, March 17, 2014

MySQL VB.NET Tutorial 6 : Insert/Save data to database






Imports MySql.Data.MySqlClient
Public Class Form2
    Dim MysqlConn As MySqlConnection
    Dim COMMAND As MySqlCommand
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Form1.Show()
        Me.Hide()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "insert into database.edata (eid,name,surname,age) values ('" & TextBox_Eid.Text & "','" & TextBox_Name.Text & "','" & TextBox_SName.Text & "','" & TextBox_Age.Text & "')"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader

            MessageBox.Show("Data Saved")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub
End Class


















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

How to: Insert New Records into a Database

Database Access with Visual VB.NET.NET

sql server - Insert Data into database in VB.NET

How to insert Data to Ms SQL server 2008 using VB.NET.net

.net - VB.NET insert data into SQL table

Using Visual VB.NET and SQL cannot insert data into table..‎

VB.NET import data from text file into sql databse line by line‎

store xml in SQL Server 2008 from VB.NET‎

Using SQL in VB.NET - Cannot insert data into SQL table

visual VB.NET - Could not Insert the data using V VB.NET in MYSQl

Add, save & retrieve data in SQL

insert data in sql 2005 from excel file through VB.NET asp.net‎

insert data into SQL table from pre filled boxes in VB.NET 4.0‎

insert into database unsing ado.net and VB.NET Visual Basic

Insert DateTime into SQL Server using VB.NET Visual Basic

Searches related to VB.NET insert data into sql Visual Basic

VB.NET insert data into sql table Visual Basic

VB.NET insert data into sql server Visual Basic

inserting data into sql table Visual Basic

insert query  VB.NET

sql insert statement from another table

Sunday, March 16, 2014

MySQL VB.NET Tutorial 5 : How To Open A Second Form using First Form + s...























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

Calling form1 from form2 in Visual VB.NET .Net‎

Cannot Show Another Form in Visual VB.NET

VB.NET Multiple Forms in WinForms‎

Hiding and showing forms in VB.NET‎

VB.NET Window Forms - Get item selected in listbox on 1 form

VB.NET -Changing the text of a label on another Form- VB.NET

windows forms show/hide eachother‎ . VB.NET - Can't open a different form visual basic

Opening A Second Form In Visual VB.NET 2008‎

Searches related to open form visual VB.NET

visual VB.NET load form Display One Form from Another

form show visual C# How to load another windows forms using VB.NET?

visual studio open file Cannot Show a New Form (aboutBox) in VB.NET

MySQL VB.NET Tutorial 4 : Password Protection using Textbox



























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

Searches related to visual VB.NET password textbox

visual VB.NET textbox auslesen

visual VB.NET textbox example

How to: Create a Password Text Box with the Windows Forms TextBox Control

visual VB.NET textbox to string

visual studio textbox Display bullet as password character in visual VB.NET

visual studio 2010 - how to create password field and button in vVB.NET

visual VB.NET textbox problem VB.NET - Protect

visual VB.NET textbox C# password TextBox

textbox asp VB.NET - Quick password protection

How to: Create a Password Text Box with the Windows Forms

VB.NET Password Textbox - Visual VB.NET

show password in the textbox with textmode password

Get input from password textbox : Password

MySQL VB.NET Tutorial 3 : Create Login Form with MySql and VB.NET (Part 2)






Imports MySql.Data.MySqlClient

Public Class Form1
    Dim MysqlConn As MySqlConnection
    Dim COMMAND As MySqlCommand




    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"

        Try
            MysqlConn.Open()
            MessageBox.Show("Connection Successful")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try

    End Sub

    Private Sub Login_Btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login_Btn.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "select * from database.edata where user_name='" & TextBox_UN.Text & "' and password='" & TextBox_Pass.Text & "' "
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            Dim count As Integer
            count = 0
            While READER.Read
                count = count + 1

            End While

            If count = 1 Then
                MessageBox.Show("Username and password are correct")
            ElseIf count > 1 Then
                MessageBox.Show("Username and password are Duplicate")
            Else
                MessageBox.Show("Username and password are not correct")

            End If


            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub
End Class

MySQL VB.NET Tutorial 2 : Create Login Form with MySql and VB.NET (Part 1)






Imports MySql.Data.MySqlClient

Public Class Form1
    Dim MysqlConn As MySqlConnection
    Dim COMMAND As MySqlCommand




    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"

        Try
            MysqlConn.Open()
            MessageBox.Show("Connection Successful")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try

    End Sub

    Private Sub Login_Btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login_Btn.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "select * from database.edata where user_name='" & TextBox_UN.Text & "' and password='" & TextBox_Pass.Text & "' "
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            Dim count As Integer
            count = 0
            While READER.Read
                count = count + 1

            End While

            If count = 1 Then
                MessageBox.Show("Username and password are correct")
            ElseIf count > 1 Then
                MessageBox.Show("Username and password are Duplicate")
            Else
                MessageBox.Show("Username and password are not correct")

            End If


            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub
End Class














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

Login Program for VB.NET with Mysql

Visual VB.NET - Login Form Tutorial

VB.NET - How can I close a login form and show the main form

Login Form using VB.NET and SQL

VB.NET Login Form with MS Access

Login Form using c# and ms access as database..?‎

closing Login form after a successful Login in VB.NET form‎

create a login form using VB.NET‎

VB.NET program to connect to mysql

php login code mysql

Login Source Codes

Code for login form in VB.NET

VB.NET Login form Searches related to c# login form

java login form Visual basic

visual basic login form Visual basic

visual studio login form Visual basic

c# login form template Visual basic

c# login form access database Visual basic

c# login form example Visual basic

c# login form code Visual basic

c# login form sql Visual basic

create login page contain user id,password,buttons  Visual basic

mysql C# sample codeVisual basic
















IT Certification Category (English)640x480

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Top Online Courses From ProgrammingKnowledge

Python Course http://bit.ly/2vsuMaS
Java Coursehttp://bit.ly/2GEfQMf
Bash Coursehttp://bit.ly/2DBVF0C
Linux Coursehttp://bit.ly/2IXuil0
C Course http://bit.ly/2GQCiD1
C++ Coursehttp://bit.ly/2V4oEVJ
PHP Coursehttp://bit.ly/2XP71WH
Android Coursehttp://bit.ly/2UHih5H
C# Coursehttp://bit.ly/2Vr7HEl
JavaFx Coursehttp://bit.ly/2XMvZWA
NodeJs Coursehttp://bit.ly/2GPg7gA
Jenkins Course http://bit.ly/2Wd4l4W
Scala Coursehttp://bit.ly/2PysyA4
Bootstrap Coursehttp://bit.ly/2DFQ2yC
MongoDB Coursehttp://bit.ly/2LaCJfP
QT C++ GUI Coursehttp://bit.ly/2vwqHSZ