For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?
Thanks for any feedback.
View Complete Post
Hello to forums :)
I have a simple question on design.
A company has several 'Worklocations'. Each location employs several workers. Every worker can be associated with multiple locations.
So, I have decided to create below tables. please letme know if there is a better way to design it
workerlocations (WID+LID => primary key)
Is this sounds right for you guys? let me know
This is my scenario: I have 4 tables in my database at the moment. One of the tables contains all my users, each of which have a unique id(integer). One table contains the names and descriptions of certain lists of users so for example a row would be
table name: Lists
12 | Example List | short description of the list
A third table contains the ID's of users that are in a given list:
table name: ListUsers
12 | 213
12 | 192
12 | 84
My final table is filled with certain "events" I am holding that users on a list are invited to. (there are more fields in this table but they are not important).
table name: Events
I am creating a very high level relational database diagram for attendance and payroll system.
so far I have taken these table into account .
....I am confuse in salary process how to store details related to that...and with which tables it would have relations.Here I want salary process to be done and also payslip has to be generated.
Thanks In Advance.
Currently i doing dental appointment website for my lessons, and i having problem in database design. The major of the database is for appointment booking and view information.
Admin doing the registration for patient, admin, dentist.
Patient login > view dentist > view appointment > make appointment or view treatment comment
Dentist login > insert patient treatment comment / view appointment
Admin > view appointment > Delete appointment and others stuff like report
While creating the dental user table, should i include the dentist into dental user table?Should i create 1 more table for registration ?
I having problem in linking all the table ..Kindly if you could help me in giving suggestion / ideas. Thank you.
Dentist ID (Primary Key)
Dentist Contact Number
Dentist Job Description
Appointment ID (Primary Key)
Dentist ID (Foregin Key)
Dental User Table
Identification Card Numner
Hi all, I'm having this problem....
Scenario: C# 2010, WPF, SQL Compact 3.5 SP2.
I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime.
As soon as I open the window with the wpf editor I got the error (translating from Italian):
"Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]"
Now, in settings and app.config I have the connection string which is something like
I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok.
Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error....