Click here to Skip to main content
16,004,977 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to .Net Remote? Pin
Ray Cassick5-Sep-06 18:41
Ray Cassick5-Sep-06 18:41 
GeneralRe: How to .Net Remote? Pin
rudemusik6-Sep-06 16:06
rudemusik6-Sep-06 16:06 
Questionfree component Pin
aspnet_222-Sep-06 11:31
aspnet_222-Sep-06 11:31 
AnswerRe: free component Pin
Dave Kreskowiak3-Sep-06 2:01
mveDave Kreskowiak3-Sep-06 2:01 
GeneralRe: free component Pin
aspnet_225-Sep-06 21:03
aspnet_225-Sep-06 21:03 
GeneralRe: free component Pin
Dave Kreskowiak6-Sep-06 1:54
mveDave Kreskowiak6-Sep-06 1:54 
Questionllofree component Pin
aspnet_222-Sep-06 11:27
aspnet_222-Sep-06 11:27 
QuestionINSERT, DELETE, UPDATE Staments for 2 tables [modified] Pin
R. A. Abbasi2-Sep-06 9:09
R. A. Abbasi2-Sep-06 9:09 
In VB.NET 2005, INSERT, DELETE, UPDATE Staments for a TableAdapter can be generated automatically by the TableAdapter Configuration Wizard; but not for the two related tables.

I find it very hard creating these statements manually. I request the members of this forum to help me with some examples.

My question is more explained as below:
I am using the following SQL statement:

SELECT tblDrugs.DrugID AS DrugID, tblDrugs.DrugName, <br />
                         tblDrugs.PriceID AS PriceID, <br />
                         tblPrices.* <br />
FROM tblDrugs LEFT JOIN <br />
                 tblPrices ON tblDrugs.PriceID = tblPrices.PriceID 


When my VB2005 program executes the following statement:

Me.taDrugs.Update(Me.myDataSet.tblDrugs)

The above Update method expects the relevant Update statement, which has to be provided manually in this case - because TableAdapter Configuration Wizard does not generate this statement for the SELECT with 2 related tables (joined).

What I want is the Update statement, which can satisfy the Update method of the TableAdapter - taDrugs in the above code.
QuestionPassword Protection in vb.net 1.1 Pin
amaneet2-Sep-06 3:37
amaneet2-Sep-06 3:37 
AnswerRe: Password Protection in vb.net 1.1 Pin
Dave Kreskowiak2-Sep-06 7:01
mveDave Kreskowiak2-Sep-06 7:01 
Questionmigrating from crystal report 8.5 to 10.0 giving error Pin
prashanttcs2-Sep-06 2:53
prashanttcs2-Sep-06 2:53 
QuestionBasic Question: String declaration with "child values" Pin
re infecta2-Sep-06 0:28
re infecta2-Sep-06 0:28 
AnswerRe: Basic Question: String declaration with "child values" Pin
Guffa2-Sep-06 13:06
Guffa2-Sep-06 13:06 
GeneralRe: Basic Question: String declaration with "child values" Pin
re infecta2-Sep-06 13:37
re infecta2-Sep-06 13:37 
AnswerRe: Basic Question: String declaration with &quot;child values&quot; Pin
Guffa2-Sep-06 15:58
Guffa2-Sep-06 15:58 
GeneralRe: Basic Question: String declaration with "child values" Pin
re infecta2-Sep-06 21:39
re infecta2-Sep-06 21:39 
Questiondynamic setup preparation Pin
Pradip Kishore2-Sep-06 0:24
Pradip Kishore2-Sep-06 0:24 
QuestionBubble up User Control event Pin
FreQi1-Sep-06 15:57
FreQi1-Sep-06 15:57 
AnswerRe: Bubble up User Control event Pin
Dave Kreskowiak2-Sep-06 7:39
mveDave Kreskowiak2-Sep-06 7:39 
AnswerRe: Bubble up User Control event Pin
Davelister3-Sep-06 6:45
Davelister3-Sep-06 6:45 
QuestionRe: Bubble up User Control event Pin
FreQi3-Sep-06 8:14
FreQi3-Sep-06 8:14 
QuestionRemoving items from CheckedListBox Pin
The ANZAC1-Sep-06 14:11
The ANZAC1-Sep-06 14:11 
AnswerRe: Removing items from CheckedListBox Pin
Davelister3-Sep-06 7:00
Davelister3-Sep-06 7:00 
GeneralRe: Removing items from CheckedListBox Pin
The ANZAC3-Sep-06 11:14
The ANZAC3-Sep-06 11:14 
GeneralRe: Removing items from CheckedListBox Pin
Davelister4-Sep-06 10:37
Davelister4-Sep-06 10:37 

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.