Erik Porter's Blog

Life and Development at Microsoft and Other Technology Discussions

News

    Browse by Tags

    All Tags » ADO.NET (RSS)
    Select DISTINCT on DataTable
    In a project I'm doing I needed to basically do a DISTINCT on a couple fields in a DataTable that I had used earlier in code. Did some Google searching and came up with this MS KB on the subject. I was hoping to find it in the Framework, but hey, writing...
    Cool Whidbey Data Feature
    Was just in a chat and found out about a new feature called "Smart Captions". When you drag a table out from the Data Sources Window specified to be a Detail View, it will create all the Labels and TextBoxes (or whatever is appropriate for that field...
    Strange DataTable Behavior
    Today, I ran into what I think is a bug in DataTable. I created a table with two fields as the primary key and one other varchar field that is named the same name as the table. Probably not a best practice, but hey, it made sense for once. Let's say my...
    Posted: Oct 13 2004, 02:08 PM by HumanCompiler | with no comments
    Filed under:
    Presentation.IsCompleted = True
    Last night I gave my presentation at this month's NUFW Meeting . As unprepared as I was, I think it went pretty well. Before showing up for the meeting, I had the slides done, but had no demos at all. This actually turned out pretty well. I decided to...
    DataBinding Case Sensitivity
    Julie points out a little brain fart she had (haven't we all?) with DataBinding to a ListBox (setting the ValueMember to be exact). This is a great little “duh” tip and I wanted to point it out. What I find interesting though is that when...
    Posted: Jun 07 2004, 07:06 PM by HumanCompiler | with no comments
    Filed under:
    Interesting Types and SqlTypes Tidbit
    I talked with a guy from the Data Access Team and picked up something I thought was really interesting so I thought I'd share. Apparently, when .NET was in it's early stages, all value types (Int32, Single, Guid, etc) were Nullable (IsNull Flag), but...
    Secure Passwords
    Well done article , IMO, on securing passwords in a database table. We've been doing this in all of our applications for a while now and it works great.
    Officially an Author
    Today I received on my doorstep my two free copies of Duncan's new book Visual Basic .NET 2003 Kick Start from Sams Publishing. For this book, I acted as the main Technical Editor. Later on I was offered an opportunity to do some actual writing. I ended...
    ObjectSpaces PDC Session
    If Not You.WasAtPDC OrElse Not You.WasAtObjectSpacesSession Then You.GoToSession(“ http://microsoft.sitestream.com/PDC2003/DAT/DAT410_files/Default.htm “) End If I always thought I would like ObjectSpaces, but after watching that session I...
    DataTable.Compute
    A co-worker asked me today if I knew of way to total up the values of a column in a DataTable, other than looping through the rows and adding them into a variable. I thought I remembered off the top of my head that the Select Method could do what he wanted...
    Posted: Nov 11 2003, 02:25 PM by HumanCompiler | with 7 comment(s)
    Filed under:
    More Posts Next page »