Results 1 to 2 of 2

Thread: [RESOLVED] Loading .txt file separated with comma to datagrid

  1. Apr 4th, 2009, 02:18 AM #1
    shyguyjeff
    shyguyjeff is offline

    Thread Starter
    Hyperactive Member shyguyjeff's Avatar
    Join Date
    Jul 2007
    Location
    City of Durian
    Posts
    289

    Resolved [RESOLVED] Loading .txt file separated with comma to datagrid

    Hello everyone, i have here a .txt format wherein It show like this:

    Code:
    n,[email protected],"Sent successfully"
neha,[email protected],"Sent successfully"
kab,[email protected],"Sent successfully"
mickey,[email protected],"Sent successfully"
rahman,[email protected],"Sent successfully"
addou,[email protected],"Sent successfully"
kanaan,[email protected],"Sent successfully"
pitlik,[email protected],"Sent successfully"
    What my problem is that, how can I load this .txt file to a datagrid and arrange it in a 3 columns. That .txt file is auto generated that's why i cannot do anything about the textfile. Thanks in advance everyone. God bless!
    Please Help Us To Save Ana


    my idol: jmcilhinney
    Reply With Quote Reply With Quote
  2. Apr 4th, 2009, 02:51 AM #2
    gep13
    gep13 is offline
    PowerPoster gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: Loading .txt file separated with comma to datagrid

    Hey,

    It is actually possible to use ADO.Net to connect to a CSV file. Using this approach it would be quite simple to show the data in a DataGrid:

    http://weblogs.asp.net/fmarguerie/ar.../01/29964.aspx

    Hope that helps!!

    Gary
    Remember to mark your thread as resolved. Remember to rate posts that help. Hitchhiker's Guide to Getting Help at VB Forums.

    ASP.NET Tutorials (updated Feb 1st 2009) ASP.NET FAQs (updated July 17th 2011)

    Free Stuff: WebsiteSpark|DreamSpark|BizSpark|eBooks
    Learning Resources: MSDN|LearnVisualStudio|TrainingSpot|ScottGu's Blog|ASP.Net Starter Kits|Regex|RegExLib
    Useful Tools: XPath Builder|UltraMon|RegExBuddy|CopySourceAsHtml|TracExplorer|SQLyog|Chart Controls for .Net|SharePoint Designer|CodeRush Express
    Coding Links: XPath|ConnectionStrings|VB and MySQL|MySQL Connector.Net|My.Settings
    ADO.Net: MSDN Reference|Introduction|Using Access|Always use Parameters|Save and Retrieve Data - jm|An Explanation - jm
    Code Bank Submissions: Code Snippets|Profile Provider|Serialization: C# VB|Restricted Menu|Compressed HttpWebRequest|Enumerate and Add Internet Explorer Favourites: VB C#|C# Tabbed Web Browser|Enhanced Tabbed Web Browser: VB C#

    My Blog - View my MCP Certifications
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width