datagridview sample code

Updating an access table using datagridview

Page 1 of 1

1 Replies - 11457 Views - Last Post: 04 March 2009 - 04:47 AM Rate Topic: -----

#1 osgen  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 5
  • Joined: 28-November 07

datagridview sample code

Posted 04 March 2009 - 04:14 AM

I am a beginner in VB.Net programming. Can you please show me how to Add, edit and delete an access table using datagridview controls? thank you.
Is This A Good Question/Topic? 1
  • +

Replies To: datagridview sample code

#2 sakhr_99  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 42
  • Joined: 01-March 09

Re: datagridview sample code

Posted 04 March 2009 - 04:47 AM

For this there are penalty of solutions but you need to search using Google
and one more thing i highly recommend you not to use Access but instead use SQL-SERVER or Oracle because of many reasons beside security , manageability and a lot more .

but for SQL-SERVER you are advised to know some basics of SQL i.e
Structured Query Language such as DDL ,DML i.e. Data Definition Language --- Data Manipulation Language and Select statement
for this use very basic syntaxes
examples are :

1- Create a table -Syntax in SQLSERVER -: under SQLSERVER write :

Create Table Demo
(
DemoID int
)



2 - then insert some value using INSERT statement :
Insert into demo (1)
insert into demo (2)


3 - Select any value in Demo Table using Select Statement :

select * from Demo ;

here * indicates all fields in Demo Table


any help i would be at your service
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1