Author

Ahmed Samir

Evry1falls is my online name

Visual Basic Online Courses DataGridView Add Edit Delete

Visual Basic Online Courses DataGridView Add Edit Delete 5 of 5

VB .NET 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,


Comment Via facebook

Popular posts from this blog

Visual Basic Online Course DevExpress 12.2.4 full for Visual Studio 2010

Visual Basic Online Course - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

VB .NET Google Drive Api Source Code Example

Visual Basic Compare Two Treeviews and return differences

VB .NET DropBox Api Source Code Example