ACTEBS
actebs at actebs.com.au
Thu Nov 24 07:43:24 CST 2011
Thanks Shamil. Am working through this very slowly... Vlad -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil Sent: Wednesday, 23 November 2011 7:32 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] VB.Net Database Classes Hi Vlad -- Sorry, I can't be of that much help - I'm very busy with custom development these days and I do not have experience in working with mySQL via .NET/C# I suppose basically you have to use .NET OleDb to implement CRUD operations - here is an introduction: http://www.aspfree.com/c/a/Database/Database-Programming-in-C-Sharp-with-MySQL-Using-OleDB/ It's similar to using OleDb with other backend types including MS Access. Folks say that using ADO.NET EF with mySQL is cumbersome: http://stackoverflow.com/questions/76488/using-mysql-with-entity-framework -- Shamil 23 ноября 2011, 05:05 от "ACTEBS" <actebs at actebs.com.au>: > Hi Everyone, > > To create this custom membership site, I would like to learn how to use and > create database classes for the project and I'm hoping someone has the > patience to guide me through it. I have tried searching on the web, but > everyone is talking about classes, methods and properties but not about > actual database access and data retrieval. > > So basically my question is as follows. Suppose you have 2 tables in your > database tblUsers and tblUsersRoles. The fields in these tables are: > > <tblUsers> > > UserID > > RoleID > > Username > > UserEmail > > UserPassword > > UserCreated > > UserLastLogin > > <tblUsersRoles> > > RoleID > > RoleDescription > > How would I create the classes for the above tables and also, how do I use > these classes within the site as well? By use within the site I mean, how do > I do the normal SELECT, UPDATE, ADD, DELETE functions, using the classes. > > Many thanks > > Vlad > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com