Too much time to load

[pearl.kumar1]

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

[Reverend Jim]

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

[Abu Ehab]

  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

[Abu Ehab]

Try This