TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
shini katiyar
NA
1
0
performance increase of flexgrid
Jan 8 2010 2:16 AM
Hi all,
Please tell me how to increase performance of flexgrid, in filling data through recordset
i have used additem() property of flexgrid to fill data but i think is takes too much time in comparision of set_textgrid() property.
this is my code:
RS = GCnAdodb.Execute("select Code,Name from groupmast order by name")
I = 0
RS.MoveFirst()
Do Until RS.EOF
I = I + 1
FlexGrid1.AddItem("" & Chr(9) & RS.Fields("Code").Value & Chr(9) & RS.Fields("Name").Value)
rs1 = GCnAdodb.Execute("select * from UserGroup where userid='" & TextBox1.Tag & "' and GroupCode='" & RS.Fields("Code").Value & "'")
If rs1.RecordCount > 0 Then
FlexGrid1.Row = I
FlexGrid1.Col = 3
FlexGrid1.CellFontName = "wingdings"
FlexGrid1.CellFontSize = 18
FlexGrid1.CellForeColor = Color.Blue
FlexGrid1.set_TextMatrix(I, 3, "ü")
End If
RS.MoveNext()
Loop
this is correctly running but takes much time, i want to increase performance of it.
so, i want to replace .additem() with set_matrix() but it gives error.
so please tell me how to correct it.
your help is appriciated.
thanks.
Reply
Answers (
2
)
how to scoop a file properties
C# Live Chat Support Application