C#, ADO.NET and MS-SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DJ van Vliet (dougie_at_global.co.za)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 13:21:47 +0200

Hi All,

Question regarding the processes between C#, ADO.NET and MS-SQL

I need to understand the complexities of using the distributed method
(ADO.NET) of data retrieval and the subsequent update of database with
regard to transactions.

E.G. - Stock Item Purchase Order.

Header:
Ledger, Supplier, Order Number

Details:
Store, Item, Qty, UnitPrice

Header Entry:
database: BeginTransaction
1.Enter/Select Ledger
  Store all ledger details on client when loading app
  or
  Use a search form, allowing the user to enter details. Use a Reader to
retrieve matching Ledgers.
2.Enter/Select/Create Supplier
  Store all Supplier details - not practical?
  or
  Use search form, allowing user to enter details. If the user has the
proper authority, a new Supplier may be entered. Use reader to retrieve
matching Suppliers.

Detail Entry:
Basically the same principal for the Store and Item codes

Accept Order:
database: EndTransaction

It does not seem (to me) that the DBAdapter will be useful as I need to
obtain data as the user enters/selects the Ledger, Supplier, Store and
Item fields. I cannot store potential data because I have no idea what
will be selected (the Ledger and Store fields could be stored as they
are fairly static)

Should I design the above process by using my own version of storage and
not using the DBAdapter. If so, I am looking at a real-time system as
apposed to the ADO.NET model (disconnected)

I hope my question is not a clear as mud.

Dougie

Relevant Pages

  • Re: C#, ADO.NET and MS-SQL
    ... interactive connection to the database while the user is busy capturing ... a supplier is required and Items will be ordered. ... selection of Ledger and Supplier. ... selection of Store and Items ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: C#, ADO.NET and MS-SQL
    ... with the database on a UI in a very unconventional way. ... > Ledger, Supplier, Order Number ... > Store, Item, Qty, UnitPrice ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: Access combo box-show name, not ID, in table?
    ... there a better way to link to the Supplier Table that I'm missing? ... Put another way, why duplicate the table with a query, if I can ... Those queries need to be left join queries.. ... but I have to ask: If the normal and recommended way is to store ...
    (microsoft.public.access.gettingstarted)
  • Re: DOCX FILE CORRUPTED WHEN RETRIEVED FROM SQL2005
    ... I am facing the same problem and would appreciate your reply on the same as it has become a show stopper for me now. ... My Code is given below to retrieve the docx content from SQL 2005 whose data type is image. ... Here is the code where i insert the file into database. ... when I store these files to the server, using the code below and similar ...
    (microsoft.public.office.developer.vba)