Important alert: (current site time 7/15/2013 7:55:16 AM EDT)
 

winzip icon

__ OrderAutomation

Email
Submitted on: 4/30/2003 1:30:37 AM
By: TLWallace  
Level: Intermediate
User Rating: By 28 Users
Compatibility: VB.NET
Views: 86549
author picture
(About the author)
 
     It demonstrates using xml as a file type database. XML can be later converted to any type database format you choose (i.e. MS Access, SQL Server, Oracle, MYSQL others..) It also, uses Microsoft Agent as a helpful assistant during program execution. THIS PROGRAM IS INCOMPLETE. It contains a mixture of programing topics for the VB.NET programmer. Topics covered: Process food inventory, payment invoices, product supply, and more. XML input/output, Microsoft Excel worksheet. Print and Print preview. Read Write XML. This program utilizes .NET Datagrid, Tab, and Print Preview controls and spell check. This program utilizes the new .NET Datagrid, Tab, and Print Preview controls and spell check. Code comes with some examples provided by Microsoft, various Planet-Source-Code contributors, the web and maybe some others that I can not remember right now. It is however being distributed here free of charge so there shouldn't be any legal copyright issues. But mine 2003(c) TLWallace.NET. How about some feedback? You may modify it to fit your specific purposes for whatever. __________________________________________ UPDATE(08-30-2003): Version 1.0.1337 Fixes invalid file references (NT 4.0 and Win 95). Removed obsolete files. Converted to VS 2003. __________________________________________ UPDATE(09-06-2003): Version 1.5 includes further tweaking and fine tuning. Clean up some obsolete code. Unneeded objects.

 
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 5 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 

Other User Comments

5/26/2003 11:36:38 AMCrss B0NES

This is great program. Could you possible help flesh it out more?
(If this comment was disrespectful, please report it.)

 
6/7/2003 11:38:32 AMTLWallace

Sure, I could 'flesh it out'. What did you have in mind?
(If this comment was disrespectful, please report it.)

 
7/7/2003 5:20:14 PMTLWallace

A few people have sent to me email regarding this project. To answer most of your questions, start here:
http://www.vbdotnetheaven.com/Code/Apr2003/005.asp

By going to the website you can perhaps learn more about XML. Hope this answers most of your questions.
(If this comment was disrespectful, please report it.)

 
8/23/2003 10:26:41 AM

Great
(If this comment was disrespectful, please report it.)

 
8/27/2003 12:38:37 AM

Hey, when i m trying to download file..it showing error ...file is currurpted please chk it reply as soon as possible...

Nitu
(If this comment was disrespectful, please report it.)

 
8/27/2003 1:14:00 AM

Good Job !! Simple code !!

Very useful for Intermediate developers
(If this comment was disrespectful, please report it.)

 
8/30/2003 1:05:37 PMTLWallace

Thanks to everyone for your generous supporting comments. I appreciate the votes so far.
(If this comment was disrespectful, please report it.)

 
9/5/2003 9:47:41 PM

This application is nor run a version of vb.net plz help me about newst ver. of vb.net
when i open *.vbproject file then a msgbox appear says like "You must install a new ver. of vb.net help me...
(If this comment was disrespectful, please report it.)

 
1/2/2004 11:59:02 PM

code under review. shall revert soon
Thanks
(If this comment was disrespectful, please report it.)

 
1/20/2004 12:56:47 AM

when i open *.vbproject file it shows a msgbox says like
(If this comment was disrespectful, please report it.)

 
2/27/2004 9:36:17 AMtreesprite

...looks as though this project requires Office 2003 so that the line 'Imports Microsoft.Office.Interop' can be found...???
(If this comment was disrespectful, please report it.)

 
3/10/2004 8:18:24 PM

Although i'm not yet use this program, i think it is a good program n quite useful to me...Thanks a lot..
(If this comment was disrespectful, please report it.)

 
6/6/2004 11:14:41 PM

Microsoft.Office.Interop.I don't know where is this com ,what does it use for?
Thank
(If this comment was disrespectful, please report it.)

 
6/7/2004 2:33:52 PMTLWallace

Thanks guys for all of the wonderful support and feedback.
(If this comment was disrespectful, please report it.)

 
6/7/2004 2:35:21 PMTLWallace

Microsoft Office XP primary interop
assemblies (PIAs) are available for
download:

http://support.microsoft.com/default
.aspx?kbid=328912
(If this comment was disrespectful, please report it.)

 
9/16/2004 1:10:54 AMKunal - The Man Of Program

Respected Sir
This is kunal mukherjee from India. I have downloaded your project and there seems to be a problem whenever I want to run the codes. The following References are not found in my system. I am using VS.Net 2003 with framework 1.1.

