ruanr wrote: Is that at all possible? Yup. Did you run into a non-working insert method? If yes, then there's a workaround[^]. IntPtr h = tabControl.Handle; tabControl.TabPages.Insert(0, "test"); Alternatively, you could move pages around as shown below :) var tabControl = new TabControl(); tabControl.Parent = this; tabControl.Dock = DockStyle.Fill; tabControl.Multiline = true; Controls.Add(tabControl); // Create some tabs tabControl.TabPages.Add("bla"); tabControl.TabPages.Add("bla2"); tabControl.TabPages.Add("bla3"); // Swap tab 0 & 1 var temp = tabControl.TabPages[1]; tabControl.TabPages[1] = tabControl.TabPages[0]; tabControl.TabPages[0] = temp; I are Troll :suss:

I think there are 2 distinct levels of understanding with data binding. The newbie uses the MS wizardy things and is led into the mire of controls bound directly to the dataset/table etc. This lasst until they actually want to do something beyond displaying an Access list for the user to select from, at which point the new dev finds a whole new universe of DAL, object layer, OOP and all the stuff a more seasoned developer already deals with. Then the learning really begins. IMHO tightly coupled controls have absolutely no place in anything but a learning/prototype application. MS is doing the newbie a great disservice even creating the wizardy things. Never underestimate the power of human stupidity RAH

I may have found a solution - naming the tables directly after calling Fill SEEMS to help. I always get these revelations just after posting....

In that case the pool may be exhausted since it's user specific. If after a reboot he gets the error with the original username, it may be that the connection can't be established (for example sql server isn't listening on named pipes) and if that error occurs several times the pool may be depleted. So you may have two partly different problems at the same time. Since he gets a named pipes error it's good to start resolving that by changing the protocol. After it's worked out concentrate on the connection problem (if it exists anymore). The need to optimize rises from a bad design.My articles[^]

You could try combining the logic to the update. Something like (don't mind the typos): UPDATE Data SET Field = @newfieldval WHERE ID = @rowID AND ( 1 = (SELECT UpdateSetting FROM Setting WHERE ID = @fieldid) OR ( 1 = (SELECT UpdateSetting FROM Setting WHERE ID = @fieldid) AND IS NULL (SELECT field FROM Data WHERE id = @rowID))) However, few considerations: - where does the rowid come from, could you eliminate that variable - as I understood that this is from inside the trigger, what happens if several rows are updated If you're using SQL Server, I would combine the previous statement with inserted (and perhaps deleted) table table if possible. That would help to make the whole update process a single batch. Also don't forget about good indexing. Hope it helps, Mika The need to optimize rises from a bad design.My articles[^]

You forgot this :) Bob Ashfield Consultants Ltd

There are several ways, but the quickest (assuming decent indexing) should be along the lines of update client set alldone = 'Y' -- signifies no outstanding tasks from client c where not exists (select 1 from clienttasks t where t.clientid = c.clientid and t.alldone = 'n') This may not mathc your tables, but you should get the general idea I hope. Bob Ashfield Consultants Ltd

Assuming SQL Server - I would suspect that the queries would look something like these: INSERT INTO PartPrice ( partID, Price, EffectiveDate ) SELECT (SELECT MIN(ID) FROM Part WHERE Name = p.Name) AS ID, Price, WrongDateColumn FROM Part p DELETE Part WHERE PartId NOT IN (SELECT MIN(ID) FROM Part GROUP BY Name)

Nevermind: select * from information_schema.columns where table_name = 'yourtablenamehere'

Set "Localizable" in the property window of the containing form to true. When you want to translate this form switch the language to non-standard (some specific language) and just change all captions etc. (you can change the positions of the elements if you want). At the end you will get several resource-folders with the localized versions of your resources - that's it you don't have to provide strings or whatever (of course you will have to use resource-strings for your code-driven output - msgboxes etc.)

I think you have to have VS2005. _____________________________________________ Flea Market! It's just like...it's just like...A MINI-MALL!

Jon Hulatt wrote: I don't think there's a smart way of doing this. System.IO.StringReader

It has changed from .NET 1.1 to .NET 2.0, as far as I know you can serialize List<T> in .NET 2.0 Another method is the mark the list with the [XmlElement] attribute, to make sure it gets serialized correctly. WM. What about weapons of mass-construction? "What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson My blog

this threrad is for keeping updating the GUI of your form i think!

You want to know how to set the style of the drop down? or indeed the DropDownStyle? :P http://msdn2.microsoft.com/en-us/library/system.windows.forms.combobox.dropdownstyle(VS.71).aspx[^]

:-D Regards, Satips.:rose: Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Walk beside me, and just be my friend. - Albert Camus

and the dialog that can't be closed drives the user to kill process and uninstall. :mad: X| -- You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer

Yes exactly. Your were to fast for me - it was just lunch time here :-) Happy Programming Urs -^-^-^-^-^- no risk no funk