10 comments found.
I purchased the VB.Nat DAL (non source code version). It appears to work but what I was hoping to have was a generator that also generated the aspx list and add/edit pages. Do you have a product that includes that page code including the code behind .vb files?
Hi,
Thanks a lot for the purchase.
It is in progress. Please contact us via our profile page here to share further details about it.
Thanks.
vb.net dal generator We are trying to create CRUD code in vb.net for .net 4.8 site. We have the database already. Just want to create the .vb code and the CRUD stored procedures. Does this vb.net DAL generator provide that?
Hi,
Thanks for your interest.
Yes, this app generates VB.Net classes that has CRUD operations for each table of the entire database. However, currently, this app uses inline queries. To generate stored procedures for CRUD operations, please use our other app (SQL Server Stored Procedures Generator). For further details, please contact us via our profile page here.
Thanks.
do you offer a trial version?
Hi,
Thanks for your interest.
Sorry, we don’t have a trial version at the moment.
However, we have a video demo. Please click here to view it.
Thanks.
Some suggestions and a request. When you ask for the list of tables these are not in alphabetical order and it is particularly difficult to find one if there are many tables. Request. I mainly use windoes form, you put as an example an asp application that I can’t load. Could you send me a small sample windows form application? Thank you
Hi,
Thanks for your interest in our apps.
Yes, I can do both.
Can you please send me a message via my profile page here?
Thanks.
Hello
Is this application still working? I see hasn’t been updated in a few years.
Hi,
Thanks for your interest.
Yes, it’s still working.
I solved the last issue by Unblocking the project files. But a new issue, it duplicates each field in the table when generating the code. Your source does this as well as the installation of the application. Sample below
There is only one field called Sku, yet your code generates many lines.
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Private _Sku As Integer
Using cmd = New SqlCommand(sql, con) cmd.Parameters.Add(”@Sku”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku1”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku2”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku3”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku4”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku5”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku6”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku7”, SqlDbType.Int, 4).Value = Sku cmd.Parameters.Add(”@Sku8”, SqlDbType.Int, 4).Value = Sku
Hi,
Thanks for contacting us.
Can you please contact us via our profile page here to resolve the issue.
I have a fix but cannot send you the SQL code the system will not let me post it.
Hi,
Thanks a lot for the feedback.
I got your email and replying it.
Using VS 2017 Version 15.9.4 and on Compile we are getting this error.
Severity Code Description Project File Line Suppression State Error Couldn’t process file MainForm.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. VbNetSqlServerDalGenerator
Hi,
Thanks for contacting us.
Please contact us via our profile page here to resolve the issue.
Hi , Can you show how to use the generated code? and Most especially how to use on a one to many data entry like Order Header, Order Detail, in the order detail , there is a lookup on the stock table fro example. Thanks!
May I kindly request for a Winforms Sample applciation for the request above? Thanks!
Hi,
Thanks for your interest.
Please send me an email via my profile page here.
Congratulations. Very Nice Work, GLWS From DCSF
Thanks a lot.
Interesting Work! Congratulations 
Thanks a lot.