You can either append "\r\n" to your Text or append the string returned by Environment.NewLine. Using the Environment.NewLine is preferred for code portability. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Something like this might work: SELECT COUNT(a.*) AS Daughters, ac.FinalClass FROM Animal a INNER JOIN AnimalClassification ac ON (a.HerbBookNumber = ac.HerbBookNumber) WHERE (ac.LactationNumber = (SELECT MAX(LactationNumber) FROM AnimalClassification WHERE HerbBookNumber = a.HerbBookNumber)) AND (Animal.Sex = 1) AND (Animal.Sire = paramSire) GROUP BY ac.FinalClass

In my opinion, I think the check box of Allow Null is the place similar to AllowZeroLength in ms access. A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

It is, if you have another table with integer values. The SQL will be like this: SELECT MIN(tblInteger.Number) FROM tblInteger WHERE tblInteger.Number NOT IN ( SELECT Numbers FROM tblData ) tblData will be the table you described while tblInteger will have integer numbers you use. So far that's the only way I can think of, maybe others can help? Edbert P. Sydney, Australia.

The idea of ADO.net is to work on databases without an active connection so i wouldn't have thought so. You could get the program to create the connection every X Minutes / Hours and update the dataset accordingly. Kev

Take a look at the RegEx class. www.troschuetz.de

Heath Stewart wrote: Why generate an extra call on the stack just to "redirect" to another method? To avoid duplicating defaults and/or code (which could lead to inconsistent behavior). Actually, if you Google for it you'll notice that this is one of those religious things. Personally, I agree with you, with the added annoyance that single-stepping through code like this is really boring. Yes, even I am blogging now!

Write a intialiser in your custom class constructor. That means, in your custom control constructor you have to initalise the selected row value if the datagrid is selectable. To check whether datagrid is selectable use this dataGrid1.CanSelect property . If it is selectable then it will return true else will return false. This is only a small idea to handle the situation. Sreejith Nair [ My Articles ]

Isn't that what Paul was employed for? ;) Jon

Indeed you can at the start of your code add this.SuspendLayout() ..and after everything's done.. this.ResumeLayout(true) -- Help me! I'm turning into a grapefruit! Phoenix Paint - back from DPaint's ashes!

Infragistics[^] has a great grid control. Comes with the NetAdvantage package, but is not cheap. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Just curiour, what didn't you like about them? Rocky <>< www.HintsAndTips.com - Now with "Recommendation" postings www.JokesTricksAndStuff.com www.MyQuickPoll.com - Now with Recent Poll List www.GotTheAnswerToSpam.com - Again :)