You cannot pass any System.Collection objects back to VB6. You'll have to convert this collection to an array of strings to send it back to VB6. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

As the previous poster said, if you want a specific order then use the order by clause. Do not rely on the intrinsic order that SQL Server uses as it can, as you've seen, be non-deterministic. Upcoming FREE developer events: * Developer Day Scotland My website

hi Some Questions dont need to be posted here,until you have tried to Google.look how many answers i find here. http://robinsky.proboards12.com/index.cgi?board=general&action=display&thread=1073067260[^] http://visualbasic.ittoolbox.com/groups/technical-functional/vb-crystalreports-l/cannot-open-sql-servererror-20599-1289278[^] http://www.google.co.za/search?hl=en&q=Cannot+connect+SQL+server+.20599&btnG=Google+Search&meta=[^] Thanks Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

You need the SQL Server 2005 Backward Compatibility Components package. You can find this at the latest 'Feature Pack' download. The last update was in February 2007 which can be found here[^]. SMO - Server Management Objects - is a set of .NET components that perform much the same function as DMO. DoEvents: Generating unexpected recursion since 1991

select * FROM WHERE datediff(year,convert(datetime,DATEOFBIRTH),getdate())>75 -- modified at 8:17 Wednesday 19th September, 2007

Handle the onselectindexchanged event in your user control and create an event in your user control that any page can subscribe to that reflects the onselectindexchanged event. A technique called event bubbling. http://www.odetocode.com/Articles/94.aspx[^] only two letters away from being an asset

I think one way is to crate a base class that drives TextBox class and implement OnTextChanged method in that class public sealed class CustomTextBoxOnTextChanged : System.Web.UI.WebControls.TextBox { private bool isDirty = false; protected override void OnTextChanged(System.EventArgs e) { // Call the base OnTextChanged method. base.OnTextChanged(e); // Change the dirty flag to True. isDirty = true; } } Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

Thanks for ur quick response. In my case,am using the dataacces code only in the service and also performance matters. I think its better to use the dataaccess code in the service itself. Thank you. cheers sangeet

try running your code like this first, function confirm_update() { alert('hello'); } in this way you can be sure that your function is being called or not. if you see pop up saying 'hello' then there would be something wrong with your code which this, function confirm_update() { if (confirm("Would you like to Inactive the same?")==true) return true; else return false; }

Set the message in tooltip properties of control properties Sujit

Yes..all the year with same date and time. I got it by just adding Convert.ToDateTime(@"1/1/" + Year_Tbox.Text) thanks for ur reply.. cheers sangeet

thanks for ur reply .. i tired the code. but still am getting the same error. ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'INSRTEVNT' expects parameter '@EventType', which was not supplied. plz give me suggestions cheers sangeet

http://www.codeproject.com/aspnet/3dpiechart.asp[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

I think the best thing to do is make a web part containing the grid, then you can use Ajax to refresh the data. Hope this helps , Shirish.

Is this ASP.NET 1.0, 1.1, or 2.0 ? What errors are you getting ? You should certainly put all your SQL in a class, so that it's in a seperate layer to the rest of your app, and can be reused as needed. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

yes i got it..thanks a lot.. cheers sangeet

HI If you want to see all the process on youe machine then check this System.Diagnostics.Process[] Processes; Processes = Process.GetProcesses(); foreach (Process proc in Processes) { if (proc.HasExited) { } } Thanks and Regards Sandeep

Please check it out. Detecting ASP.NET Session Timeouts OR google with this keyword "asp.net session expire" Thanks and Regards, Michael Sync Blog: http://michaelsync.net

Assuming that your service is running on the same machine as your ASP.NET application, you could use WMI to query the service status. WMI functionality is exposed through the System.Management namespace. Like any system-level functionality, you'll need to have the proper permissions to expose this information. If your service is on a different machine, or you aren't able to secure the proper permissions, you may wish to consider exposing a remoting interface from your service. In that way, you could connect to your service programatically, and ask it for a report of its current status. The catch here is that you'll need to write code in the service that can understand and report on its status. Another thing to be aware of is that if your service is not currently started, the connection will fail. Here are a couple of resources to help get you started: MSDN Article: Monitoring and Dynamically Configuring Windows Services[^] CodeProject Article: Exposing Windows Service[^] Google Results for: "WMI and Windows Service and .NET"[^] Hope that helps. :) --Jesse

Are you sure your service is being run from the bin\debug folder? Also, does your CamToJ2K.dll have any dependencies that might also need to be copied to that location? -Phil