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,995
Messages
2,570,230
Members
46,819
Latest member
masterdaster

Latest Threads

Top