quwiltw

I give MS more credit than that. I don't claim to know what the underlying structure of the Collection class is (but I doubt it's a tree). Even if it is a B*Tree or one of the many variants, they are *very* mature structures that stay balanced by definition (which is why they are behind most commercial RDBMSs) -- so methinks it's highly unlikely that's the issue.

Ahh... learn something new every day. That must be provided for compatability because it doesn't show up in System.Collections.

Removing the items will set the objects up for destruction but the collection, as I understand it, will still maintain all the pointers it needed to maintain the collection at it's largest size. btw. 'standard collection object'? If it's FIFO type collection, why not use the Queue? and what class are you using as I don't see a Collection class.

Assuming you're using the Queue class, are you calling TrimToSize() after Clear()? or after removing a significant number of elements()?

MSDE, which you probably do have, will work with those examples. Not sure what version of VS.NET you're running but in mine (Enterprise Architect Edition) their is a Setup\MSDE directory subordinate to the VS.NET directory. Otherwise, it should be simple enough to translate most of the examples to use Access and OleDb. In most cases you can just replace the SQL in front of the object name to OleDb, and obviously change your imports statement to OleDb instead of SqlClient. For example: SqlCommand becomes OleDbCommand

'online libraries'? Can you expand on that for exactly what you need?

I've never done this before but it should be as simple as adding a reference to the Microsoft Word Object Library. I have done some VBA stuff in Word and found the MSDN to be invaluable. I'll point you to this and if you still need help ask again. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/html/wohowWorkingWithTables.asp

where is nIdx coming from? have you tried HasChanges() on the dataset to see if it is reporting any changes -- maybe you just don't have the right nIdx. on a side note, it looks like you're going through the trouble of setting up the dataAdapter, why not just call it's update method and let it figure this stuff out for you?

Copy some non-conforming number from the clipboard, right-click->paste would probably break that. I still think the solution presented in the RegExValidation sample app works, just don't pop up a message and call Validate() on relevant events. Or extend Orbity's solution a bit further by handling all relevant events and changing it to be the left two characters = "0."

what is Ds1 a regular dataset or typed dataset? and are you sure Table1 in your dataset is what is bound to the datagrid? Where's your binding code?

I dont' think there's a built in way. divil has written a tutorial on creating an input masked text box (or something similar) yourself, if you search for 'input mask' on the forum. There's also a really nice sample app on MSDN where by they add a ValidationExpression (regex) to a textbox and an error message when it doesn't pass. It comes with examples for ssn, phone number, and email. Generally, http://msdn.microsoft.com/vbasic/downloads/samples/101samples.asp Specifically, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvssamp/html/vbcs_ValidatingTextboxes.asp hope this helps. maybe someone knows an easier way but I really like the RegExTextBox.

The same way you'd execute an sql statement except set the CommandType to CommandType.StoredProcedure. If the stored procedure accepts parameters then you'll need to add those to the Command object's parameters collection.

can you post the relevant code for populating your datagrid?

I agree. If you *are* doing this to put in a tree control or something you should just expand it on an as-needed basis. via the BeforeExpand event for example.

Looks like you either have data in your database that violate constraints that you have in your dataset, or, more likely, the nature of the relationship won't allow the fill to work. To see if it's the second, you set enforceconstraints to false, then call fill, then set enforceconstraints back to true. Someone else may have a better solution...

Sure. This is especially easy if your database contains only one table;) On a serious note, I can't imagine why you'd want to do that. I don't know if there's a quick way to do it either, but I doubt it. I'll look closer if you have a convincing reason why you'd want to do it.:)

I just pasted your Form_load into a testing project I've got and it worked fine when I put the results in a message box. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim EXL As New Excel.Application() ' I want to evaluate Cos(20) MsgBox(EXL.Evaluate("Cos(20)")) End Sub The answer is: 0.408082061813392 Have you checked here? http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320369

Pls read this (#14 specifically): http://www.xtremedotnettalk.com/announcement.php?s=&forumid=65 I'm not sure if there is a better way to *not* get your question answered than to double post because of your lack of patience.

When you use the "Report Post to Moderator" link, it lets you type a message but after you submit, it is unclear whether it actually submits or not because it sends you to a "Permission Error" page which says you don't have permission to use this feature. I assume this is just a flaw in the system because if you had to have special permissions to use the feature, you wouldn't need to use the feature.:rolleyes: On second thought, perhaps the moderator just deleted it before I hit submit and that's just the error that came up?

Not a C# guy but it looks like you'd need to change customer to a class then declare its interface and implement the interface. [serializable] public class Customer : IValidate { public string firstname; public string lastname; public string address; public string email; public string userID; public bool validate() { ...some validation } } Oops... It looks like my understanding of a struct is not accurate for C#, I guess it means something different in C# and thus the change to a class I suggested is not needed.

Thanks divil. Obviously UI development is not my strong suit, perhaps because of quirky things like this. Would have never guessed that I needed to add something to make my app look like the native style of the os.

It's possible to use the same dataadapter but I'm using separate ones for what seems like clarity to me. I'm interested to hear from others on this too.

I think I'd use the wizard in VS.NET to create a typed dataset with all the tables in it for now. I wouldn't actually use this, but it'll give a good idea of where to go from there. This page has a tutorial on Data and ADO.NET -> Working with Relational Data that should prove useful. http://samples.gotdotnet.com/quickstart/howto/ I guess the jury is still out on how exactly people are using datasets in their apps and what the best practices are but I'm starting to not use typed datasets and doing more of a pseudo-typed dataset, similiar to Duwamish. Of course this involves manually maintaining them but it's worked well so far without the bloat of typed datasets. This allows you to only build the datatables you need at any given time too.

Take a look at this tutorial on databinding it should give you a good start. If by chance you're already passed that point, pls give more insight into what exactly isn't working. http://samples.gotdotnet.com/quickstart/winforms/doc/WinFormsData.aspx

I don't think so. I think you have drill down manually which should be pretty easy.