INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 2

Показать описание

Please refer to the link to get source code:

Рекомендации по теме

Комментарии

Setha,
I had already fixed the date of admission. It has worked accurately now

Thanks really for your tutor

ohisio

I don't know if it is just me.

Yes, the data source, well except for the DELETE and EDIT Button, well probably because it's not declared using selectedindex.
Well enough of that, what I want to ask is that, well yes it works but it doesn't actually save the data from the database, it only displays the save data from the actual grid inside the form, but not really on the data base files.

Is it just me?

LichKing

You Sir are a boss! May only good things come in your life.

Cheers.

casiocruiser

hi, hey, when you used in the first minute Me.dgvData.Rows.Count > 0. Where did you declare dgvData? I can't understand from where come.

daciocco

Thank you, your so specific in coding thats why I liked,
I add if isnumeric(txtstudetID.text) in add so it wont crush if the id has / or - and the only problem is the unique keys if its duplicate well we can put yes to duplicate in database

stephencabreros

Setha, it has already worked after downloding the source codes. Thank you !.

ohisio

i did :) I boxed the column names like this: [column1], [column2] etc. It was to do with some of the columns having 'reserved' names, the boxing of the columns seemed to clear the error :D

iDrumxx

hi. please arrange this code because it add records at first but when you click edit then update and then add new record again, it keeps on overwriting the previous row. it doesn't add new row.

telleme

Thank you so much for getting back. Keep up the good work, Bless!

djitobigD

Hi
How do you solve "Syntax error in UPDATE Statement" when my update button is in a form which is in a relationship with another form in access database as I have 2 tables with the same titles as the said forms. E.g. ClientEntry <---> Bill
When the error shows up. The ExecuteNonQuery line is highlighted in yellow.
Anyone's help would be much appreciated.

adrianblade

I got a error that was unhandled: "The 'Microsoft.Jet.Oledb.4.0' provider is not registered on the local machine.

djitobigD

Hello! I am getting this problem "The INSERT INTO statement contains the following unknown field name: 'stdid'. Make sure you have typed the name correctly, and try the operation again."

Why is this happening? I copied almost everything in this video.... :/

kelba

i can not use Delete & Edit
Can you help me???
when i click them,
error.
Column named snv cannot be found. Parameter name: columnName
and this row "yellow"-->Dim intSnv As Integer =

plz

KBUlifecom

im getting this error
A first chance exception of type 'System.ArgumentException' occurred in System.Data.dll
A first chance exception of type occurred in System.Data.dll
A first chance exception of type 'System.ArgumentException' occurred in System.Data.dll

I.n-s

im stuck on 5:07 so far everything is perfect except the updating part. i followed it accordingly but just used my fields instead. i have the exact layout on point but i keep getting the error : Operand '&' is not defined for types 'String' and 'System.Windows.Forms.Text box'. Another error i got is :SelectedRows' is not a member of If someone out there knows how to fix this pls help

iRoNiiC_HR

Hey dude, i got everything fine but u didn't show working of edit and delete button at the end of the video can u please help me with that, i really could't get it and have error on counting of datagridview selected rows ..!!!

BEWAEK

Hi Setha,
it shows me an error when i compile under the private sub refreshData(), highlighting the da.Fill(dt) below is the error
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Can you help please ?.

ohisio

i have error in da.Fill(dt) it says "No value given for one or more required parameters.".. how to fix it?

rayacebedo

hey how about the delete button ??
when i delete 1 record all record was deleted ?? -_-

arjayquintos

sir i want to save image on acces what will be the code for that, your code only work only for text and int .?

SuperStrahan

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 2

SQL Query Basics: Insert, Select, Update, and Delete

COMO USAR INSERT , UPDATE ,DELETE E SELECT NO SQL PASSO A PASSO

SQL Commands SELECT INSERT UPDATE DELETE on SQL Server

Comandos fundamentais do SQL: SELECT, UPDATE, INSERT E DELETE - Root #13

Microsoft SQL Server Management Studio Part 6 - INSERT UPDATE DELETE SELECT

Einführung in MySQL. SELECT, UPDATE, INSERT und DELETE schnell erklärt | SQL Tutorial Deutsch

C# SQL Database(SELECT,INSERT,DELETE,UPDATE) 1080p

SQL Insert, Update, & Delete

𝐏𝐑𝐎𝐉𝐄𝐂𝐓 𝐒𝐔𝐁𝐌𝐈𝐒𝐒𝐈𝐎𝐍 𝐓𝐑𝐀𝐂𝐊𝐄𝐑 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥...

SQL Server INSERT, UPDATE, DELETE

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 1

How to create Table,Insert,Update,Delete in SQL Server very easy steps

C# Application - Insert Delete Update Select in SQL Server | FoxLearn

ASP.NET and SQL Server- How to Insert, Delete and Update(CRUD operation) ?

C# Application - Insert Delete Update Select in MS Access Database | FoxLearn

Complete CRUD Operation in C# With SQL | Insert Delete Update Search in SQL using ConnectionString

phpMyAdmin select, insert, update, and delete.

Select Insert Update Delete Using Stored Procedure in Oracle

SQL Tutorial 3 | Create Database, Table, Insert, Update and Delete in a simple way

4. What is Data Manipulation Language in SQL? Using SELECT, INSERT, UPDATE, DELETE commands in MySQL

SQL Commands | Select, Create, Alter, Drop, Truncate, Rename, Insert, Update, Delete etc

SQL Basic Queries | Create, Insert Into, Update, Delete, Drop, Alter & Select

Operasi SELECT, INSERT, UPDATE, DELETE pada Database menggunakan XAMPP

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 2