thanks for all pepole that answer my question (and because my english is not good i can't find the words that express my felling...) ok, it's fine, i build the query that will create my friendly table and i generated the dataset that will hold the results and bind it to a datagrid (it is not possible to bind an order form to textboxes or anything else!! the datagrid is the excellent choice), but there is 2 problem i think: the first problem is what will happen if the user decide to make a change to the order ? the second problem is that i use the Ado.Net (and dataset) because i can use the data in a 'disconnected world' ! this mean that i need to work with the data for a long time (2 day maybe) befor i send finaly the data to the databse. so i can't use the T_Sql queries ! (because i need a connection to the datasource that is not availalble all the time !). so i always connect to the datasource, copy a portion of data to a local XML file, save it to disk to work with it, so i always work with DataView objects to make my queries ! my datasource is most the time is a local XML file that a dataset object will read when the application start !! so what is the solution !!

I don't know yet if anyone has this problem! Let's say that I have a database that will store all the information about an order and items and customers… each have a table that is related to the other… The Problem is that the design of the database is not friendly to the user, this mean if I want to put a Data Grid and bind it to the OrderDetails table, then the user will see the ItemId and not the ItemName (Of cores, because the database is well normalized !). So, to work around this problem a made another User-Friendly table and each time the user ask to see an order detail, the code will translate the data from the original Unfriendly table to the friendly table… This worked fine, but what I would do if the user decides to make changes to the order? Again I have to copy the data from the User-Friendly table to the database (unfriendly table!). This is a complex operation and very hard to do, especially if there is a large number of a table I work with in my original database… I have the same problem if I want to use crystal report! Because crystal report will not deal with a large number of related tables, I am forced to make a new table that is a copy of my report design, and each time the user ask to print a report, the data will be transformed to this table, so crystal report can deal with it fine and print the report !! The question is: if there is a problem with my design concept or I should built a new object that inherit from the dataset object and can join tables together and can send the data back to the original database??? And how to do this??

I don't know yet if anyone has this problem! Let's say that I have a database that will store all the information about an order and items and customers… each have a table that is related to the other… The Problem is that the design of the database is not friendly to the user, this mean if I want to put a Data Grid and bind it to the OrderDetails table, then the user will see the ItemId and not the ItemName (Of cores, because the database is will normalized !). So, to work around this problem a made another User-Friendly table and each time the user ask to see an order detail, the code will translate the data from the original Unfriendly table to the friendly table… This worked fine, but what I would do if the user decides to make changes to the order? Again I have to copy the data from the User-Friendly table to the database (unfriendly table!). This is a complex operation and very hard to do, especially if there is a large number of a table I work with in my original database… I have the same problem if I want to use crystal report! Because crystal report will not deal with a large number of related tables, I am forced to make a new table that is a copy of my report design, and each time the user ask to print a report, the data will be transformed to this table, so crystal report can deal with it fine and print the report !! The question is: if there is a problem with my design concept or I should built a new object that inherit from the dataset object and can join tables together and can send the data back to the original database??? And how to do this??

Hi, i have a big question i think ! How i can make a communication with a casio cash registers device with a computer program using visual basic.net (or any other language !), please if there is any API for this purpose tell me please !!