1. Interop.Office
2. Interop.VBIDE

Please tell me how to overcome this prolem. Is there any solutions to my problem. If there is please let me know ASAP. Waiting egerly for your mail. kunal mukherjee
(If this comment was disrespectful, please report it.)

 
9/17/2004 4:27:30 AMKunal - The Man Of Program

how can i use other agent characters? please help.
(If this comment was disrespectful, please report it.)

 
12/6/2004 2:37:48 AM

I am using .NET2002. I am unable to open the solution. The selectec file is not a valid Visual Studio Solution. Does it mean that I can open only with higher versions?
(If this comment was disrespectful, please report it.)

 
3/2/2005 9:17:21 AM

i don't know if i am going to get a reply from this soon, but there it is.

after installing office interop i get an error on the
(If this comment was disrespectful, please report it.)

 
3/2/2005 9:19:03 AM

sorry ... error on the interopservices.comexception. on the line "Dim excelApp As New Excel.Application"

i don't know what that is
(If this comment was disrespectful, please report it.)

 
7/29/2005 1:22:53 PMlcj

where can i find the print button??
and cannot compile because cannot find
orderAutomation.exe
(If this comment was disrespectful, please report it.)

 
7/29/2005 2:21:59 PMTLWallace

What are you trying to print? If you are trying to print the datagrid then that would be on the context menu.
(If this comment was disrespectful, please report it.)

 
7/29/2005 2:23:31 PMTLWallace

For those who have problems with Office Interop please the post above.

Microsoft Office XP primary interop assemblies (PIAs) are available for download: http://support.microsoft.com/default .aspx?kbid=328912
(If this comment was disrespectful, please report it.)
(If this comment was disrespectful, please report it.)

 
8/10/2005 7:01:29 AMsasan

hi
(If this comment was disrespectful, please report it.)

 
12/7/2005 3:07:52 AMren simeon

thank you
(If this comment was disrespectful, please report it.)

 
4/2/2006 7:02:59 AMyogesh

its not support .net 2003
(If this comment was disrespectful, please report it.)

 
5/23/2006 9:16:28 PMreggie

this one is so cool... =D
(If this comment was disrespectful, please report it.)

 
9/10/2006 2:51:49 PMIsaac - Brazilian

as that I move of xml for .mdb of access?
(If this comment was disrespectful, please report it.)

 
3/7/2007 2:18:35 AMclifford resonable

nice piece...
(If this comment was disrespectful, please report it.)

 
5/1/2007 1:47:12 AMchandan

i want to making software that can record, make all voice call through pc and it should be a field that contain address book please help me
(If this comment was disrespectful, please report it.)

 
6/6/2007 8:15:12 AMPradeep Sharma

Good. Keep showing some more advent of programming too.
(If this comment was disrespectful, please report it.)

 
8/7/2007 4:27:20 AMDante

You are a good programmer.Can you help me with using xml for the data base.
Reach me samurai.dante@gmail.com
(If this comment was disrespectful, please report it.)

 
8/30/2007 7:14:53 PM

thank you.very good
(If this comment was disrespectful, please report it.)

 
8/30/2007 7:16:19 PMsata

thank you. very good.
(If this comment was disrespectful, please report it.)

 
6/17/2008 11:23:43 AM

genious

(If this comment was disrespectful, please report it.)

 
9/8/2008 7:24:36 PMhsv

i like this code. sample and easy.

Thanks
(If this comment was disrespectful, please report it.)

 
1/28/2009 12:43:31 AM<< Charlie >>

hi, im new with this .net can you help me how to solve the problem with word.application not define? sorry...
(If this comment was disrespectful, please report it.)

 
1/28/2009 2:00:03 AM<< Charlie >>

Hi, I already solve the problem. The missing dll are already in my system just need to reload them. Great work by the way. Thanks.
(If this comment was disrespectful, please report it.)

 
8/24/2009 4:11:44 PMkankanna

can u pls tell hw cn i get a orderautomation.exe in bin folder b'coz of this, its not working .........repli asap !!!
(If this comment was disrespectful, please report it.)

 
8/25/2009 2:15:34 AMkankanna

whnevr i rebuil the sol file it shows error of missing order automation.exe file in bin folder.........hw to solve dis???
(If this comment was disrespectful, please report it.)

 
11/22/2009 10:52:46 AMRTB

I get these errors using VS 2005:

Error 1 Variable 'sStr' is used before it has been assigned a value. A null reference exception could result at runtime. (tblStructure)
Error 2 Warning treated as error : Variable 'sStr' is used before it has been assigned a value. A null reference exception could result at runtime. (tblStructure)
Error 3 Type 'Word.Application' is not defined. (frmMain)

(If this comment was disrespectful, please report it.)

 

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.