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.

6 comments found.

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