Member Avatar for 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..

  • 3 Contributors
  • 3 Replies
  • 145 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Abu Ehab
Member Avatar for Reverend Jim

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

Member Avatar for 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
Member Avatar for Abu Ehab

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, networking, learning, and sharing knowledge.