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
 |
| 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)
 |
| vb.net DataGridView Project From Inside VB.Net 2005 |
 |
DataBase (MyDB) & Table (Kinds) From Inside SqlServer
|
 |
| 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,
 |
| vb.net Datagridview source code download |
The example tested with vb2010
Download Full Example : MediaFire.com Link
♥ Here are some online Visual Basic lessons and courses :
Popular posts from this blog
Your next great app. Your way. From interactive Desktop applications, to immerse Web and Mobile solutions, tools to meet your needs today and ensure your continued success tomorrow. DevExpressis a very powerful tool for
Microsoft Visual Studio 2010 and any Visual Studio starting VS2005 until VS2012. From the above 4Shared.com Widget you can download DevExpress 12.2.4 freely, the uploaded files contain the registration for free Dll
leaked [dxv2_regaddin.12.2.4]. The download should be merged in one folder and the 3 parts of Dxperience should be all downloaded and extracted [Merged] in the same folder.
After downloading
♦ Extract the 3 files :
♠ Devexpress-12.2.4-by-evry1.net.part1.rar ♠ DevExpress-12.2.4-by-evry1.net.part2.rar♠ DevExpress-12.2.4-by-evry1.net.part3.rar
into one folder, you will find 2 files after extraction [DevExpress 12.2.4 and dxv2_regaddin.12.2.4].
♦ Double-click the Devexpress 12.2.4 exe file and install Dxperience 12.2.4, you may also choose [Trial Version] fo…
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Visual Basic 2010 Error Message :InvalidOperationException was unhandled" The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"
This error message means that the machine [Computer, Laptop] that you are trying to run your application on, doesn't have
MS-Access 2007 installed, or not installed properly. Some developers just pack their applications and send it to the client :
Relying on - that the client have MS-Office 2007/2010 installed already and won't never crash or updated to 2010, Or they just did not include the proper component along with their package, Or even worse they may not know what exactly should they do to make it work on the client's machine.
╚Ž╣ To get this error message to go away, you need to include this file in your package : 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies
Some think that Office 2007 should be in…
Visual Basic 2010 - Compare Two Strings and return differences and matchesCollections as an Alternative to Arrays
Visual Studio 2010 Although collections are most often used for working with the
Object Data Type, you can use a collection to work with any data type. In some circumstances, it can be more efficient to store items in a collection than in an array.
If you need to change the size of an array, you must use the
ReDim Statement (Visual Basic). When you do this, Visual Basic creates a new array and releases the previous array for disposal. This takes execution time. Therefore, if the number of items you are working with changes frequently, or you cannot predict the maximum number of items you need, you might obtain better performance using a collection.
A collection, which does not have to create a new object or copy existing elements, can handle resizing in less execution time than an array, which has to use ReDim. But if the size does not change, or chang…
VB .NET DropBox Api Example
Create a Desktop Application using VB .NET and Dropbox Api
RequirementsVisual Basic 2010 [recommended VS 2015] or above (Visual Studio 2019) from
here
Visual Basic previous Example from
here
Dropbox Account from
here
.NET Framework 4.0 or above for above VS versions.
Dropbox Api for current .NET Framework version of yours
Open VB 2015 Project in VB 2019
Can I open / migrate
Visual Basic 2015 Project Source Code with Visual Basic 2019 ? The answer is Yes, if you want to more details about VB 2015 to VB 2019 migration, please
read Project descriptionI will use the
VB.NET example from previous post to add a functionality to it. I will add Backup Database to Dropbox [ToolStripMenuItem]
When a user press [ToolStripMenuItem -> Backup to Dropbox] : The VB.NET application does the following :
Checks for Internet Connection Status.Connects to Dropbox Application created in
Dropbox developer section [App Console].Uploads the Microsoft Access 2007 (*.accdb) Database fi…
