Click here to Skip to main content
14,661,630 members
Home » Discussions » Database
   

Database

 
GeneralRe: Buying of referrals Pin
Member 1357942916-Dec-17 2:41
MemberMember 1357942916-Dec-17 2:41 
GeneralRe: Buying of referrals Pin
OriginalGriff16-Dec-17 2:43
mveOriginalGriff16-Dec-17 2:43 
QuestionSybase query returns blank/empty for char fields Pin
Member 1354244115-Dec-17 6:56
MemberMember 1354244115-Dec-17 6:56 
AnswerRe: Sybase query returns blank/empty for char fields Pin
jschell16-Dec-17 9:06
Memberjschell16-Dec-17 9:06 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244117-Dec-17 1:33
MemberMember 1354244117-Dec-17 1:33 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244119-Dec-17 13:36
MemberMember 1354244119-Dec-17 13:36 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244121-Dec-17 14:09
MemberMember 1354244121-Dec-17 14:09 
QuestionNeed a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 3:27
MemberSchudi12-Dec-17 3:27 
First please excuse my bad english. As you can asume it's not my native language....


I'm using SQL Server Compact Edition and Visual Basic 2015 and i did a few programs with SQL-Databas-Access so far.

This programs where quite simple. They read the whole table at the beginning into a Dataset, work with this and write it back when the application is closed.

Now i need some more secure access and found some information that it's better to cut the database Acces from the gui and the business logic - all three called layer.

What i need or what i'm asking for is a small sample application with just one Database-Table - let's name it "Persons" with the fiels "Person-Id" (the key), "Person-Firstname", "Person-Lastname", "Person-DateOfBirth".

GUI should have separate fields for each of the given fields.

Acces should be Record by Record. (Input the Id, if exist show the related data in the gui, if not show empty fields, with a save button to change values / write the changes to tha database.)

Business logic may just check if the DateOfBirth is in a range from 1.1.1900 to 31.12.2099.

How should my class look like to build all three layers?


Maybe this is to much described in detail...

I just want to see a class representing all 3 layers to handle some persons data ...

Is this possible? Whould someone be so kind? This would help me so much in understanding!!!

Thank you very, very much!
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 5:35
mveRichard MacCutchan12-Dec-17 5:35 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 5:50
professionalNathan Minier12-Dec-17 5:50 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 6:22
MemberSchudi12-Dec-17 6:22 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 7:10
professionalNathan Minier12-Dec-17 7:10 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 8:01
mveRichard MacCutchan12-Dec-17 8:01 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 8:13
MemberSchudi12-Dec-17 8:13 
QuestionCTE Sub-Sort Pin
Stan Lake11-Dec-17 11:52
professionalStan Lake11-Dec-17 11:52 
AnswerRe: CTE Sub-Sort Pin
Richard Deeming12-Dec-17 1:56
mveRichard Deeming12-Dec-17 1:56 
GeneralRe: CTE Sub-Sort Pin
Stan Lake12-Dec-17 2:35
professionalStan Lake12-Dec-17 2:35 
GeneralRe: CTE Sub-Sort Pin
Mycroft Holmes12-Dec-17 12:45
professionalMycroft Holmes12-Dec-17 12:45 
QuestionTable Design Suggestion Pin
Manish K. Agarwal7-Dec-17 19:42
MemberManish K. Agarwal7-Dec-17 19:42 
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 1:33
professionalNathan Minier8-Dec-17 1:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 17:46
MemberManish K. Agarwal10-Dec-17 17:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 1:38
professionalNathan Minier11-Dec-17 1:38 
AnswerRe: Table Design Suggestion Pin
Richard Deeming8-Dec-17 1:35
mveRichard Deeming8-Dec-17 1:35 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 17:53
MemberManish K. Agarwal10-Dec-17 17:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 0:00
professionalMycroft Holmes9-Dec-17 0:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.