Member Avatar

I need to create dataset in my module.If i retrieve the database (Huge amount of data are there),It takes too much time to load..Is it possible to resolve this issue..

  • 3 Contributors
  • forum 3 Replies
  • 113 Views
  • 15 Hours Discussion Span
  • comment Latest Post Latest Post by Abu Ehab

Recommended Answers

Answered by Reverend Jim 3,627 in a post from

Not without knowing more details. Is your table indexed to provide quick access based on how you are selecting the data?

Jump to Post

All 3 Replies

Member Avatar

Not without knowing more details. Is your table indexed to provide quick access based on how you are selecting the data?

Member Avatar 
  Dim op As New OpenFileDialog
    With op
        .Filter = "Text Files | *.txt;"
        .ShowDialog()

    End With
    Dim Lst = (From Row In IO.File.ReadAllLines(op.FileName) Select Name = Row.Split(",")(0), Address = Row.Split(",")(1), Phone = Row.Split(",")(2)).ToList
    DataGridView1.DataSource = Lst
Member Avatar

Try This

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!