Code

Discussion on VB.Net DAL Generator - Source Code

Discussion on VB.Net DAL Generator - Source Code

Cart 13 sales

NajmulIqbal15 supports this item

Supported

This author's response time can be up to 5 business days.

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.

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey