Hi all,
I thought I'd introduce myself before I start begging for help!
I'm just about to recommence a career in IT and am currently training
to get the MCP.net/MCAD/MCSA/MSDBA qualifications. I have a linux
background and am very keen to see how well I can integrate MS
products and Open-source alternatives through the .net framework. My
knowledge of C# and the ASP platform is no-where near as good as my
skills in other languages, but there we go, that's life! :)
My question is as follows:
I'm currently trying to insert data into a number of tables in a MSSQL
Server database. My current logic (and this is not yet in code!) goes
something like this:
1. Insert the user's Firstname, lastname, emailaddress and password
into the "personnel" table.
2. Extract the new users ID from the "personnel" table and use it to
insert their postaladdress, phonenumber, fax number into the
"personnelDetails" table.
3. using the postcode from the "personnelDetails" table, suggest a
branchId (through a "SELECT * FROM branches WHERE branchPostCode LIKE
%postcode%" kind of thing...)
4. add them to the selected branch.
If anyone can help me get around this, that would be great. The main
issue is with step 2 and extracting the person's ID.
Thanks in Advance,
Matt
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
