Visual Basic Online Courses DataGridView Add Edit Delete

-

Manipulate DataGridView from Visual Basic 2010 with SQL Server

DataGridView Add, Edit, Delete From Database
Visual Basic Online Course - DataGridView SQL Server Database
Note : if you dunno how to work SqlServer With VB.Net : You need to see this then this

Logic

Using DataGridView Control In VB.Net to Add New - Edit - Delete from/to Sql Server Database or MS-Access or any other Database type. You will find in the end of the lessons the project to download along with source code . 

Design

1) Create a new Visual Basic project (Windows Application) name it as (MyDg1) and save it to your hard drive.
2) Place a DataGridView Control on the Form1.
3) Create Sql Server Database file, name it (MyDB)
4) Create Table, name it (Kinds) with just one record, name it (Kinds)
5) Rename the DataGridView Control's name From (DataGridView1) to (DG1)
6) Save/Build the project .
7) Now you have : A project such as this one in the 3 photos (from inside VB.Net and from Outside)




Visual Basic Online Courses
vb.net DataGridView Project From Inside VB.Net 2005
Visual Basic Courses Online
DataBase (MyDB) & Table (Kinds) From Inside SqlServer
Courses of Visual Basic online
Project Folder on DeskTop With DataBase Inside

- What do we want to do ?!!!!

we want to update the database (MyDB) Table (Kinds) Record (Kind) using DataGridView (DG1) From MS Visual Basic .Net 2005 on WinXpSp2 Home Edition ........ ahahahaha ok?!!

We will use NO buttons, we will only use DG1 Events :

1) For Adding New Record : you type in the cell in the dg1 and hit Enter Key
2) For Editing : you Edit a cell that already have been saved and hit enter
3) For Deleting : you Select a cell in the DG1 and you hit Delete key in the keyboard .


* Of course you can not add Empty Values because we have the record (Kind) is Primary Key (PK) .
* You can not Delete the (New DG1 Row) ...
All you have to do now is to open the Form1 Code and Clear all lines using (Ctrl+A) and (BackSpace) then Save Project (Ctrl+S) then Paste (Ctrl+V) these blocks of Codes :

Codes above works 100% just create the database and the table and the record successfully,


Popular posts from this blog

Visual Basic 2010 Working With DataBase Full Project Example

-
Image
VB 2010 Book
Working With Database Full Project Example Book Link via MediaFire.com The book is 5 chapters and is explained here, it contains source code of a project example on how to work with Microsoft Access Database from Visual Basic 2010.
    In the book; the photos show how to start your project, how to select your database and how to display it. Here, we'll discuss each photo and explain each code block.
Chapter#1 - Released
VB .Net 2010 Working With DataBase Full Project Example

Photo (1) : Shows the folder that contains the project, the (My-First-Con.vbproj) is the icon you need to click to open the project.

Photo (2) : From menu (Data) choose (Add New Data Source), a popup dialog-box will show titled (Choose a Data Source Type) and you select (Database) as long as we are connecting to one, then click next.

Photo (3) : A popup dialog-box appears titled (Data Source Configuration) and you select (DataSet). The DataSet is the connection type we are trying to establish here,…
Continue Reading >>

Visual Basic 2010 - Button Sound / Music Play

-
Image
Visual Basic 2010 - Button SoundThe code is simply goes like this You can copy and paste in your (Click_Event) or whatever it is you wish (MouseClick - MouseHover - MouseLeave) :

Dim MySound AsNew System.Media.SoundPlayer()  MySound.SoundLocation = "path to the .Wav file"MySound.Load()MySound.Play()' OR you can use this :Sub PlaySystemSound()My.Computer.Audio.PlaySystemSound(
System.Media.SystemSounds.Asterisk)End Sub
Background playing It lets the application execute other code while the sound plays. The My.Computer.Audio.Play method allows the application to play only one background sound at a time; when the application plays a new background sound, it stops playing the previous background sound. You can also play a sound and wait for it to complete.
For Visual Basic 2010 and in general, when an application plays a looping sound, it should eventually stop the sound. For more information, see How to: Stop Playing Sounds in the Background in Visual Basic 2010. Example The …
Continue Reading >>