 |  |  |  |  |  |  |  |
problem with database
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
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
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
•
•
Join Date: Mar 2008
Posts: 269
Reputation: 
Solved Threads: 19
Posting Whiz in Training
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
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
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Mar 2008
Posts: 269
Reputation:
Solved Threads: 19
Posting Whiz in Training
Yah sure u can
The code to connect 2 tables will be something look like this
example
Sample code
on the above code u are changing the job table by adding a foreign key which is originated on Skill table
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
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
|
Similar Threads
- database questions I have (Database Design)
- Problem with database connection (JSP)
- Display image from a database get me ascii codes (ASP)
- Pls help me regarding to access database in vb6 (Visual Basic 4 / 5 / 6)
- Problem with VB.NET and MS Access (VB.NET)
- Problem With database Connectivity (ASP.NET)
- problem after migration (MySQL)
Other Threads in the ASP.NET Forum
- Previous Thread: Online Payment Options
- Next Thread: C# server.transfer to save form data and send email
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 activexcontrol ajax alltypeofvideos anathor appliances application asp asp.net bc30451 beginner box browser button c# cac checkbox commonfunctions complex dataaccesslayer database datagridview datagridviewcheckbox datalist development dgv dialog dropdownlist dynamically edit editing expose feedback fileuploader fill flash form formatdecimal formview google gridview gudi iis image javascript list listbox login microsoft migration mouse mssql news numerical opera panelmasterpagebuttoncontrols parent problem project radio redirect registration relationaldatabases reportemail response.redirect richtextbox rows save schoolproject search security select session sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking treeview unauthorized validatedate validation vb.net video videos vista visualstudio web webapplications webdevelopemnt webprogramming webservice xsl youareanotmemberofthedebuggerusers
