Connecting C# with MS Access DB

Connecting C# with MS Access DB - FullRowSelect: True...

Info iconThis preview shows pages 1–24. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to Connecting C#.net to MS Access Database Roland Fernandez
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Steps to create and connect an Access DB in C# Create Access database (e.g student/book)
Background image of page 2
Create Access database
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating .udl Open Notepad Save as filename.udl Change Save Type “ALL Files”
Background image of page 4
Creating .udl
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating .udl Double Click on Sample.udl Click Provider TAB, select Microsoft Jet 4.0 OLE DB (denoted by black arrow) then click next. Now click "Select or enter a database name" and select the desire database then click open.
Background image of page 6
Creating .udl
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating .udl Now click on test connection and click OK
Background image of page 8
Creating .udl Now edit this UDL file with note pad and copy link
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating the UI Now Open Visual Studio editor and create the User Interface.
Background image of page 10
Creating the UI Main Form Name: ADONET Start Position: Center Screen Text: ADO.NET Sample Size: 659,543 List View Name: listView Columns: Collection
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 14
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 16
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 18
Background image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 20
Background image of page 21

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 22
Background image of page 23

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 24
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: FullRowSelect: True Gridlines: True Groups: Collection Items: Collection Location: 15,34 Multiselect: False Creating the UI GroupBox Name: groupBox1 Location: 26,286 Text: Record Information Label Name: Label1 Text: ID: Name: Label2 Text: Title: Name: Label3 Text: Author: Name: Label4 Text: Copies: TextBox Name: id , title , author , copies Text: Creating the UI Button Name: add Text: Add Name: delete Text: Delete Name: edit Text: Edit Name: clear Text: Clear MenuStrip Name: menuStrip1 Code for the DB Connection Double click on the form and add some code Code for the DB Connection Constructor RefreshDbf() method: Code for listView Code for add button Code for delete button Code for clear button Code for edit button Code for Menu Code for about Code for exit About Form END!!!...
View Full Document

Page1 / 24

Connecting C# with MS Access DB - FullRowSelect: True...

This preview shows document pages 1 - 24. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online