Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Since you are retrieving data from both tables in your database but want to combine them in your application, the solution would be to create a single class that contains the data you return from your stored procedure:</p> <pre><code>public class MAllOrderDetails { public int ID { get; set; } public string BillingName { get; set; } // include the other billing details you want here public int OrhID { get; set; } public int ProID { get; set; } public string Name { get; set; } public int Quantity { get; set; } public double Rate { get; set; } public double Amount { get; set; } public int DeliveredQty { get; set; } } </code></pre> <p>Then, your query changes to filling in a <code>List&lt;MAllOrderDetails&gt;</code>.</p> <p>This leaves your application with only dealing with a collection of a single class with all the data nicely contained in single objects.</p> <pre><code>var mylist = new List&lt;MAllOrderDetails&gt;(); //... while (_dr.Read()) { mylist.Add(new MAllOrderDetails { ID = Convert.ToInt32(_dr["ordID"]), BillingName = _dr["BillingName"].ToString(), // etc. OrhID = Convert.ToInt32(_dr["orhID"]), ProID = Convert.ToInt32(_dr["proID"]), Name = _dr["pName"].ToString(), Quantity = Convert.ToInt32(_dr["ordQty"]), Rate = Convert.ToDouble(_dr["ordRate"]), Amount = Convert.ToDouble(_dr["ordAmount"]), DeliveredQty = Convert.ToInt32(_dr["ordQtyDelivered"]) }); } </code></pre> <p><strong>Update</strong></p> <p>You could probably get away with this as the closest solution to not creating an additional classes:</p> <pre><code>class MAllOrderDetails { public MOrder Order { get; set; } public MOrderMain OrderMain { get; set; } } </code></pre> <p>I feel, though, that from a maintainability standpoint, this will cause you more headaches than just creating additional classes.</p>
    singulars
    1. This table or related slice is empty.
    1. POAccessing properties from multiple classes
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBrad Rem
    1. USBrad Rem
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI have this Way but i want to keep the classes different. Is there any way that i can do inheritance or interface ?
      singulars
      1. PO
      1. USMoiz
    2. CO@MoizKachwala, I don't think inheritance or using interfaces will help you with this, but I have updated my answer to include the only solution I can think of to limit the number of classes you have. I still recommend creating a new class, even if it duplicates some properties of other classes, because it will be much easier to maintain. Trying to save on duplicating classes up front is going to cost you later on as you try to work with them.
      singulars
      1. PO
      1. USBrad Rem
    3. COthanks for the reply. i did that way by creating a new class and i make some field duplicate.
      singulars
      1. PO
      1. USMoiz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload