Hi to all:
I had notice that datagridview have a problem with performance,and i had read in MSDN something about the problem but sincerely this code that i use for fill a datagridview (and the DB I have have just 10 records,and I have problems with performance),i don't know if something in the code block the performance.I Would like to know yours suggestions for increase the performance in my code please.
ThanksCode:Private Sub abrirBD() con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & My.Application.Info.DirectoryPath & "\NumWin.mdb" con.Open() ds = New DataSet sql = Nothing sql = _ "select" & _ " nemp, contribuinte, nome " & _ " from Empresas" & _ " order by nemp " da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, "table") DataGridView1.DataSource = ds.Tables("Table") DataGridView1.RowHeadersWidth = 4 DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect DataGridView1.Columns(0).HeaderText = "NºEmpresa" DataGridView1.Columns(1).HeaderText = "Contribuinte" DataGridView1.Columns(2).HeaderText = "Nome Empresa" DataGridView1.ColumnHeadersHeight = 30 DataGridView1.Columns(0).HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter DataGridView1.Columns(1).HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter DataGridView1.Columns(2).HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter DataGridView1.Columns(0).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter DataGridView1.Columns(1).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter DataGridView1.DefaultCellStyle.SelectionBackColor = Color.Purple '(255; 192; 255) DataGridView1.Columns(0).Width = 70 DataGridView1.Columns(1).Width = 80 DataGridView1.Columns(2).Width = 360 con.Close() End Sub




Reply With Quote