C# for life. Seriously. Every time I have to go through another developer's VB code, I find myself reading it backwards. the type-after-name convention (Dim Something AS ItsType) is annyoing at best. Also, Dim essentially is a useless syntactical element.
This is quite a bit of code to see without indenting it.
Can you have a try at that or maybe make a screenshot + download link which would also make it easier to see.
True... Use either SourceCodeForHtml (search here on BloggingAbout.NET for it for more info) and supply a solution with it.
You can either attach it to your post or upload it into a file category on this site.
I have observed Wilson to be a determined gentleman for over 6 years. He surely has worked his way up to receive this in reward - I however know more is coming!! Congratulations Will and make it happen like never before. God bless. - Chris
Country Manager Uganda
International Institute for Communication and Development (IICD)
P.O. Box 11586, 2502 AN The Hague, The Netherlands
Visitors: Raamweg 5, 2596 HL The Hague
Phone:+31-70-311 73 11
Mobile:+31-6-3479 16 73 / +256-77 293 0825
People - ICT - Development
Single or Double is always wrong for a decimal type. Single and Double are binary encoded, Decimal is a decimal encoded type. e.g. it is not possible to represent 0.1 exactly in Double, but you can represent 0.1 exactly in DECIMAL(2,1).
sorry for this but I am going to re-send it soon
How would one be able to differentiate money from other numeric data types with decimal point in your grid when its recieving data from a SQL server datatable
I've learned it as having a technical primary key and a functional primary key. Both can be the same but most of the time they do not as having a functional key as these are often bad for performance.
I would not store such sequence logic in the database any more as this is business logic and most applications these days have that available in a different tier.
I am not very sure if I understand your comment very well, but yes, it depends upon the architecture.
If one of the condition(s) in my architecture is that I only connect to and disconnect from the DB only when I want to save new or update/delete only what I’ve retried i.e. not first present the 40 million records to my business layer to merely update or add one entry. I don’t see my self not putting the sequence in the DB
And well performance can be an issue at time but with so much processing power available on our servers nowadays, elegancy will just override it (to me anyway).
Otherwise I appreciate your comment
Assuming that you want to save into Payments and PaymentsDetails tables for a Client who has an account
Introduction A couple of times when developing a new application, you’ll need to write some stored
I see where you're heading, but on Microsoft's "Web Service Software Factory - December 2006 Refresh" you had something just like that and beyond: generation of stored procedures, business classes, all the data access layer, etc. But now Microsoft's new release of that, "Web Service Software Factory Feb 2008" just dropped it, in what has been interpreted as a shift towards other data access paradigms... Entity Framework, LINQ, etc. (not that it is a bad direction at all). Check www.codeplex.com/servicefactory.
In the meanwhile, some are heading for NHibernate for a way to overcome the dreaded object relational mismatch.
Some unfortunate others are using the Web Service Software Factory - December 2006 Refresh that is only compatible with Visual Studio 2005, generating code there and copying the stuff to Visual Studio 2008.
Hi, is this safe? I can easily see how a person would inject some malicious code in it. Or do we restrain it on the application?
waiting for more posts
@Raphael; note that the code doesn't pick data directly from the user, but well if the SP is not encrypted or hidden in some way, one may alter it
Introduction This post is a follow-up of my previous post; Backup MS SQL Server database from within
Thank you for submitting this cool story - Trackback from DotNetShoutout
HTML clipboard Daily tech links for .net and related technologies - September 4-8, 2009 Web Development
9efish.感谢你的文章 - Trackback from 9eFish
I am getting errors - I am using Visual Studio 2008 and trying to call this program from an aspx page. Looks like I don't have the correct references. BC30560: 'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel'. I'd really like to get this code working! Help!
I'm a VB too, and I read your entry on that site which is what led me to bloggingabout.net.
I was just thinking whether or not it is still open so I can post my own little story there as well.
@Fadzai, am not sure if it's still open, but you try to contact MS VB Team, they'll be able to help you.
@Ruth, I've not called it from an aspx page, I'll try it out and let you know!
I guess, there is need to make some changes though.
Surely he deserved it, Mr. Kutegeeka is very hardworking guy without a selfish mind. he has helped many to develop their IT career too.
He is an assest to the Joint Clinical Research Center(JCRC) where he is working today.
May God bless you.
Introduction Imagine you need to architect a multitier, distributed .NET-based app with three logical
Hi I am searching blog backup utility.Can u tell me about WP-DB-Backup, what is this?
Pls post the article that can describe how to do that increase the progress bar up by the percent when we use it in sql procedure.
hola, muy bueno pero necesito lo mismo pero para aplicaciones web
Thank you very much
Introduction If you develop multitier applications that use a consistent data access framework, you will
Do you have a code generator to generate all this code generator code? Cause there is no way I'm typing all that.
I don't understand, have you downloaded the code Generate_VB_Automatically.zip, it's all there.
this is a great restore database tool, can you please tell me how to convert it in visual basic 2010 code because I'm new on it and i can't run the application... there were some error's that i cant repair...
Great Blog, I've learned a lot already! I really love this QueryString class you've written. Would you mind if I used some of it in a similar how to post for flash but rewriting it for as2?
No problem, go ahead to use it
I used your application to create mine. I have come up with a little problem. I want to backup the file to my local machine and its trying to backup onto the server and since of course I don't have the same directory structure on the server it fails. The opposite happens when I backup local database, I can't back them up on the server.
My question is that, is there a property to BackupDeviceList or type that we can set to choose the "local" drive instead of the "current" server location drive?
Thanks for the application. Just a note, You have to run it as 'Administrator' if You are using windows 7, do the same to Your application if You embed this code.
can you please post post the full source code? I have problems really. especially in .SMO
The download file contains full source code
hey thanks for great tutorials where is the link to the zip file for this tutorial i would like to download it and see how its used thanks
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=184.108.40.206, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.