How do I populate Container.DataItems using a Multi-table ds?

J

JDP@Work

I may have painted myself into a corner and am willing to use a different
method.

This is an old form, prior to implementing SQLHelper which I'm using with
MainForm.vb

Any suggestions are welcome.

Here is my current fill and one sample field from my form.

The form is a printable version of a mster form.

If I'm not mistaken the noted "Lead" table is the default view/table, how would
I name and or access on the form additional tables that are returned by the
sProc.

myform.vb
....
daLead.SelectCommand = cmdGetLead
daLead.Fill(dsLead, "Lead")
Me.LeadProfile.DataSource = dsLead.Tables("Lead")
....

myform.aspx
....
Source:&nbsp<%# DataBinder.Eval(Container.DataItem, "Source") %>
....

This is not a challenge on my other forms where I use...

MainForm.vb
....
Dim dr As DataRow = ds.Tables(0).Rows(0)

... fill a bunch of controls.....

If Not IsDBNull(ds.Tables(1).Rows(0)) Then
Dim dr_inf As DataRow = ds.Tables(1).Rows(0)

... fill a few more controls....
end sub

TIA

JeffP.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top