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.