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