|
Hi i hope you don't have the function dbo.fnGetDatesforAday. so that u got the error. If u run the query manually in your DB server you will get the same error.
"select dbo.fnGetDatesforAday('10/01/2008','10/31/2008' , @day) Go".
|
|
|
|
|
You will get the result if you create the below fuction in your DB server.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Description: To Get any weekday dates between two dates
-- =============================================
CREATE FUNCTION fnGetDatesforAday
(
-- Add the parameters for the function here
@DtFrom DATETIME,
@DtTo DATETIME,
@DayName VARCHAR(12)
)
RETURNS @DateList TABLE ([Day] varchar(20),Dt datetime)
AS
BEGIN
IF NOT (@DayName = 'Monday' OR @DayName = 'Sunday' OR @DayName = 'Tuesday' OR @DayName = 'Wednesday' OR @DayName = 'Thursday' OR @DayName = 'Friday' OR @DayName = 'Saturday')
BEGIN
--Error Insert the error message and return
INSERT INTO @DateList
SELECT 'Invalid Day',NULL AS DAT
RETURN
END
DECLARE @TotDays INT
DECLARE @CNT INT
SET @TotDays = DATEDIFF(DD,@DTFROM,@DTTO)-- [NO OF DAYS between two dates]
SET @CNT = 0
WHILE @TotDays >= @CNT -- repeat for all days
BEGIN
-- Pick each single day and check for the day needed
IF DATENAME(DW, (@DTTO - @CNT)) = @DAYNAME
BEGIN
INSERT INTO @DateList
SELECT @DAYNAME,(@DTTO - @CNT) AS DAT
END
SET @CNT = @CNT + 1
END
RETURN
END
GO
|
|
|
|
|
Thanx . but i create the same Function it works fine , but when i call this function under stored Procedure then it show error .
|
|
|
|
|
Hi All,
Can u please help how to convert .flv file to .wmv file using c#.net ???
Thanks in Advance.
|
|
|
|
|
No. Ask in the right place, and ask Google first.
|
|
|
|
|
How to validate a file upload control for file types
|
|
|
|
|
|
Hi,
I am looking for a grid that supports the following requirements:
Firstly, I need to bind a datatable (which I fetch from a database) to the grid. I then need to be able to add columns (incidentally, a large number, roughly 500-600) to the grid, and highlight a range of columns for given row(s).
I was using another third party grid which was taking care of my requirements, but it is incredibly slow performance-wise. The grid takes at least 10 minutes to load after our operations are complete.
I wish to try out VS Flex Grid, at this juncture. Can anyone tell me if it would satisfy all my requirements?
Incidentally, I have used VSFlexGrid for an ASP application and it has worked out fine. I am just checking if it's supported for ASP.NET versions 2.0 and above.
If VS FlexGrid does not support my requirements, what are my other options?
Thanks in advance.
|
|
|
|
|
Hi,
I want to disable the previous dates in my calender extender. Plz help in giving some code.
|
|
|
|
|
|
hello,
I am working on Asp.net 2.0
In my application i used shared datatable. when i click on submit button the values in the gridview will store in datatable.
my problem when two different users working with this application same time, two users data is storing in to the same datatable, and it is giving duplication values.
what sholud may be the problem, when we are using shared datatable,wont it create seperate (instance)datatable for different users?
Please help me Its urgent...
awaiting for your reply..
Thanks in advacne
Pinna
|
|
|
|
|
haripinna wrote:
Please help me Its urgent...
That's rude.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
i can't understand what's rude...
Pinna
|
|
|
|
|
haripinna wrote: can't understand what's rude...
Expecting people to answer right away about your problem. Now, that aside, it sounds like your database needs to be normalized if you are getting two users putting in duplicate data at the same time.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Thanks for your early response.
actually i am not saving gridview data into the database, i am just saving it into the datatable(.Net) . at this situation it is not related with database.
Pinna
|
|
|
|
|
haripinna wrote: when we are using shared datatable,wont it create seperate (instance)datatable for different users?
Have you spend sometime to read the documentation and learn how shared variables works?
Shared(static in C#) will be available in the memory until the application domain unloads. Which means that multiple users will get the same copy. If you need to keep data which is unique for each user, consider sessions.
haripinna wrote: Please help me Its urgent...
WOW! That won't make any difference in the speed of getting replies. Consider reading this[^] guideline.
|
|
|
|
|
Dear navneeth
Thankyou very, i got very needful information.
Pinna
|
|
|
|
|
In my page i am having opton to show photo using asp image control and i am giving option to change photo.
i am using file upload control and saving image in server.
for change photo option after saving image into server photo is not refreshing. it is showing old photo only..
how to refersh image control to show new uploaded photo..
help me...
|
|
|
|
|
SachinKumar M wrote: for change photo option after saving image into server photo is not refreshing. it is showing old photo only..
Are you clearing the browser's cache?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
no i am not clearing browser's cache.. is it required to clear browser's cache.
if yes tell me how to clear browsrs cache...
Thank you..
|
|
|
|
|
SachinKumar M wrote: is it required to clear browser's cache.
Problem is browser cache. But AFAIK, you can't clear it from the code. When you upload new image, just attach a timestamp or GUID with the URL. So browser will think it as a new URL as load again.
|
|
|
|
|
While setting url you may please pass one more time attribute to the url. Like the following
imgPhoto.ImageUrl=string.Format("url?t={0}", DateTime.Now.Ticks.ToString());
I hope you can solve the problem in this way...
regards,
binoj
|
|
|
|
|
Give the new photo a different file name.
|
|
|
|
|
My problem solved after appending DateTime.Now.Ticks to my ImageUrl.
thank you all..
|
|
|
|
|
Cool. Glad to hear you solve it 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
