Doubt regarding deleting of items in gridview

Question

0.00/5 (No votes)

See more:

hi all,

in my project i am having booking of conferenceroom and displaying in gridview.my question is if someone books the room and it get displayed in gridview if that activity is completed it should be deleted in that gridview i.e only latest should display no older activities.

the changes will come in storedprocedures or in code.

please any one suggest me.

Posted 25-Feb-11 0:51am

mandarapu

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Paras · Answer 1 · 2011-02-25T01:29:00

From Store procedure fetch only that records whose date and time is less than current time.
i.e.

SQL

SELECT   * FROM  Booking WHERE (DATE_Book > '2010-02-24')

Additionally you can filter with time also.
Then assign fetched result to Gridview.

Mark as Answer/Solution, if it is helpful to you.

pankajupadhyay29 · Answer 2 · 2011-02-25T01:01:00

Solution 1

in storedprocedures

storedprocedures should take care of this, grid is only to display data

or u can show all data with different display scheme.

Posted 25-Feb-11 1:01am

pankajupadhyay29

Comments

mandarapu 25-Feb-11 7:11am

can u please explain with code.

pankajupadhyay29 25-Feb-11 7:14am

give me your detailed table structure and procedure you are using then after only i can give u the code.In general case you should change your query to get all active booking i.e. booking end date is less then current date.

mandarapu 25-Feb-11 7:22am

dbo.ConferenceRoom
EmployeeID nchar(7) Checked
PurposeOfBooking varchar(MAX) Checked
StartDate datetime Checked
EndDate datetime Checked
StartTime time(7) Checked
EndTime time(7) Checked
ConferenceRoom varchar(50) Checked

i am using this procedure for getting all data into gridview.
ALTER PROCEDURE [dbo].[SPGetConferenceRoom]
AS
BEGIN
SELECT * FROM ConferenceRoom
END

Dave Paras 25-Feb-11 7:30am

Add WHERE clause to apply filter.
See below posted answer posted by Dave Parth

mandarapu 25-Feb-11 8:33am

actually i used startdate and enddate in tables hw i need to use.

pankajupadhyay29 25-Feb-11 9:00am

i think you did not read my complete comment "booking end date is less then current date" simply add where enddate>getdate() or change is as your requirement.

mandarapu 25-Feb-11 9:43am

hey i am having one doubt please help me.in this same conferenceroom task when any one books at one time and another wants to book at sametime it displays "already booked choose another time".for this i used like this
BEGIN TRANSACTION;

IF EXISTS(SELECT * FROM ConferenceRoom WHERE (@StartTime BETWEEN StartTime AND EndTime)OR
(@EndTime BETWEEN StartTime AND EndTime)OR (StartTime BETWEEN @StartTime AND @EndTime)OR
(EndTime BETWEEN @StartTime AND @EndTime))
begin
RAISERROR ('Already Exists',16,1);
Return;
end

else
begin
INSERT INTO ConferenceRoom(EmployeeID,PurposeOfBooking,StartDate,EndDate,StartTime,EndTime,ConferenceRoom)
Values(@EmployeeId,@PurposeOfBooking,@StartDate,@EndDate,@StartTime,@EndTime,@ConferenceRoom)
end
commit TRANSACTION;

but when i am excueting this when i am taking different date also it is displaying already reserved.please help

pankajupadhyay29 25-Feb-11 10:02am

i m bit confused with this please try to change between to < and > it help u to identify mean while i am trying to resolve...

Manas Bhardwaj · Answer 3 · 2011-02-25T01:03:00

Solution 2

In a ideal world, I would put this in the data layer (i.e. stored procedure). This stored procedure would return me all the bookings which are currently active.

Posted 25-Feb-11 1:03am

Manas Bhardwaj

rajivpande86 · Answer 4 · 2011-02-25T08:26:00

Solution 4

When someone books a room, you can use trigger/stored procedure to pass some value to the front-end.
On checking this value, you can re-bind the gridview with the updated data.

Posted 25-Feb-11 8:26am

rajivpande86