[Solved] Error: invalid object name Room in ASP.Net

jochk123...

SOLVED CLOSED ACTIVE ANSWERED
User: jochk12345
Posted: on Jul 30, 2020 07:56 AM
Forum: ASP.Net Web Forms
Answer: 2
Views: 2984

Here i created a sample page of room booking.

I tried to fetch room availability from database based on selected date.

for eg: if i select todays date i want to bind free rooms available on today. But getting error on my page "invalid object name Room"

(looks like the error is in stored procedure).

alter procedure sp_roombooking (@datepicked varchar(55))
as
begin
    select r.* from Room r,Reservation r1 
    where @datepicked not in( select @datepicked from Registration1 r1 where  r1.fromdate<@datepicked and r1.todate>@datepicked)
end

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Jul 30, 2020 07:58 AM
Report

Hi jochk12345,

Please verify your table Name. It might be worng or it might be in different schema other than dbo.

jochk123...

0 4

Reply
ANSWER
User: jochk12345
Replied: on Jul 31, 2020 11:50 PM
Report

below code is wroking.

ALTER procedure [dbo].[sp_roombooking1]
( 
   @datepicked varchar(55)	 
)
as
begin
    select r.RoomId,r.RoomName,r.RoomStatus
    from Room r,Reservation1 r1
    where r.RoomName not in
            (
                select r1.Roomname from Reservation1 r1 
                where r1.fromdate <=@datepicked and r1.todate >=@datepicked and r1.RoomStatus=1
	    )
			
end

[Solved] Error: invalid object name Room in ASP.Net

Company

Explore

Follow us

Contact Us