DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Editting dynamic tab-delimited file with gridview

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Help Editting dynamic tab-delimited file with gridview

    I have page where someone would be able to upload a new tab-delimited file, a table, or edit an exisiting file that's already been uploaded.

    I have the following code that successfully displays a file in a gridview(called TextGrid in this example):

    Dim DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & tablePath & ";" & "Extended Properties='text;FMT=TabDelimited;HDR=YES'")
    DBConnection.Open()

    Dim SQLString As String = "SELECT * FROM " & lblTableName.Text
    Dim DBCommand = New OleDbCommand(SQLString, DBConnection)
    Dim DBReader As OleDbDataReader = DBCommand.ExecuteReader()

    TextGrid.DataSource = DBReader
    TextGrid.DataBind()

    'Determines the number of columns for later use
    numColumns = Int(DBReader.FieldCount)

    DBReader.Close()
    DBConnection.Close()


    The person can select an existing table from a drop down list that is populated by checking a folder on page load for all files in that folder.

    Each table can be any number of columns and rows with all kinds of data.
    I've seen plenty of examples for when the databases associated with gridviews are explicitly defined but not for dynamic data.
    So how can I add code to edit and update these dynamic tables? Preferable an example that when you edit a line in the gridview that row becomes seperate textboxes which can be editted in view.

    Thanks.

    Chris
    Last edited by cjpeterson; 10-31-2006 at 09:10 AM.

Similar Threads

  1. Tab Delimited text file problem
    By nanban4u in forum VB Classic
    Replies: 2
    Last Post: 08-12-2005, 08:49 PM
  2. Replies: 1
    Last Post: 09-25-2002, 05:39 PM
  3. XML >> Delimited text file
    By Jeff in forum XML
    Replies: 4
    Last Post: 05-20-2002, 11:35 AM
  4. Replies: 3
    Last Post: 05-31-2000, 10:30 AM
  5. Replies: 0
    Last Post: 03-28-2000, 12:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center