Click here to Skip to main content
16,010,544 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: DropDown Selection Box Pin
Dave Kreskowiak28-Jan-05 6:25
mveDave Kreskowiak28-Jan-05 6:25 
GeneralCalling VB DLLs from C Pin
Rusty7828-Jan-05 3:08
Rusty7828-Jan-05 3:08 
GeneralRe: Calling VB DLLs from C Pin
rwestgraham30-Jan-05 17:41
rwestgraham30-Jan-05 17:41 
QuestionHow to pass parameter to VC function like this? Pin
rushing27-Jan-05 23:55
rushing27-Jan-05 23:55 
Generalfilling a DataTable Pin
lxhan27-Jan-05 18:51
lxhan27-Jan-05 18:51 
GeneralRe: filling a DataTable Pin
The Man from U.N.C.L.E.27-Jan-05 23:15
The Man from U.N.C.L.E.27-Jan-05 23:15 
GeneralRe: filling a DataTable Pin
lxhan1-Feb-05 3:37
lxhan1-Feb-05 3:37 
GeneralRe: filling a DataTable Pin
mtone28-Jan-05 3:11
mtone28-Jan-05 3:11 
I assume connDF is valid somewhere else And you are not even using sqlQuery.
I believe that the table needs to be part of a dataset for the adapter to fill.
    <br />
        Dim ds As new DataSet<br />
        Dim dt As DataTable<br />
        dt.TableName="InvDate"<br />
        ds.Tables.Add(dt)<br />
<br />
    Dim connection as string = "Whatever your connection string"<br />
    Dim conn As New OleDbConnection(connection)<br />
    Dim adapter As New OleDbDataAdapter()<br />
    adapter.SelectCommand = new OleDbCommand(CmdqueryInvoice, conn)<br />
    adapter.Fill(ds.tables("InvDate"))<br />
<br />
        Dim LoopRow As Data.DataRow<br />
<br />
        For Each LoopRow In ds.tables("InvDate")Rows<br />
               .....<br />
        Next<br />


If that does not work look at how the dataadapter processes joins. It may be the adapter will create the joined tables in the dataset but it will not automatically set the primary keys for the relationship. You may need to create the table schemas in the dataset then fill it. too much trouble? return a datareader and create your own columns and insert the data. Or just loop thru the reader.
GeneralRe: filling a DataTable Pin
lxhan1-Feb-05 3:42
lxhan1-Feb-05 3:42 
GeneralBandObject Help Pin
Member 165616027-Jan-05 12:13
Member 165616027-Jan-05 12:13 
GeneralRe: BandObject Help Pin
Dave Kreskowiak28-Jan-05 3:42
mveDave Kreskowiak28-Jan-05 3:42 
Generalcreate word application in vb.net Pin
Member 162996427-Jan-05 11:02
Member 162996427-Jan-05 11:02 
GeneralSuppressing Save as Dialog box Pin
Anonymous27-Jan-05 10:58
Anonymous27-Jan-05 10:58 
Generalbound listbox duplicates displaymember after edit Pin
Mark Payton27-Jan-05 10:45
Mark Payton27-Jan-05 10:45 
GeneralRounding Pin
superprogrammingdude27-Jan-05 10:25
superprogrammingdude27-Jan-05 10:25 
GeneralRe: Rounding Pin
Dave Kreskowiak27-Jan-05 10:37
mveDave Kreskowiak27-Jan-05 10:37 
GeneralCheckBoxes in Detail of Master/Detail Datagrid Pin
dhorne4127-Jan-05 9:56
dhorne4127-Jan-05 9:56 
GeneralInstall windows service application Pin
leezardd27-Jan-05 9:07
leezardd27-Jan-05 9:07 
GeneralRe: Install windows service application Pin
Dave Kreskowiak27-Jan-05 10:34
mveDave Kreskowiak27-Jan-05 10:34 
GeneralRe: Install windows service application Pin
leezardd28-Jan-05 5:09
leezardd28-Jan-05 5:09 
QuestionCommand execute??? Pin
charleslau285527-Jan-05 4:25
charleslau285527-Jan-05 4:25 
AnswerRe: Command execute??? Pin
Dave Kreskowiak27-Jan-05 4:52
mveDave Kreskowiak27-Jan-05 4:52 
Generalpopulate list view in VB from VC++ dll using SendMessage Api Pin
Mohamed Jaffar Sagir26-Jan-05 23:35
Mohamed Jaffar Sagir26-Jan-05 23:35 
GeneralRe: populate list view in VB from VC++ dll using SendMessage Api Pin
Dave Kreskowiak27-Jan-05 4:41
mveDave Kreskowiak27-Jan-05 4:41 
GeneralRe: populate list view in VB from VC++ dll using SendMessage Api Pin
rwestgraham30-Jan-05 18:02
rwestgraham30-Jan-05 18:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.