[AccessD] Examples In Best Coding VB.net

[Paul Hartland]

I did actually cross post this query to the access group and the dba-vs,
only answers I got were from here....

I am not really after a job developing, the main thing I want to do at the
moment is convert my access application into C# as mainly a learning
experience, I just need to know how to use classes and the framework
properly hence my request for an example of even just a single form in my
original post

"So could anyone point me in the right direction for (should I say) best
coding examples, doesn't have to be massive just would like to see the best
and most efficient ways to link even a single form to a SQL Server BE, say
a name and address form"

So my main reasons for going down the C# route and also C#/VB.net with
ASP.net are that I want to learn these languages and hopefully start up on
my own...But in the first instance I really want to know how to use classes
and the framework properly just even in the first instance messing about
with a single form and select, update, insert and delete data on SQL
Server, i.e. should the form main reference classes etc and have hardly any
code behind it etc...


Anyway thank you for your response, it's greatly appreciated as always from
this great list.





On 21 October 2016 at 16:46, Dan Waters <df.waters at outlook.com> wrote:

> Hi Paul,
>
> I've been learning VB.Net over the last few years after many years of
> Access development - so I thought I'd through in my 2 cents.
>
> First - C# vs. VB.Net.  Beginning about 2008, MS began a concerted effort
> to make the two languages functionally equivalent.  Prior to this there
> were significant capabilities that one language had over the other.  By now
> most of those significant differences have been resolved so your choice is
> a preference - with an important caveat.
>
> C# is used by most development shops.  If you're thinking of getting a job
> developing then C# is the better choice for that reason.  But if you're
> mostly going to work for yourself then VB.Net might be better.  For me
> starting with VB.Net was good because I didn't have to deal with a new
> syntax (C# really is overly complicated and VB.Net really is more readable)
> and only had to learn more about classes and the differing capabilities
> between the VBA and VB.Net.
>
> I also made the choice to use LINQ as the data layer between my
> application and SQL server.  And this is really the way to go.  It gives
> you intellisense while you're writing code for CRUD operations and you'll
> get error indicators on-screen if you've done something wrong.  Also - buy
> a copy of LINQPad Pro - it's a great sandbox for writing LINQ queries.
> LINQ resolves to optimized SQL language to give you great performance.
>
> You'll find many helpful discussions on-line about how to write code a
> certain way.  I've found that if I begin the google search with "vb.net"
> [question here] then the answers written in VB.Net show up first on the
> list, but C# answers will also show up down the list.  Best of both ...
> You can also copy a C# example on screen and convert it to vb.net using
> converter.telerik.com or www.developerfusion.com or others.
>
> Also, I have a copy of SharpDevelop version 4.4.  This has a conversion
> feature to go back and forth between C# and VB.Net.  Just open a solution
> or project in SharpDevelop, right-click on a project, and select the
> conversion you want.  A duplicate project is then created in the selected
> language.  The latest version of SharpDevelop (5) does not have this
> conversion feature.
>
> One more thing - databaseadvisors.com has an email list for Visual Studio
> (dba-VS)!
>
> Good Luck!
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Paul Hartland via AccessD
> Sent: Thursday, October 20, 2016 2:12 AM
> To: Access List; Development in Visual Studio
> Cc: Paul Hartland
> Subject: [AccessD] Examples In Best Coding VB.net
>
> To all,
>
> Being self-taught and not had much time to actually spend with VB.net I
> now find myself with a little time to try and learn it properly, don;t
> really want to go through a step-by-step learning process, I seem to be
> able to pick things up quicker through working examples etc.  So could
> anyone point me in the right direction for (should I say) best coding
> examples, doesn't have to be massive just would like to see the best and
> most effiicient ways to link even a single form to a SQL Server BE, say a
> name and address form.  I have looked using searches and so many examples
> out there with different ways, but I trust the people on here to guide me
> in the right direction, as I believe just a simple form that will show me
> the best way to select, update, delete and insert records is enough to
> start me.
>
> The reason I am after this is that I have a Access manufacturing process
> application dedicated to a certain industry and want to rewrite it in
> vb.net and SQL as well, I could probably get something up and running but
> want it to be as slick as it can be as I may look at selling it afterwards.
>
> Thank you so much for any help in advance.
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com