Hello
I am binding 10000 record to WPD DataGrid. it takes all most 1 min. why it too slow. any solution or alteration?
Code Behind:
Dim Da As System.Data.SqlClient.SqlD
ataAdapter
Dim ds As New System.Data.DataSet
Da = New System.Data.SqlClient.SqlD
ataAdapter
("Select DocumentNo From tranInwardHeader", "Data Source=.;Initial Catalog=MyWingoldNext;User
ID=sa")
Da.Fill(ds)
ObjModel.ObjPurchaseList = ds.Tables(0)
Xaml:
<dg:DataGrid Grid.Row="2"
Grid.Column="1"
AutoGenerateColumns="False
" AlternationCount="2"
ItemsSource="{Binding Path=ObjPurchaseList, Mode=OneWay}"
>
<dg:DataGrid.Columns>
<!--Item Description -->
<dg:DataGridTemplateColumn
Header="Document No" Width="200"
HeaderStyle="{DynamicResou
rce LeftAlignedColumnHeaderSty
le}" >
<dg:DataGridTemplateColumn
.CellTempl
ate>
<DataTemplate>
<TextBlock
Text="{Binding Path=DocumentNo,
Mode=OneWay}"/>
</DataTemplate>
</dg:DataGridTemplateColum
n.CellTemp
late>
</dg:DataGridTemplateColum
n>
</Grid>