Question "There is no row at position 0" error

[miss.jamie]

hello guys, please kindy help me..
im going to select a record from my datagridview, but its showing an error " There is no row at position 0."

here's my code..

Dim sqlQuery As String = "SELECT doctable.FORM_NO, doctable.LASTNAME, doctable.FIRSTNAME, doctable.MATERNALNAME, doctable.SEX, " _
& " doctable.RESSTREET, doctable.RESPRECINCT, doctable.RESPRECINCTCODE, doctable.RESBARANGAY, doctable.RESCITY, " _
& " doctable.RESPROVINCE, doctable.REGBARANGAY, doctable.REGCITY, doctable.REGPROVINCE, doctable.DATE, " _
& " doctable1_pinfo.PERIODCITYYEAR, doctable1_pinfo.PERIODCITYMONTH, doctable1_pinfo.PERIODPHILYEAR, " _
& " doctable1_pinfo.EMAIL, doctable1_pinfo.DOBYEAR, doctable1_pinfo.DOBMONTH, doctable1_pinfo.DOBDAY, " _
& " doctable1_pinfo.BIRTHCITY, doctable1_pinfo.BIRTHPROVINCE, doctable1_pinfo.PROFESSION, doctable1_pinfo.HEIGHT, " _
& " doctable1_pinfo.WEIGHT, doctable1_pinfo.TIN, doctable2_family.FLASTNAME, doctable2_family.FFIRSTNAME, " _
& " doctable2_family.FMATERNALNAME, doctable2_family.MLASTNAME, doctable2_family.MFIRSTNAME, " _
& " doctable2_family.MMATERNALNAME, doctable2_family.CIVILSTATUS, doctable2_family.SPOUSENAME, " _
& " doctable3_citizen.CITIZENSHIP, doctable3_citizen.CITIZENSHIP_FILIPINO, doctable3_citizen.NATDAY, " _
& " doctable3_citizen.NATMONTH, doctable3_citizen.NATYEAR, doctable3_citizen.CERTIFICATENB, doctable4_disable.DISABLED, " _
& " doctable4_disable.ASSISTEDBY, doctable5_eo.APPTYPE, doctable5_eo.INTERVIEWER, doctable5_eo.EONAME, " _
& " doctable5_ePERATOR, biometrics.picture, biometrics.signature, biometrics.fp1, biometrics.fp2 " _
& " from (doctable LEFT JOIN doctable1_pinfo ON doctable.FORM_NO = doctable1_pinfo.FORM_NO) " _
& " LEFT JOIN doctable2_family ON doctable1_pinfo.FORM_NO = doctable2_family.FORM_NO " _
& " LEFT JOIN doctable3_citizen ON doctable2_family.FORM_NO = doctable3_citizen.FORM_NO " _
& " LEFT JOIN doctable4_disable ON doctable3_citizen.FORM_NO = doctable4_disable.FORM_NO " _
& " LEFT JOIN doctable5_eo ON doctable4_disable.FORM_NO = doctable5_eo.FORM_NO " _
& " LEFT JOIN biometrics ON doctable5_eo.FORM_NO = biometrics.FORM_NO " _
& " WHERE doctable.form_no = '" & DataGridView1.SelectedRows(0).ToString & "';"


Dim sqlTable As New DataTable

sqlTable = DBTools.MySql_FetchDataTable(sqlQuery, myDatabase)

Compute_VIN.form_no = DataGridView1.SelectedRows(0).ToString
Compute_VIN.lname = sqlTable.Rows(0)("lastname")
Compute_VIN.fname = sqlTable.Rows(0)("doctable.firstname")
Compute_VIN.mname = sqlTable.Rows(0)("doctable.maternalname")
Compute_VIN.ShowDialog()

please .. thank you

 

[Menthos]

Firstly, google 'using table aliases in mysql' and clean that query up - that is just plain nasty.

Secondly, pop a break in your code after that (nasty) query, copy what the value of the query string and drop it into a query window on whatever you're using to manage mySQL -there'll be an error in there somewhere.