|
Thanks very much works great now.
Paul.
|
|
|
|
|
Hi
While using source code from
http://www.codeproject.com/kb/dotnet/ShareObjDotNet.aspx
dll Nepal.utilities.Miscellaneaous is missing
Please provide dll
Thanks
|
|
|
|
|
You need to ask the author of that article via by posting a message at the bottom of the page you linked to.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Hi,
I have to create a form in VB/VB.net that can write records on a mdb file on my website and also retrieve records from it.
I have never done any web programming, so I want to know how I can do it. Are there any sample codes available on the web? or can someone suggest me a book which explains such work.
Thanks and regards,
Neil Ranjan
|
|
|
|
|
Well look at this
http://www.google.co.za/search?hl=en&q=Introduction+to+ado.net+oledb&meta=&aq=f&oq=[^]
Did you look at this ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Please do not post in two forums, with the same question. Very rude.
Select which forum you feel is most appropriate and post there, just there.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
I want to create log for both success and failure of transaction in database and not only for exceptions(errors)
In Enterprise Library, Can i do logging in case of exceptions only?
Thanks
modified on Thursday, July 30, 2009 3:20 AM
|
|
|
|
|
Stick your logging into the finally block
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You mean using enterprise library I can do the logging out of catch block also?
Can u please provide me link for the same? Actually i am searchin for the articles and everywhere logging is done in catch block only and i think it is for exceptions only
|
|
|
|
|
It really isn't all that mysterious:
'Dim variables that you want to pass to the Catch or Finally clauses here,
'outside the Try Catch Finally block.
Try
'Your transaction takes place here
'Monitor any return value from your transaction (rows affected for example)
'and log success or failure based on the outcome here.
'Or if no errors occur you can simply log success here
Catch ex As Exception
'if an error occurs log the error here
Finally
'if you want to log something, no matter what happens, do it here.
End Try
My advice is free, and you may get what you paid for.
|
|
|
|
|
Please confirm that the code is also for logging using Enterprise library.
Also can u provide a sample code link that tells that the logging in Enetrprise library can be done in any part of the function?
|
|
|
|
|
Having no experience with Enterprise Library myself, I would guess something like:
Dim logEntry As LogEntry
Try
'Your transaction takes place here
LogEntry = New LogEntry()
logEntry.EventId = 100
logEntry.Priority = 2
logEntry.Message = "Success or failure"
logEntry.Categories.Add("Trace")
logEntry.Categories.Add("UI Events")
Logger.Write(logEntry)
'Or
LogEntry = New LogEntry()
logEntry.EventId = 100
logEntry.Priority = 2
logEntry.Message = "Success"
logEntry.Categories.Add("Trace")
logEntry.Categories.Add("UI Events")
Logger.Write(logEntry)
Catch ex As Exception
LogEntry = New LogEntry()
LogEntry = New LogEntry()
logEntry.EventId = 100
logEntry.Priority = 2
logEntry.Message = "Error"
logEntry.Categories.Add("Trace")
logEntry.Categories.Add("UI Events")
Logger.Write(logEntry)
Finally
LogEntry = New LogEntry()
logEntry.EventId = 100
logEntry.Priority = 2
logEntry.Message = "Anyway"
logEntry.Categories.Add("Trace")
logEntry.Categories.Add("UI Events")
Logger.Write(logEntry)
End Try
My advice is free, and you may get what you paid for.
|
|
|
|
|
I am doing in window aplication.
Got teh folowing crash by execution the code provided by you.
The type initializer for 'Microsoft.Practices.EnterpriseLibrary.Logging.Logger'
threw an exception.
I am uisng the following Dll reference.
Microsodt.Practices.EnterpriseLibrary.Common
Microsoft.Practise.EnterpriseLibrary.Logging
Is there anything that i need to do in addition to the above said
|
|
|
|
|
Adapt your code a little to include MsgBox(ex.ToString) in the Catch clause.
It will tell you in much more detail what the error is, and on which line it happened.
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi,
i have an application which will copy an image file from clipboard to Image.Text in vb6. now, i want it to try in vba and has error which is run-time error '424'. so what i did is i add reference library in tools. and still the same.
in vb6 this will work.
Me.Image1.Picture = Clipboard.GetData(vbCFMetafile)
but, in vba
Me.Image1.Picture = Clipboard.GetData(vbCFMetafile) => error here
my question is what vba equivalent of
Clipboard.GetData(vbCFMetafile)
thanks in advance.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Here[^] is the answer you need.
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
thank you so much for the link and it helps me a lot.
i found out in the link that it cannot get data from clipboard only text, right? what i mean is that
(vbCFMetafile) is an image file.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
My pleasure! I think what you need is this[^].
Good luck!
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
Sir i need help regarding restricting of loading of new form unless my form which is open is closed. For example i have 2 forms form1 and form2 in MIDI.
If form 1 is open i want to restrict user to open form 2 unless form 1 is close
Parag
|
|
|
|
|
You can use a Global boolean which you will set upon form opening and reset upon form closing.
In each form's Load event you can check the boolean: if it's not set, you can proceed opening the form and set it, if it's already set you can close the form.
I don't think VB6 has a more elegant way of doing this. :P
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
Hi to all
i would like to know about some VBA and excel. I would like to create a form and i would like to use excel as my database. How am i suppose to code it and update the "database". Before updating the database i have a Txt file from my TCS system as it only generate txt file. In this file there are lots of space, comma and semicolon. therefore the code need to delimite the space, comma as well as semicolon. how am i suppose to do it?? besides updating, in the form i need to read the data as well. so how to read the data from the database, maybe is it like C# SQl where they is a need of some store procedure. and for some part i would like to read selected column. once again how am i suppose to code thanks
once again thanks my dear friends
Warm Regards
Veon
|
|
|
|
|
It sounds like you are maybe confusing terms. Your TCS system (whatever that is) is apparently your database. In other words, the TCS system holds the data that you are working with.
What is it that you actually need to do with the data from the text file that the TCS system puts out? Do you just need to create readable reports, or do you need to manipulate the data, and feed it back into the TCS system, or what?
Generally speaking Excel should be used to display data, and perhaps make some calculations based on that data. As a "database", it is not the ideal solution.
You would be much better off downloading Visual Studio Express 2008 from Microsoft (it's free), which includes a simple database, and offers much better tools to do what it sounds like that you need to do. It allows you to program in C++, C#, JAVA, and VB, so you will also be able to find plenty of tutorials and other helpful articles on the internet.
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi my dear friend
thanks for ya advice, maybe we could discuss this issuse and come out with a solution .ok actually i'm doing a system for company and it has a system (TCS system) that links to other station where this system will catch the sales data from all the station. This TCS system is at HQ where we will generate the data into text file as this is an old school system which is still using MDOS. so currently they will just manually input the txt file to excel and process it. therefore its very time consuming. so i'm trying to create a software to help them generate their reports as well as other things related to the Txt file faster, easier and user friendly hope to hear from you
Warm Regards
veon
|
|
|
|
|
Okay, so first of all you need to automatically convert a text file to Excel.
But I am still not entirely clear on what it is that you need to do with the data once you put it in Excel. Or is converting the text file to Excel really the only problem?
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi
Besides converting there is still other problems. i'm still wondering what to use to programe this system. Anyway Once i get the data into excel it will become my "database", the current situation is that everymonth this data from all the outlet would be like 10000 Rows in excel and my staff need to manually input using privot table to generate the total sales for stations. besides that the manager would also like to view the turnover as compare to last year by Q1, Q2,Q3, Q4 ,H1,H2 or a year. from the report maybe it could generate graphs or chart for a better view.
thanks
veon
|
|
|
|