 |  |  |  |  |  |  |  |
problem with database
Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
Views: 617 | Replies: 4
| 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 3.5 ajax appliances application asp asp.net beginner box browser businesslogiclayer button c# cac chat checkbox child class compatible complex content contenttype control countryselector courier database datagrid datagridview datalist deployment development dgv dialog dropdown dropdownmenu dynamic dynamically edit embeddingactivexcontrol feedback fileuploader fill findcontrol flash flv folder form gridview gudi identity iis image javascript languages list maps menu mobile mssql nameisnotdeclared novell opera order problem profile ratings redirect refer registration relationaldatabases response.redirect rows search security select serializesmo.table sessionvariables silverlight smoobjects software sql ssl tracking treeview typeof validatedate validation vb vb.net vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment wizard xsl
