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..

Recommended Answers

All 3 Replies

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

  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

Try This

Be a part of the DaniWeb community

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