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...

Thursday, March 27, 2014

MySQL VB.NET Tutorial 16 : How to Link Chart /Graph with Database





Private Sub LOAD_CHART_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LOAD_CHART.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"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            While READER.Read
                Chart1.Series("NAME_VS_AGE").Points.AddXY(READER.GetString("name"), READER.GetInt32("age"))

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














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

Creating graph in Windows Forms Application Mysql vb.net

Data Binding a Chart to a Database visual basic

Line chart in c# using data from database

 - Graph database for vb.NET

How to Create Excel graphs using vb Program

Creating graphs using visual studio

Graph And Sql Data - C# Programming

Using Chart Control in Visual Studio 2010 C beginners

Creating graph in Windows Forms Application

Charts in SQL Server Reporting Mysql

Threaded plotting in Visual Studio visual basic with Windows Forms vb.net Windows Forms application

How to reload a fastline chart using Windows.Forms

Windows Charting Application

Learn the Windows Forms Chart Control

How do I plot data on a Chart in a CLR Form in C#?‎ Mysql

how to draw line graph in .net?‎ Mysql

Plot with visual studio C# express‎  Mysql

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
















MySQL VB.NET Tutorial 1 : Getting Started and Mysql database Connection















Imports MySql.Data.MySqlClient

Public Class Form1
    Dim MysqlConn As MySqlConnection

    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
End Class










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

Using MySQL Database with Visual Basic .NET 2010

MySQL :: MySQL for Visual Studio

How to connect to MySQL database from Visual Basic

Vb Connecting to an online mysql server database

Connecting to MySQL databases using VB.NET

VB.Net MySQL Database Tutorial

VB.NETWindows Form Application Mysql Connection

VB.NET- How can I connect to MySQL from windows forms?

Using Visual VB.NET Windows Forms with MySQL

VB.NET Programming for beginners: How to connect MySQL Database

Windows Form Application using Mysql Server

Connect MySQL from VB.NET Windows Forms

mysql problem to connect with windows form VB.NET

VB.NET Windows Form Application Mysql Connection

Mysql And Visual VB.NET 2010 Windows Form Application

MySQL :: Connecting to MySQL with a Windows Form application

VB.NET Form textbox string into SQL Database

visual VB.NET CLR windows form application and mysql

assembly reference not working in VB.NET script

Trying to connect to MySQL from VB.NET application

mysql and VB.NET window form application

How to connect MySQL using VB.NET?‎


Tuesday, March 11, 2014

Visual Basic .NET Tutorial 41 - How to use the WebBrowser control in Vis...





Public Class Form1

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        WebBrowser1.Navigate(TextBox1.Text)

    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        WebBrowser1.GoForward()

    End Sub

    Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        WebBrowser1.GoBack()

    End Sub

    Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
        WebBrowser1.Refresh()

    End Sub

    Private Sub WebBrowser1_Navigated(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserNavigatedEventArgs) Handles WebBrowser1.Navigated
        TextBox1.Text = WebBrowser1.Url.ToString()


    End Sub
End Class










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

Using The WebBrowser Control As A Document Viewer

Question: How To Use WebBrowser Control - VB.NET

WebBrowser Control (VB.NET) new tab

visual studio 2010 - VB.NET WebBrowser control

How to Automate Web Browser using VB.NET

Opening A File Using Web Browser Control? - VB.NET

Force Webbrowser Control To Scroll Left/down - VB.NET

Creating A Web Browser In VB.Net - VB.NET Tutorials


Saturday, March 8, 2014

Visual Basic .NET Tutorial 40 - How to use DateTimePicker Control and Fo...


























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

Searches related to datetimepicker visual basic

visual basic max datetimepicker

visual basic datetimepicker help

datetimepicker 31 days

have datetimepicker

visual basic datetimepicker format

visual basic date time picker

Learn how to use the DateTimePicker control in VB.NET

How To Sum The Total Value In Textbox Field Using

Vb.net How To Use A Date-time Picker In An Inputbox

How To Increment The Month In Datetimepicker Using

Date Time Picker - How Can I Choose BOTH A Date

VB.NET Format Date for Datetimepicker

VB.Net DateTimePicker Control

Visual Basic .NET Tutorial 39 - How to make a Random Number Generator wi...













Public Class Form1


    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim rn As New Random
        MessageBox.Show(rn.Next(1000, 10000))

    End Sub
End Class





--------------------------------
Random Number Generator. - VB.NET 
RND To Generate Random Numbers.Visual Basic .NET 
Random Numbers - VB.NET Tutorials
VB6 Random Number Generator Issue -Visual Basic .NET 
Generate Random Numbers - Visual Basic .NET 
Visual Basic Random Number Generator
Searches related to random number generator in visual basic
random number generator in visual basic 2010
make random number generator
random number generator visual basic 2010
visual basic 6.0 random number generator
visual basic 2008 random number generator
visual basic random number between 1 and 4
vb.net random number generator
vb.net random number between 1 and 100