Salakhetdinov Shamil
mcp2004 at mail.ru
Sat Feb 4 14:20:20 CST 2012
Hi Arthur -- Have a look at http://northwind.codeplex.com/ It presents just a few of myriad possible ways to make .NET (C#) data bound UI and reports with MS Access and MS SQL backends. What is definitely to consider for beginners is to investigate, learn and use C# custom controls - when one develops complex WinForms (or WPF forms or SilverLight forms...) without usage of custom controls they quickly get "spaghetti code nightmare" - and the referred above set of projects does use custom controls... Thank you. -- Shamil 04 февраля 2012, 22:15 от Arthur Fuller <fuller.artful at gmail.com>: > I have been Googling and trying to find something meaningful in the way of > C# sample apps, and falling short just about everywhere I turn. I am trying > to surmount this hurdle. I have downloaded a bunch of examples that have > nothing at all to do with databases, which is my principal concern, and so > all these graphic examples are of little or no interest to me as a > (primarily) database developer. > > Access 2007 came with a Time&Billing sample that I like a lot. I have > customized it to suit my needs. It's the perfect small app for me to learn > my chops in: a few tables, a few listforms, a click on the PK opens the one > of interest, etc. > > Can anyone provide me to a few links or samples which will help guide me > into this new world? I have built a few apps that do not concern databases > (MDI text editor etc.), but I need to move on to the world of DB access, > starting with small stuff and gradually escalating to 20-table apps and > then 40-table apps and then 100-table apps; I'm assuming that after that, > I'll be able to figure out the rest. > > Meanwhile I have several questions, which may reveal my old-school premises: > > 1. Why would I want to use DLinq as opposed to firing sprocs? I absolutely > have missed the boat on this one. > 2. In a 10-table app, how many DataLinks and SQLAdapters etc. do I need? > 3, How does one present a GridView upon which a double-click invokes a > one-row edit/insert form, then return to the refreshed list? > 4. Assuming we're abandoning the convenience of Access's Switchboard menu > system, what is proposed instead? > 5. I have a UI-problem with the typical hierarchical presentation of data. > I do not want a list of Customers to invoke another list of > CustomerProjects, and thence their details, and so on. What I want up front > is a list of Incomplete Projects, prioritized by Immediacy. Double-clicking > on one of those ought to open a tabbed form that lists HoursLogged, > ExpensesIncurred, PaymentsMade, and so on. > > No example that I have yet encountered shows me how to build this sort of > app. I'm looking for such an example but failing to find it. Can anyone > provide me with such a link? > > -- > Arthur > Cell: 647.710.1314 > > Only two businesses refer to their clientele as users: drug dealers and > software developers. > > -- Arthur Fuller > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >