.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

database interface design question

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net
 

For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.




View Complete Post


More Related Resource Links

Worker & Location Database design question

  

Hello to forums :)

Hi,

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

worker table
wid (primary)
fullname

location table
lid (primary)
Name

workerlocations (WID+LID => primary key)
WID
LID

Is this sounds right for you guys? let me know


Database Design Question

  

Hi everyone,

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

 ID_____LISTNAME__________DESCRIPTION_______

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

LISTID_____USERID___

 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

ID_______EVENTNAME_______LISTID_

Database CurrentUser Question

  
I am trying to check whether the user connected to a database is db_ownder so I am using the IsDbOwner property on the database object that was created from the Server object but it is setting the UserName to guest as opposed to the user connecting - any ideas? Thanks Scott

Detach/Attach database question

  
I recently restored a database from SQL7 to SQL2005.  When restoring the database I needed to create a c:\data\data folder or else it would not restore the mdf and ldf files. I would like to move these files to a new location.  Copied the the two files to a new folder, C:\database.  Using the sql studio manager, preformed a task to detach the database, then attach the database with the new location. This seemed to work, I am able to access my application that uses this database.  However, any changes I make to the program, are not writing changes back to the mdf file.  When I open the program, these changes are still in place, but the mdf file should be updated, correct?  When the database files were stored in the c:\data\data folder, any little change I made to the program changed the modified time for the mdf file. Is there something missing or where could these changes be written to?

I need a workflow triggered by a workflow...how do I design this? Beginner question

  
I've added the Approval workflow to a forms library and it generates the necessary tasks and emails for 2 levels (serial) of Approval on the form. When the form has been approved the 2nd time, I want it to trigger another workflow that notifies a 3rd person of the existence of the form and assigns her a separate non-approval task. I'm creating it in SharePoint Designer, and I can do most of it, but I'm not sure what field I'm looking for, at the beginning in order to start the workflow. Currently, there is no column for Approval Status in the form library, only a column that shows the status of the workflow (In Progress or Approved).  I tried If Workflow Status equals Approved then email.... but that didn't work. Any help is greatly appreciated.  I'm looking for the data source field and the list item field and value, I guess.  

database design for multiple vendors

  
 I have constructed a simple database schema with one vendor.now i would like to add multiple vendors who can/may provide similar products. so i am looking for a design that lists products,there attributes and can be filtered on respective Product Sizes,Brand,Colour easily.    

WCF and Entity Framework Design question

  
Should we be using Entity Framework entities as data contracts across the WCF Layer? If yes when why have the POCO support and code only been added to the Entity Framework? I was assuming it was with the purpose to remove the dependancy that the client will have on the database if the client depends on the Entities. If No, then does that mean we need to create Business Objects for each entity that exists in the entity framework model? Please advise. Thanks.Nilotpal

VS 2010 could not find database at design time

  
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 Data Source=|DataDirectory|\thedbfile.sdf 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.... thanks

what is the better design for location of system database data / log files and user data/log file,

  
is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

Sharepoint Database size question

  
We have just installed Sharepoint 2010 in our network.  We currently have 2 users who are accessing the system, since we are in alpha stage.  What I have noticed is that  User Profile Service Application_SyncDB database size is at 800mb.  is this normal? In addtion, WSS_Logging database size is at 140mb. 

Need Suggestion for Database Design ...

  
Hi folk..i want suggestion to design my database tablesi have senario likehere i have a job which will start and then completeso i have fields like StartTime, CompleteTime to store both timestamp...now i need to find the time consumed in this process [(CompleteTime - StartTime) Hrs:min:Sec]so i have two optionshave a field in database Table which will calculate the ConsumedTime for each recordwhen i need to display the consumedtime, i will calculate the differencee.from above which is better.??Assumptions :The table will have a large number of recordsThanks

Database design for treeview and content

  
HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Question on Distribution Database ** HELP ! **

  
Hi, I am new to SQL2K8 replication.  I have been reading lots of articles/tutorials on this subject.  I was able to setup a Transactional Replication.  Everything is working as expected.   However, I wanted to further investigate as to what events are taking place behind the scene just to educate myself a bit more.  I found that in the process of creating my transactional replication, it created the "Distribution" database under the "System Database" node on my SQL 2008 box.  There is only one table called "UIProperties" with a column called ID.  My question is where is the Log Reader keeping the changes in my publications.  I can see when I made a change to a row in my publication, it got replicated to the subscription database.  But where is SQL Server storing these changes??  I guess when the distribution agents runs, where does it get the changes from?  From my reading, the Distribution database is supposed to keep tracking of these changes.  But I am finding any changes I made to my publication.  Can someone educate me on this? Thank you.  

about date in database question

  
hi i need to find data between 2 date's and time's. i use one field for date ,  and one field for time. **is it be better to use only one field for date & time ?** i see that it came in  `dd/mm/yyyy hh:mm:ss`  format that  can contain date and time. this question is for acceess and for sql-server thank's in advance

Database Design

  

hi....

I am creating a very high level relational database diagram for attendance and payroll system.

 

so far I have taken these table into account .

Employee

Attendance

Leave

Department

Company

Payslip

....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. 

 


Dental Database Design Help

  

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.

The flow

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 Table

Dentist ID (Primary Key)

Dentist Name

Dentist Specialize

Dentist Contact Number

Dentist Email

Dentist Job Description

 

Appointment Table

Appointment ID (Primary Key)

Dentist ID (Foregin Key)

Appointment Time

Appointment Date


Dental User Table

Username

Password

Name

Identification Card Numner

Contact

VS 2010 could not find database at design time

  

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

Data Source=|DataDirectory|\thedbfile.sdf

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....

thanks


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend