Search:

What is not clear?
In regards to .CSV, that is simply a file extension, a .TXT file can have the exact same structure and data as a .CSV file.

If your first row are column names try


Imports...

If you have load data say into a DataTable from a database or perhaps reading data from a local xml file then after loading the data into the DataTable add a new DataColumn to the DataTable, set the...

Conceptually, create all objects for sending messages as you have done, loop thru say a collection of some sort that has the message text to send to the one user, set the body text and then send the...

You have to account for if the first line is column names or some other type of data other than the bulk of the data. What exactly is the structure of your file?

Hard to say but here is a VS2010 example that works using code I provided already
100107

That is right, nothing visibly happened, instead you have a DataTable populated with data that you need to select something like a DataGridView to display the data in.

Other options are to control validation and adding rows using a BindingSource component and DataTable events. Any time you can avoid the user interface and work directly with the data is the best way...

Hello Andy,

For anyone to assist you relevant code needs to be shown otherwise there are too many directions to go and that leads to undue guessing and wasted time.

I have updated the code. Any time you allow the IDE to generate items it is prudent to look at them, especially "FileName" as the core thing here is working on a file :-)

You can read data from a delimited text file using TextFieldParser class.

Example


Public Class Form1
Private Sub Demo()
Dim Errors As New List(Of String)
Dim FileName...

Reading CSV files try using TextFieldParser class.

Read Text file into a DataTable


Dim FileName As String = "People.txt"
Private Sub DemoReadTxt_Load(ByVal sender As System.Object, ByVal e...

If you want to add data via BindingSource AddNew here is a comceptual example which means you would need to have private variables when getting dropped data to set then use in the AddingNew event.
...

I agree with slamany, if the part to move to a staging area (never a good idea to move a large amount of data into production) just be done via code you could tinker with the following

Create a...

The Microsoft InteropForms Toolkit 2.1 might be worth looking at. The description suggest forms yet I have done non-form DLL projects with this library.

Hello,

The following code I seeded a cell with "ABC...DEF" where the dot is a space, so that cell value has a length of 9 and upon running the code got the proper cell value with embedded spaces....

Try it, this will tell you if it works.

Hello,

Before getting into code and fields I would suggest explaining exactly what you want beginning with what information is being displayed on the first screen as the code shown is generic in...

See how this might be a starting point for reading mixed types

SkyDrive VS2010 project

Perhaps the following might work. Not sure as I don't have a sheet with that much data here at home.



Dim Builder As New OleDbConnectionStringBuilder With
{
.DataSource = "Your...

Here is an example for searching for data in a cell within a specific column



''' <summary>
''' Shows how to locate text in a specific column of a specfic sheet
''' </summary>
''' <param...

Hey you are using the same spellllkecker as me :lol:

Seems in my hast I provided the wrong file contents, should had been



1,Customer1,4/1/2013,OEF12
2,Customer2,4/1/2013,OEF11
3,Cusomter3,4/2/2013,AAF23
4,Customer1,4/1/2013,B12BX

Hello,

- What is shown below is conceptual, done in VS2010, VB.NET, Option Strict On.
- For the OleDb the file needs to be in ANSI format, does not matter for the second example.
- Fields in the...

You might explain things like;

What is "ExcelHandler", "GetDataFromExcel" etc. There are way to many unknowns in your code to provide suggestions. Lastly, when there is an error as you have...

Here is a conceptual example of working with your data (my source I am sure is slightly different than yours yet you can adapt). No UI controls are used, should be easy for you to work out.


Dim...

I found this SortableBindingList(Of T) at the following site listed below, thought it might be on interest.

http://www.timvw.be/2007/02/22/presenting-the-sortablebindinglistt/

The web site...

There are many reasons for this to happen, the most common is explained here The Two dot rule. If you adhere to what is written up here you have a 99.99% chance of releasing all objects use for Excel...

The following VS2010 shows how to display images based on the value of a column other than the image column. Images are icon files in the project resource file. By taking your time to study the code...

Project Description

ClosedXML makes it easier for developers to create Excel 2007/2010 files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with...

Okay, I am not versed in VB6 style of coding so if I was going to work with a hashtable it would be something like the following which may not work for you.

Adapted from MSDN BinaryFormatter class...

Hello,

I would suggest showing code you currently have, otherwise it's a pot-shot in which direction to go in for assisting you.

Hello,

A couple of suggestions. First off, do not use InputBox, use a TextBox instead, secondly, when using TryParse use it as it was intended to be used as shown below



Dim Score As Decimal...

Google does indeed has a sense of humor
http://www.google.com/webhp?hl=xx-elmer

Hello,

Check out Generic sortable binding list in VB.

You already have been pointed in the right direction, let me push a tad harder :) The article below is referenced in one of the links in my first reply in this thread

Basics of using Excel...

Excel when done right is easy in regards to releasing objects yet always prone to keeping objects in memory when done wrong and it takes a good deal of time to get it right.

I agree with...

Just curious, when I see "data stream", are you using JSON ?

Not that I will have a direct section of code to provide but instead reference back to things I said last time, got to be mindful of the "Two Dot Rule" and looping thru cells.

I just wrote about...

Got there from NuGet Package of the Week #4 - Deserializing JSON with Json.NET

http://smallestdotnet.com/

From the site above:
This site looked at your browser's "UserAgent" and figured out what version (if any) of the .NET Framework you have (or don't have) installed, then...