Saving Stuff

how do i created a stored procedure in C# that uses the users login id to display filtered preference results?

im workin on an online catalog for books my company has. I want to be able to have the user to login and then be able to search for books located in their branch library. to do this i need to somehow link the userID to thier location and then be able to display a filtered result set, that just shows them the books they searched for in their location. I already have the login set, and then stored procedure to search for books by title. i just need to link these two. can anyone help?

This is difficult to do without seeing your database structures, but let’s suppose the following:

1. Your users have their login id and customer id entries linked by a key column.
2. Your libraries table has titles and locations linked by a key column.

In that case, this SQL query could be used to link the two together and populate a GridView:

SELECT a.* FROM librarybookstable a INNER JOIN librarylocationstable b ON a.locationidcol = b.recordidcol INNER JOIN customertable c ON c.locationidcol = a.locationidcol INNER JOIN logintable d ON d.customeridcol = c.recordidcol WHERE d.loginidcol = ‘loginvariable’

The INNER JOINs above basically get all the books information based on the books that are at the same location as the logged-n user, by excluding records that don’t match all those requirements.

In the query above:

librarybookstable is the name of the table that contains your books listing. It assumes that table has a foriegn key column named locationidcol, which links to the recordidcol of the next table.

librarylocationstable is the name of the table that lists off the branches of each library. It assumes there is a primary key column named recordidcol

customertable is the name of the table that contains identifying information about the logged-in user. It assumes the table has a primary key column named recordidcol and a foreign key column named locationidcol that links back to librarylocationtable.

logintable is the table that holds user names for each person. It assumes there is a foreign key column named customeridcol that links back to customertable.

Again, this may not be quite right based on the way your tables are set up, but this should give you an idea of how to proceed.

Cataloging and shelflist procedure for the Army Air Forces technical libraries. …

Procedures manual …

The map collection in a general library;: A manual for classification and processing procedures …

If it took AB History as my course?

what jobs can I possibly get?

Lots of jobs appreciate that you have a qualification in the first place…so don’t think of the jobs available simply because your qualification is specific to this subject.