Click here to Skip to main content
15,901,373 members
Home / Discussions / C#
   

C#

 
GeneralWeb page form controls Pin
Nosheen Iqbal21-Dec-04 16:32
Nosheen Iqbal21-Dec-04 16:32 
GeneralRe: Web page form controls Pin
Heath Stewart22-Dec-04 9:25
protectorHeath Stewart22-Dec-04 9:25 
GeneralFileSystemWatcher Pin
Rafferty Uy21-Dec-04 15:59
Rafferty Uy21-Dec-04 15:59 
GeneralRe: FileSystemWatcher Pin
Dave Kreskowiak22-Dec-04 5:47
mveDave Kreskowiak22-Dec-04 5:47 
GeneralFlash & C# Pin
mszulman21-Dec-04 9:03
sussmszulman21-Dec-04 9:03 
GeneralRe: Flash & C# Pin
Heath Stewart21-Dec-04 12:44
protectorHeath Stewart21-Dec-04 12:44 
GeneralRe: Flash & C# Pin
J4amieC21-Dec-04 22:29
J4amieC21-Dec-04 22:29 
GeneralRelation between Tables a dataset Pin
Gedrain21-Dec-04 8:57
Gedrain21-Dec-04 8:57 
Hello,

i have 2 tables "products" and "suppliers"

the table products and suppliers has the following columns:

Table "products":
product_id, name, price, product_code, supplier (id of the table suppliers column supplier_id)

data:

product_id name price product_code supplier
151432 Summer Tire 56,33 tire00111 3
151476 Winter Tire 31,63 tire00421 4


Table "suppliers"
supplier_id, name


data:
supplier_id name
3 Michelin
4 Bridgestone


Well my problem is how do i solve this problem: Products is the main table when insert a new product from a new supplier, i need first insert the new supplier into the table suppliers after that i need to retrieve the id from the new supplier for the insertion of the new product in the products table. Can somebody give me a example for this?

thanx!

greetings

Sander



GeneralRe: Relation between Tables a dataset Pin
Heath Stewart21-Dec-04 12:51
protectorHeath Stewart21-Dec-04 12:51 
GeneralRe: Relation between Tables a dataset Pin
Gedrain21-Dec-04 23:08
Gedrain21-Dec-04 23:08 
GeneralRe: Relation between Tables a dataset Pin
Heath Stewart22-Dec-04 6:18
protectorHeath Stewart22-Dec-04 6:18 
GeneralRe: Relation between Tables a dataset Pin
Gedrain22-Dec-04 7:22
Gedrain22-Dec-04 7:22 
GeneralRe: Relation between Tables a dataset Pin
Heath Stewart22-Dec-04 9:20
protectorHeath Stewart22-Dec-04 9:20 
GeneralDoubleClick and Click Events ... Left Mouse Button Pin
new_phoenix21-Dec-04 8:49
new_phoenix21-Dec-04 8:49 
GeneralRe: DoubleClick and Click Events ... Left Mouse Button Pin
Heath Stewart21-Dec-04 13:01
protectorHeath Stewart21-Dec-04 13:01 
GeneralTabPage and DataGrid - weird behavor Pin
Wjousts21-Dec-04 6:23
Wjousts21-Dec-04 6:23 
GeneralUsing WMI Pin
realmontanakid21-Dec-04 4:58
realmontanakid21-Dec-04 4:58 
GeneralRe: Using WMI Pin
Heath Stewart21-Dec-04 12:41
protectorHeath Stewart21-Dec-04 12:41 
GeneralC# app stopping windows from shutting down Pin
mikey_g21-Dec-04 2:56
mikey_g21-Dec-04 2:56 
GeneralRe: C# app stopping windows from shutting down Pin
Michael Potter21-Dec-04 5:07
Michael Potter21-Dec-04 5:07 
General.NET DLL with Main() method to be put on separate process Pin
Kausthubh Rajendran21-Dec-04 2:47
Kausthubh Rajendran21-Dec-04 2:47 
GeneralRe: .NET DLL with Main() method to be put on separate process Pin
CoolDadTx21-Dec-04 4:02
CoolDadTx21-Dec-04 4:02 
QuestionCompiler directive for classname/membername insert ? Pin
fracalifa21-Dec-04 2:26
fracalifa21-Dec-04 2:26 
AnswerRe: Compiler directive for classname/membername insert ? Pin
Daniel Turini21-Dec-04 4:37
Daniel Turini21-Dec-04 4:37 
AnswerRe: Compiler directive for classname/membername insert ? Pin
leppie21-Dec-04 9:38
leppie21-Dec-04 9:38 

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.