how to import .dat file into datagrid using c#

Question

0.00/5 (No votes)

See more:

hi....
I want to display .dat file into datagrid in column format ..please explain though code...

below is my .dat file format

VB

5    ,000022,004050          ,000004,19.09.14,12341234
  4021,000100,SONU GANPAT YADA,1550  ,19.09.14,000100
  4068,000500,SANDIP BABAN AKH,9050  ,19.09.14,000500
  4119,001000,JEEVAN KAMALAKAR,41080 ,19.09.14,001000
  4139,000050,INDUBAI RAMCHAND,1400  ,19.09.14,000050
  4144,000100,SUREKHA SANJAY P,2900  ,19.09.14,000100
  4650,000100,YASHWANT GOVINDR,5300  ,19.09.14,000100
  4654,000050,SACHIN BALKRISHN,750   ,19.09.14,000050
  4656,000100,SITARAM LAXMAN G,3500  ,19.09.14,000100
  4659,000100,MAHESHKUMAR SHAR,2000  ,19.09.14,000100
  4623,001000,MEENA KISHOR KAM,43000 ,19.09.14,001000
  4626,000200,HUSSAIN . HASHAM,8000  ,19.09.14,000200
  4629,000200,SHABANA KAUSAR N,14800 ,19.09.14,000200
  4630,000100,GANESH K SUKALE ,3000  ,19.09.14,000100
  4632,000050,RAVINDRA LAXMAN ,3250  ,19.09.14,000050
  4633,000050,SAHIL HARISH YEO,3250  ,19.09.14,000050
  4634,000025,SAVITA ANIL YEOL,1700  ,19.09.14,000025
  4635,000025,ANIL LAXMAN YEWL,1700  ,19.09.14,000025
  4639,000050,NISHA SURESH NAI,2100  ,19.09.14,000050
  4640,000050,KUNAL SURESH NAI,2100  ,19.09.14,000050
  4641,000050,SANIKA SURESH NA,2100  ,19.09.14,000050
  4643,000100,SANJAY UTRESHWAR,6100  ,19.09.14,000100
  4644,000050,MANGALA LAXMAN K,3200  ,19.09.14,000050

Posted 8-Oct-14 20:48pm

suraj Repe

Updated 9-Oct-14 1:40am

v2

Add a Solution

Comments

suraj Repe 9-Oct-14 3:33am

hi...
I want sample code for "how to import .dat file into datagrid using c#"
please help me...its urgent
thanks...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-10-08T20:54:00

You need to use ADO.NET[^] - OleDb[^].

The way is the same as is described here: Accessing Microsoft Office Data from .NET Applications[^]. The only difference is that that you need treat (in this case) *.dat file as a text file.
To get proper result, sometimes it needed to create schema.ini file[^], which contains information about general format of the file, like: the column name and data type information, and several other data characteristics.

See my past answers[^] too to find sample code.

Try!