|
Hi All
I am developing a system that will retrieve information from pastel account information, it will have to retrieve the invoice number and store it in the SQL server database so I need help on how to connect to pastel so that I can be able to get the information from pastel and from the database to pastel. The two applications have to share some sort of information. The help that is provided must be in visual basic 6.0 because that is the one I am using.
Hope you can help
Thank in advanced
|
|
|
|
|
I can't help, I don't use VB6. But I have no idea what pastel is, except a pale colour. Perhaps if you explain this, someone else can help you ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I'll second that question. What on earth is "pastel"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
it seems to be the name of his server...
TOXCCT >>> GEII power [toxcct][VisualCalc]
|
|
|
|
|
Is there any VB.NET control that can help me if i want a figure or table to be inserted in the database? Which control i should use?
Actually i want to insert tables and other images from word document into my database and dont know what to do. Please help me in this regard.
Thanx in advance.
Arfan Qadir.
|
|
|
|
|
No, you need to convert these items into a format that your database can understand and write SQL to pass it in.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi,
NGen is the tool which helps to speed up the application.Iam using the Framework 1.1.Please tell me how to use NGen tool to speed up the application
please give the solution so that it can be implimented.
Regards,
Prashant
Prashant Pawar
|
|
|
|
|
You keep asking this, so here is a story. A couple of dudes in the 70's were writing implimentations of the game of life, and trying to be the fastest. They were both trying to optimie existing code, and one told the other he'd figured out how to double his speed. The other guy spent the night trying to optimise his code, he couldn't get more than a small speed increase. So he thought it through and rewrote it with a new algorithm ( he essentially wrote a compiler that compiled game of life ) and got a 5 x speed increase. The next day his friend told him he was mistaken.
I wrote an image processing algorithm that was pretty intense, in C#. It took 2 minutes to process an image. I converted it to C++ and it took 12 HOURS. I optimised the code, and now it takes 8 seconds.
The moral of the story is, you're not getting an answer because there is no help for you, based on what you're asking. Like I said earlier, get rid of COM+ and the network traffic ( did you really try it without COM+ ? I am astounded how quick you did that ), but the core problem is almost certainly not with vb.net, but the code you have written. Get a code coverage tool, work out the bottlenecks, and then fix them. Perhaps you hit the database too often. Perhaps you're building objects you could cache. And perhaps it's just going as fast as it can.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Let me repeat myself... again...
<yelling>
NGEN DOES NOT SPEED UP YOUR APPLICATION!
YOU CANNOT USE IT TO GET A PERFORMANCE BOOST!!!
</yelling>
You're going to have to rewrite your code to get any kind of a boost, possibly even alter the design of your application.
<i><b>RageInTheMachine9532</b></i><font size="-1">
"<i>...a pungent, ghastly, stinky piece of cheese!</i>" <b>-- The Roaming Gnome</b></font>
|
|
|
|
|
From your repeated question about the same thing, it's bloody obvious that you have no idea how the JIT compiler works.
When you start your application, only the code that is required to start is compiled by JIT. JIT compiles code on a per-method basis, and only done once per execution session. This means that when a new form is loaded, only it's startup and rendering code is compiled. If you have a button on the form, the buttons Click event and other handlers ARE NOT COMPILED! They are only compiled to machine code upon first execution. This means that your Click event handler code is only compiled when you click the button for the first time!
Here, read this[^] on Performance Considerations. It explains how alot of this stuff works. Read it, understand it, then apply this knowledge to your existing code. God forbid, you might even find and fix your own problems using this knowledge.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i created one vbcall.exe and working succes fully
and now wat i want is i have to call one another exe in the above exe(vbcall.exe) and pass values to that
can someone help me?
|
|
|
|
|
You can use process.start, and you may be able to pass values. It's not the right way to do things though. ShellExecute allows you to pass values on the command line, for sure.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
thanks for reply if posible send any example code to pass variables immediatly
|
|
|
|
|
What are you talking about? Since you have the application written already, are you sasying that you didn't design in any interprocess communication or processing of command line arguments?
If you answer yes to both of those, then you have to go back and rewrite your application to support this, otherwise, you can't send anything to it because it's not written to listen for it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
Iam working on vb.net project. and my project is having three layers Prsentation,Business and data on different server.Iam accessing business layer through remoting(com+pplication)and business layer is giving call to data acess layer and then data access layer gives call to data and visa-versa.Problem is here that my application runs very slow It taken time to load my form under menu and it moves up and down while loading.
please help me to speed up the application.
Please give me the solution so that can be implimented.
Regards
Prashant.
Prashant
|
|
|
|
|
Why on earth are they on three servers ? Kill the COM+ stuff, move them to one server, and get them to talk to each other by importing the dlls that you build for the business and data layers. That's if you want to maximise speed.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hello Prashant
though you did not helped me out of sending dataset from remoting component to application but here are some suggestions for you.
I had a COM+ application and it runs slow some times and some time faster I never knew why . what I did was the following
1. Used threads ... like I build Loadform procedure on every heavy form and used threading on it during load
2. Make that LoadForm procedure public and call it this way
Dim frm as new form1
frm.loadform()
frm.show
use
gc.WaitForPendingFinalizers
gc.collect
in finally tag for try so that there should not be any memory issue. as it often comes in these type of applications..
Actually your application needs optimization for the code and thats all.
best of luck
|
|
|
|
|
Hello RIzwan
Thanks for your reply.My problem is not for specific form but for whole application when it loads under my menu.Actually when i load my application my menu gets loaded and under my menu, my forms gets loaded when i select any form my problem is
1.Its take time to load
2.its move up and down when it loads
and this is case for every form alternetly
so please understand my problem and suggest me the solution
Regards,
Prashant
Prashant Pawar
|
|
|
|
|
This is the first time I've EVER heard of a form moving up and down while doing some kind of processing. What is your coding doing during that process? Wiuthout knowing anything about your code, it's IMPOSSIBLE to tell you how to fix it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi all,
I have a dll that is written on VB6 environment. I want to reflect it to get source code but I haven't tool to do it. would you help me?
Thanks a lot
Hung Nguyen Viet
|
|
|
|
|
VB6 is not like VB.NET, it is not written in MSIL, if there's a decompiler, it's not a reflector.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks for your advice!
Agree that it's not a reflector, but I want to get the source code (by anyway). If you have experiences on this task, might you tell me about it?
|
|
|
|
|
AFAICT, you can't. I haven't seen any decompilers for VB6 code. If you do find something, at best, you're going to get an approximation of what the source MIGHT look like, and it may not even work!
There is no direct coorelation between the individual statements in the (machine code) .DLL and VB statements. There can be groups of (machine code) statements in the .DLL containing dozens of lines that amount to a single statement in VB. The problem is seeing that pattern in the machine code and know what it means. This is also complicated by optimizations that the VB compiler does to speed things up.
It's not like doing the same thing with C/C++ code. VB is a higher level language compared to C/C++, which is more closely related to machine code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If my datagrid is readonly = true.
Then it cannot be modified from inside datagrid but i want to allow deletion of row if 1 or more rows are selected and this is event raised after the delete button is pressed.
How will i code this
|
|
|
|
|
You don't delete anything out of the datagrid. You delete the records out of the underlying datasource, then refresh the datagrid.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|