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

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

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.