c# - database query questions or other solutions for comparing data between 2 tables -


I am creating a Windows application form using Visual Studio 2010. For now, I am in this situation:

I allow users to add items to the system, each item has their own separate brand, cost & amp; Suppliers and sales prices for different customers.

For example, Item 1, Name: ABC, Brand: TIM and Item 2, Name: ABC, Brand: LD.

When users want to enter information about cost and suppliers in Item1, when they click on the "Shockest" button, another window form will pop out to fill the users. And for this, I'm planning to use DataGridView. I am planning to use item and brand for the item

So this is my question, how do I set a query or other solution to ask how the name and brand of item which Users enter, they will show the price and price of specific items? What is the question I have to ask?

I have created 3 database tables, which include iteminfo (name, brand, etc.), costlist (name, brand, supplier name, cost) and sales price (name, brand, customer name, sale price) .

"text">

If you are using a database You should consider using the primetime key. In this way you can store information about a certain item in any other item. In all three tables you use name and brand. I would like to model my tables like this:

Items

  • Item ID (make this field an Auto Mounting Integer field)
  • Brand
  • Suppliers
  • Price

    Customers

  • Customer name
  • Customer name
  • Discount payment
  • PhononR

    • Supplier
    • Provider name

      Field Supplier ID in a client table is an uniqueness Number. So when you want to refer to the supplier, you fill in the supplier's ID easily. For example item id in item table is the unique identifier for an item. The Suppliers ID field refers to the supplier ID field in the Suppliers table. To make sure that your data continues to be continued, I would advise you to use foreign key constraints. This ensures that you can not fill any invalid ID

      Here is a short film that explains something

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more