database design
-
Hi, my database is Ms-Access database.. iam doing product based application(windows application) i have to store data based on the invoice number... invoice number is (primarykey) based on invoice number i have to store multiple items reports when i select invoice number those items should be displayed... please help me
murali krishna
-
Hi, my database is Ms-Access database.. iam doing product based application(windows application) i have to store data based on the invoice number... invoice number is (primarykey) based on invoice number i have to store multiple items reports when i select invoice number those items should be displayed... please help me
murali krishna
Hi, Just write the query with where condition. for eg. select * from tablename where invoicenumber='xyz'
Regards, Ujjaval Modi
-
Hi, Just write the query with where condition. for eg. select * from tablename where invoicenumber='xyz'
Regards, Ujjaval Modi
Hi Thanks for your reply... my problem is my database is (ms-access) database ihave to store multiple items in one invoice number(primary) invoiceNo items units 1 Nokia6600 4 Nokia6633 5 Nokia6030 3 2 Nokia 1300 2 Nokia 1100 3 like this ....(database design) and coding in c# application
murali krishna
-
Hi Thanks for your reply... my problem is my database is (ms-access) database ihave to store multiple items in one invoice number(primary) invoiceNo items units 1 Nokia6600 4 Nokia6633 5 Nokia6030 3 2 Nokia 1300 2 Nokia 1100 3 like this ....(database design) and coding in c# application
murali krishna
What exactly do u want ? A database design or u already have one ?
Regards, Ujjaval Modi
-
What exactly do u want ? A database design or u already have one ?
Regards, Ujjaval Modi
Hi, yes i want database design
murali krishna
-
Hi, yes i want database design
murali krishna
Just mention clearly that u want a working sample.
Regards, Ujjaval Modi
-
Just mention clearly that u want a working sample.
Regards, Ujjaval Modi
Hi, ya if it is ok ---- clearly i want database design and query for inserting and selecting that that particular table i have to desing table like this invoiceNo(primarykey),products,units,Cost in this one invoice number should consists od mmultiple products information.... this is main i Want ..
murali krishna
-
Hi, ya if it is ok ---- clearly i want database design and query for inserting and selecting that that particular table i have to desing table like this invoiceNo(primarykey),products,units,Cost in this one invoice number should consists od mmultiple products information.... this is main i Want ..
murali krishna
i think your datatable should designed as follows: ProductedId(pk) Products units TypeId 1 Nokia1600 2 1 2 Nokia1700 5 1 3 Nokia1800 6 1 4 Nokia2600 2 2 5 Nokia4600 8 2 6 Nokia8100 2 3 7 Nokia8300 1 3 8 Nokia56 6 3 9 Nokia1310 2 3 Connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; query sentence: select * from products where typeid=x; hope it will work as you wanted.
modified on Saturday, December 29, 2007 11:57:04 PM