DATAGRID CONTROL using MySQL database - nothing happens

dualshock03

Well-known member
Joined
Jan 28, 2007
Messages
105
Programming Experience
1-3
:)hello I would like to ask help regarding this DATAGRID control in VB.NET.

Im using a MySQL database with an ADODB connection in my datagrid control and facing multiple errors in retrieving data from MySQL connecting to my datagrid..

I’m trying to view the records in the database using the grid but nothing happens with my codes. Im recieving an error: Child List for field "FILI01 OLM SMG Sandigan I cannot be created"

See my attachment

please reply any suggestions.. i want to know the right process for this.

=========================================================
here is one of my codes:
=========================================================

Private Sub Adminform_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

lblcurrentuser.Text = strname

Call openSubjInfo()

Rst1 = consub.Execute("SELECT * FROM filipino_macanip")
DataGridViewdefault.RowCount = 1

Do While Rst1.EOF = False

DataGridViewdefault.DataSource = Rst1
DataGridViewdefault.DataMember = (Rst1.Fields("Subjects").Value &
vbTab & Rst1.Fields("Section A").Value & vbTab & Rst1.Fields("Section B").Value & vbTab & Rst1.Fields("Description").Value)

Rst1.MoveNext()


Loop


End Sub

=========================================================

if you can give me any links about this problem i will appreciate it.:eek: tnx


STATUS:
I.T. Student

Software Proficient:

Macromedia Flash - 70%
Macromedia Dreamweaver - 80%
Adobe Photoshop 8.0 - 75%
Visual Basic Express Edition 2005 - 45%
Turbo C/C++ - 35%
C# - 40%
Java - 50%
 

Attachments

  • Error image.PNG
    Error image.PNG
    82.1 KB · Views: 28
Last edited:
Back
Top