Te completo la rta acerca de la cosulta con el codigo, el codigo esta adi
'SqlDataAdapter1
'
Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1
Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "fin_t_ord_pag_par", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("codnivel", "codnivel"), New System.Data.Common.DataColumnMapping("Expr1", "Expr1"), New System.Data.Common.DataColumnMapping("coddocordpag ", "coddocordpag"), New System.Data.Common.DataColumnMapping("nomdocordpag ", "nomdocordpag"), New System.Data.Common.DataColumnMapping("condocordpag ", "condocordpag"), New System.Data.Common.DataColumnMapping("tipodocu", "tipodocu"), New System.Data.Common.DataColumnMapping("numcue", "numcue"), New System.Data.Common.DataColumnMapping("fec_crea", "fec_crea"), New System.Data.Common.DataColumnMapping("fec_ult_mod" , "fec_ult_mod"), New System.Data.Common.DataColumnMapping("usu_crea", "usu_crea"), New System.Data.Common.DataColumnMapping("us
lt_mod" , "us
lt_mod")})})
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT fin_t_ord_pag_par_det.codnivel, fin_t_ord_pag_par_det.coddocordpag AS Expr" & _
"1, fin_t_ord_pag_par.coddocordpag, fin_t_ord_pag_par.nomdocordpag, fin_t_ord_pag" & _
"_par.condocordpag, fin_t_ord_pag_par.tipodocu, fin_t_ord_pag_par.numcue, fin_t_o" & _
"rd_pag_par.fec_crea, fin_t_ord_pag_par.fec_ult_mod, fin_t_ord_pag_par.usu_crea, " & _
"fin_t_ord_pag_par.us
lt_mod FROM fin_t_ord_pag_par INNER JOIN fin_t_ord_pag_pa" & _
"r_det ON fin_t_ord_pag_par.coddocordpag = fin_t_ord_pag_par_det.coddocordpag"
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
Es el generado x el diseñador.
