web deployment

Question

Isuse: best setup deployment method and considering IIS

I have some changes to setup/deploy  in a 2010 C#,net webforms application. My problem is the web application was written by a contract shop that went out of business. There are no install/deployment instructions that I can find in my small company. In fact I am the only 'programmer'  in my small company. Most of my .net expereince is using Visual Basic.net in 2005 & 2008 for windows and console applications.

Thus since this is my first web setup\deployment project and working with IIS, I am wondering if you have suggestions that I should follow? If so can you tell me and/or point me to a reference that I can use?

If not, i will just go to the Microsoft website and follow what I consider is the 'best' url to use.

Answer 1

The number of coursecode should be less than 2. This is the main part that I have problem. Not the retrieving part. I cannot check (less than). (<) is cannot use in joining tables.

Answer 2

var dealercontacts = from course in Course
                     join Tr in Training on course.IdNo equals Tr.IDNo
                     where tr.Nationality='American'
                     select count(*);
Hope This Might Help You

         

 

            

Answer 3

In Course Table

-Idno.

-Coursecode

and other information

 

In training table

-Idno.

-name

-Nationality

and other information 

 

Other infomation is not important to retrieve........ 

Answer 4

Kindly give a snapshot of table structure..

Answer 5

Can You please give your table structure in details?

Answer 6

select idno,count(idno) from trainningtable where nationality='american' group by idno