Inserting into Table

r p

I have a table called JobProfile which has ProfileID, AddedDate, Username, IndustryID, LocationID, Skills.
Now data to this table will be coming from 3 different forms:-

1. Industry.aspx contains Industry name in a dropdownlist and id as value for the dropdownlist. When the user clicks submit,
industryid will be inserted to the database by using an insert/update statement.
2. Location.aspx contains a dropdown list which contains id as its value and when the user presses submit the id is inserted
using an INSERT/UPDATE STATEMENT.
3. Skill is a free text when the user submits again I am calling an INSERT/UPDATE STATEMENT.
In my master page, I have menu called Industry, Location and Skill. The user can choose any and start filling the respective form.
ProfileID is an int which will increment automatically.
I have stored procedures called InsertIndustry, InsertLocation and InsertSkill. In each of the stored procedure,
before calling insert/update statement, I will check whether a record with the SAME USER NAME is existing or not. If existing I will call an update statement
else an insert statement.
For EXAMPLE if the user visits Industry.aspx first and inserts the record, then for Location.aspx and Skill.aspx I will be calling only UPDATE statement.
Am I doing the CORRECT WAY?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Accepted answer
Hi, What ever you are doing that is right, with the logic that you have but is it possible to have all 3 pages in BIG container i.e. one single page and have all these as small frames. This way the ender dont have to go 3 different pages to update his information.

I guess you are building a portal some what similar to resume/job site.

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com
Vijaya Kadiyala17y ago
HI Yogesh,

What problem you have while inserting the data into Identity column?

Thanks

Vijaya Kadiyala

Http://dotnetvj.blogspot.com
Lisa17y ago
yes it seems to be a fine logic

but why are you asking it.?
are you getting any sort of error..

if not then its fine.

Thanks,
Lisa
yogesh aniya18y ago
Hello, Would you please tell me about the coding you used,because I have a problem using identity column?
Vijaya Kadiyala18y ago
Hi

Probably you need to put in different direction i.e. If the user want to enter all the 3 details then he has to do several operations instead if he can see everything in single page he can all 3 at one shot.

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com
r p18y ago
Thanks Vijaya, my user wants it as three links in the home page. When the user clicks on 'Industry' link it should go to Industry page, when he clicks on Location link
it should take to Location page and when he clicks on Skills link, it should go to skills page. Can I do it using multiview or something?

Thanks,