943,630 Members | Top Members by Rank

Web Development > ASP.NET > problem with database
Ad:
  • ASP.NET Discussion Thread
  • Unsolved
  • Views: 721
  • ASP.NET RSS
Permalink
Nov 24th, 2008
0

problem with database

Expand Post »
hai friends,,
i am new for the project development.
i am developing a application like naukri/monster.
i created the tables like employeename,phonenumber,skills,technology,role,work experience,location like that i am taking attributes.

my boss said " to create the database like each table for name and first name,lst name like that..
please send me how to do that ..
i am getting so confused on that..
please help me ASAP
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
krany18 is offline Offline
19 posts
since Nov 2008
Permalink
Nov 25th, 2008
0

Re: connectivity

Ok so U have 2 tables and u want to connect the tables to each other, what u can do is to have a primary key and the foreign key in the master table, that means, on Job table u can have a skillId as a foreign key and then on Skills Table u gona have SkillId as a primary then u will know what Job is associated with what skill

so one more question which Database ur using, MS Access, SQL, Oracle or what?

Then the code will merely depend on which Technology ur using for ur database
Reputation Points: 26
Solved Threads: 19
Posting Whiz in Training
Traicey is offline Offline
283 posts
since Mar 2008
Permalink
Nov 25th, 2008
0

Re: connectivity

[i am using the sqlserver database .

And while i am using that could i retrieve the data
Reputation Points: 10
Solved Threads: 0
Newbie Poster
krany18 is offline Offline
19 posts
since Nov 2008
Permalink
Nov 25th, 2008
0

Re: connectivity

Yah sure u can

The code to connect 2 tables will be something look like this

example

alter table tableName
Add Constraint anyLegalvariable Foreign Key(ColumnName that u want to be a foreign as it is from the table)
References Name of the table u are getting a key from(Column name as it is from the table)

Sample code
alter table Job
Add CONSTRAINT fk_Skill_Id FOREIGN KEY (SkillID)
   REFERENCES Skills (SkillID)

on the above code u are changing the job table by adding a foreign key which is originated on Skill table
Reputation Points: 26
Solved Threads: 19
Posting Whiz in Training
Traicey is offline Offline
283 posts
since Mar 2008
Permalink
Nov 25th, 2008
0

Re: problem with database

What did ur boss said???

can u post ur project specs sure that would help
Reputation Points: 26
Solved Threads: 19
Posting Whiz in Training
Traicey is offline Offline
283 posts
since Mar 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: Online Payment Options
Next Thread in ASP.NET Forum Timeline: C# server.transfer to save form data and send email





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC