You'd get more responses from the database-forum. I haven't used the Reporting Services yet, but I guess that they can use a function or sproc as a datasource. I usually use a construction that's comparable to this; DECLARE @TEST AS TABLE (FieldOne VARCHAR(10)) INSERT INTO @TEST VALUES('Hello') INSERT INTO @TEST VALUES('World') DECLARE @ArgumentForFieldOne AS VARCHAR(10) SET @ArgumentForFieldOne = 'He%' SELECT * FROM @TEST WHERE ( (@ArgumentForFieldOne IS NOT NULL AND FieldOne LIKE(@ArgumentForFieldOne)) OR (@ArgumentForFieldOne IS NULL) ) You'd set @ArgumentForFieldOne to NULL if you don't want to search that particular field. This has the disadvantage that you can't pass NULL as a parameter to search for though. You can bypass this problem by introducing a separate bit that indicates whether you want to filter the field or not; DECLARE @TEST AS TABLE (FieldOne VARCHAR(10)) INSERT INTO @TEST VALUES('Hello') INSERT INTO @TEST VALUES('World') DECLARE @DoFilterFieldOne AS BIT SET @DoFilterFieldOne = 1 DECLARE @ArgumentForFieldOne AS VARCHAR(10) SET @ArgumentForFieldOne = 'He%' SELECT * FROM @TEST WHERE ( (@DoFilterFieldOne = 1 AND FieldOne LIKE(@ArgumentForFieldOne)) OR (@DoFilterFieldOne = 0) ) You can wrap these constructions in a table-valued function, but a sproc where you pass @DoFilterFieldOne and @ArgumentForFieldOne is also an option. SQL lingua venusta :)

Thanks both for your prompt responses. Case closed.

Your post here[^] Dave BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

hi Have you tried changing the key name (objMainScript) Hope this helps/ www.fuzzelogicSolutions.com

me.id inside your custom control?? Alexei Rodriguez

AFAIK no. However you can export the document to Excel, PDF, HTML etc. The need to optimize rises from a bad design

Are you on ASP.NET 1.1 ? From where this InitializeComponent() is getting called ? All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

From MSDN: "Unlike the ComboBox control, the DataGridViewComboBoxCell does not have SelectedIndex and SelectedValue properties. Instead, selecting a value from a drop-down list sets the cell Value property." I am not sure what will happen when you set the value, although I will assume that it will change the selection. You can then read the Value property to get the value back. There is a way you can make your own selected index property by comparing each item to the Value property and returning the index when the objects match. Hope this helps.

Because .DLL projects can't have config files. Since the .DLL becomes part of the host application using it, any code you write like this in the .DLL will use the host applications config file. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Ahh, C#, I'm not familiar with the differences between C# and VB.NET Glad you solved the problem :)

davebarkshire wrote: (Are you listening Mr Gates???) Gates: "Yes, I am. And I know that CP surely can help you fight with your difficulties". I saw him saying that in my dream last night. ;P

Thanks for the help from you all. it does make sense now that i think about it more. I have only one final question. Does anyone have a snippet of javascript or asp.net code that will resize the image?

:wtf: What the.... Here is the link again: http://www.codeproject.com/useritems/SqlInjectionAttacks.asp[^] Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums