Triggers are valid for events, select is not considered an event. Besides triggers are EVIL :mad:. I'm curious as to the requirement for a trigger on a select, why do you need it Never underestimate the power of human stupidity RAH

Check the solutions suggested in the following forum threads. http://forums.asp.net/t/1022839.aspx[^] http://social.msdn.microsoft.com/forums/en-US/vscrystalreports/thread/cb6d6fc9-9d57-486c-972e-33b03d4a5759/[^]

How are you connecting to the database with Crystal ? ODBC or are you passing it a dataset from your application ?

You should write following code: string FilePath = Globals.ApplicationVRoot + "/Downloads/DemoUser.CSV"; byte []b=System.IO.File.ReadAllBytes(FilePath); string FileName = "DemoUser.CSV"; HttpResponse response = HttpContext.Current.Response; response.ClearHeaders(); response.ClearContent(); response.ContentType = "application/octet-stream"; response.AddHeader("Content-Length",b.Length.ToString()); response.AddHeader("Content-Disposition", "attachment; filename=" + FileName); response.BinaryWrite(b); response.Flush(); response.End(); A DATAPOST COMPUTER CENTRE (K.V Prajapati)

Read the Report with Parameters section. check this This may helps you. :)

lol :) so you thought my Signature was referring to you ? Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Do you mean week numbers as 1-52 (or 53). In that case try: SELECT DATEPART(WEEK, StartTime)... If you mean day numbers 1-7 starting from sunday try: SELECT DATEPART(WEEKDAY, StartTime)... The need to optimize rises from a bad design.My articles[^] modified on Thursday, January 8, 2009 7:55 AM

You can use for example sp_helprole[^] to list all roles in a database. The need to optimize rises from a bad design.My articles[^]

it means you tried to divide by zero, or otherwise created an invalid value. rajkumar.3 wrote: i donr even know what is NaN I guess you need to buy a javascript book then Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.

You could also try the ajax extender which you can attach to a button or other control We are not a Code Charity

No. This is basic HTML, they don't support that. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I think it needs to be all lower case. Why not just add OnClientClick to the button in the aspx ? Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Can you please confirm where you wrote this code, on page load or click of the button itself? *jaans

Can't be done. The only thing you can print in a website, is the entire window. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Set the readonly property to true for the columns that you dont want to let the user edit Alexei Rodriguez

Thanks for your opinion dude. I Love T-SQL

Because 0 is an invalid size for the Size property. Duh. If you want real help, try posting some code.... Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I thought it was already taken the datavalue field because it is using lstBox.SelectedItem.Value.ToString();