Background Color:
 
Background Pattern:
Reset
Wednesday, December 13, 2017
menu click
Search

Traversing Folders and Files using Managed Code or the Win API

A short article on how to traverse a directory's files and sub directories using managed code, and then how to do the same using the Win API within a Managed Code environment using VB.Net
Sunday, October 20, 2013/Author: Ibrahim/Number of views (5769)/Comments (0)/ Article rating: No rating
Tags:

CSV File handling in VB.Net or C#

Response to a VBProfessionals LinkedIn forum question

On a LinkedIn forum, someone asked the following:

I want to import a CSV file from a network drive into sql server table using vb.net in a WinForm. I thought this would be easy but have not found a simple solution yet. The CSV file does have field names.

While it is not not a terribly difficult task to import a comma delimited file into a Net project, once imported the separating into fields then writing the results back to a data store like SQL-Server does have some complexity. 

Thursday, October 10, 2013/Author: Host/Number of views (12661)/Comments (0)/ Article rating: No rating
Tags:

Find a label by name in a form.controls collection and change its text value.

You don't need 20 if...then statements

This problem was from someone who had to change the value of a label's text based on a callback from a Weather API.  The callback provided an index to the value changed and the code had to select a label using that index and then change the label's text property using the API's supplied indexed value. 
Monday, August 19, 2013/Author: Ibrahim/Number of views (2249)/Comments (0)/ Article rating: No rating
Tags:

LINQ Select items where an Item value is in a list.

Replicating the SQL statement Select * From TableA Where Field1 In (Select Field 1 From Table B)

Did you ever want to constrain a list  by values in another list using Linq?  Kind of like the IN clause in a SQL Select Statement. i.e. Select * From TableA Where Field1 In (Select Field 1 From Table B)

While there is no IN clause in Linq there are a variety of ways I have seen others do this I have my own VB.Net solution to this problem that was in answer to someone's question on an MSDN VB Forum.

 

Monday, August 19, 2013/Author: Ibrahim/Number of views (10092)/Comments (0)/ Article rating: 5.0
Tags:
RSS