database to msflexgrid

[cutecatcher]

i have a problem regarding on how to transfer datas from msflexgrid. When i was using datagridview, i just use "Datagridview1.datasource=ds.Tables[0].defaultview;" but it seems, it doesn't work at flexgrid at all. So if anyone could just help me on how can i display data on a msflexgrid, it will surely be a great help..

thanks!

[brazel]

Good day!

Hello,

I want to give some Idea if I can help you this following code.

Dim db As Database
Dim rs As Recordset

Private Sub Form_Load()

MSFlexGrid1.Clear
MSFlexGrid1.Rows = 2
MSFlexGrid1.Cols = 7

Set db = DBEngine.OpenDatabase(App.Path & "\sample.mdb")
Set rs = db.OpenRecordset("table1")
On Error Resume Next ' to ignore the error
rs.MoveFirst ' this line can be error if no records in the table

Do Until rs.EOF
MSFlexGrid1.Row = MSFlexGrid1.Rows - 1

Griddisply

MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
rs.MoveNext
Loop

End Sub

Sub Griddisply()
Dim a As Integer
For a = 0 To 7
MSFlexGrid1.Col = a
MSFlexGrid1 = rs(a)
Next a
End Sub

[cutecatcher]

Good pm!

i forgot to say that i am using a C# programming language, Can you give me a code in C# that also transfer data from a database to flexgrid?

tnx!

Good day!

Hello,

I want to give some Idea if I can help you this following code.

Dim db As Database
Dim rs As Recordset

Private Sub Form_Load()

MSFlexGrid1.Clear
MSFlexGrid1.Rows = 2
MSFlexGrid1.Cols = 7

Set db = DBEngine.OpenDatabase(App.Path & "\sample.mdb")
Set rs = db.OpenRecordset("table1")
On Error Resume Next ' to ignore the error
rs.MoveFirst ' this line can be error if no records in the table

Do Until rs.EOF
MSFlexGrid1.Row = MSFlexGrid1.Rows - 1

Griddisply

MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
rs.MoveNext
Loop

End Sub

Sub Griddisply()
Dim a As Integer
For a = 0 To 7
MSFlexGrid1.Col = a
MSFlexGrid1 = rs(a)
Next a
End Sub

[brazel]

Hello,

Sorry I'm not so familiar in C#, I looked at Microsoft Visual C# 2005 Express Edition, I can't see if they have a flixgrid, only Datagridview.

[cutecatcher]

i just added that component in C#.. wooh! this was really tough! i cannot find anything in the net.. well, thanks anyway! Godbless