If you want values to be used across different instances it is better to make those properties as static members of the class and access them from the class scope. A better approach would be to take out the information you want to make available across the application and put them into one class. Make a static instance of that class to use across the other classes. --------------------------------------------------

For your option A, did you have digest authentication checked? I've used the exact same thing you're talking about with no problems getting to the database, but I had digest authentication on. Logifusion[^]

Here is another solution, but with this no employee can have two of the same phone type: DECLARE @iColumns INT, @sql VARCHAR(2500),@cTypeID VARCHAR(10) SET @sql = '' DECLARE curTypes CURSOR FOR SELECT DISTINCT CAST(teltype AS VARCHAR(10)) FROM PhoneNumbers OPEN curTypes FETCH NEXT FROM curTypes INTO @cTypeID WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = @sql + ', (SELECT phone_num FROM PhoneNumbers p WHERE p.empid = e.empid AND p.teltype = ' + @cTypeID + ') as Type' + @cTypeID FETCH NEXT FROM curTypes INTO @cTypeID END close curTypes DEALLOCATE curTypes SET @sql = 'SELECT e.name,e.empid' + @sql + ' FROM employees e' exec(@sql) ---------- There go my people. I must find out where they are going so I can lead them. - Alexander Ledru-Rollin

How and where does this process get started? Is it within an event? Is that event getting called multiple times? wetrivrrat wrote: it due to the fact that i'm running this on a dual-proc pc? errmm...I'd have to say no.

okay, okay, it looks like i'm getting closer to the resolution.... it appears that either by accident( :confused: ) or by the objects design, i am actually creating at least 2 other threads at the same instance when i am starting the enumeration loop, so when i go to close it, the first actually closes nicely, its the others that are left in the loop that start #itching .... So, i'm off to see the wizard, the wonderful wizard of Threads to see what I have to do get home. Now, if i could only find my way.... :~ string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

actually, at this point its working...i found a piece of code that i accidently commented out.... :sigh: :doh: string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

Good point Dave, I think i picked up that bad habit from those redim-ing vb guys i work with :doh: problem fixed! string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

Works like a champ! --had to do a little bit of modification as you had the nodelevel declared as a 1 so it would then increment to 4 before ever actually reaching the desired point...so mod it to a 0 rather than 1 and its pretty...course i could have just changed the if == to value to 4, but then it would not have been the soulution i was looking :-D Thanks a bunch! string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

You're welcome! I'm glad I could help! :) -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog! The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Ok, so i've found something that says there is a way to expose server side methods on the client side, but of course it didn't explain how to. So my hopes is that you guys could help with this. What I am attempting to do is retrieve the client side's Bios serial number for display to the user/client. If I were to be using rich client i'd use wmiClass Win32_Bios. I've tried using this, but to my dismay it only pulls the server info. So any Ideas, Would it be usefull for me to delve into Web Services? or is that just a distraction ? Thanks for any help! string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

ServiceBase.OnStart and ServiceBase.OnStop are meant for initialization and destruction of your service, respectively. They should be as fast as possible, as you've seen. Instead, push all work into a separate thread and simply start the thread. class MyDbService : ServiceBase { // ... public override void OnStart(string[] args) { // Perhaps open the database connection and allow exceptions to be thrown // so that the service doesn't enter a started state when its clearly won't // do anything in such a case.   // Start your thread of execution. Thread t = new Thread(new ThreadStart(UpdateDb)); t.Name = "Db Updater"; t.Start(); }   public override void OnStop() { // Make sure database connections are closed. }   void UpdateDb() { // Update the database. } } You might also consider using a ThreadPool and splitting up units of work based on your inputs and number of connections available from the client to the database. If the database implements connection pooling (depends on connection string options, typically) and a client can open a number of connections to the same database you could get a lot of performance boosts this way. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Customer Product-lifecycle Experience Microsoft [My Articles] [My Blog]

I wouldn't worry if you mean 100+KB per day, because that is quite small. If you mean 100+K records, then it could take a while. Just read each line, split it with split('- -'), and shove it into the database using a stored procedure. On a moderate single processor machine running sql server, you should easily get 1000 records per second. A very slow server may take up to 5 times longer. Try the simple approach first, then optimize later. If you DO need to optimize, look to sending batches of inserts in each command, or passing your data as strings into a stored proc and parsing them out in there. Usually, these extremes are not necessary. Simple approach: StreamReader sr; String str; String[] arr; String delim = "- -"; SQLCommand cmd; SQLConnection cn; //init connetion and command here and open connection //open streamreader here str = sr.ReadLine; while (sr.Peek() >= 0) { arr = str.Split(delim.ToCharArray()); cmd.Parameters("@Param1").Value = arr[0]; ... cmd.ExecuteNonQuery(); } cn.close; sr.close;

Ok, so it seems that i was all the time looking in the wrong dirrection...it wasn't my comboBox population that was failing..it was the insert to the db that was causing the issue...i in my haste set a parameter up that looked to the selected ITEM, not the selected Value... Correction made, Have a nice night. Dim Beautiful As String Beautiful = "ignorant" Label1.Text = "The world is full of " & Beautiful & " people." Why is common sense such an un-common comodity?

Your user control can't have an AcceptButton property because what happens if there are multiple user controls on the same form and all have that property set? which is the one that counts? A workaround is to expose a public read only property named something like DefaultButton, and have it return a reference to your OK Button. Then, the form can set its AcceptButton property to that reference. Or the other way around, make the form pass a reference to itself to the user control, so it can set the form's AcceptButton property (I like the first way better). -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog! The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Well you are missing lot of parameters.. here is the sample ... You have to give the path of falsh player, file to run, and lot other optional parameters.. good luck Salim Akbar