|
So what part of this are you having a problem with?
|
|
|
|
|
Thanx for reply.
I have two servers with 4 to 5 tables one is local one and other is remote server.
I need to fetch data from remote server to local server using windows application.
For that i m using stored procedure in SQL server 2005 that i m calling on my form with refresh button but it takes long time to fetch data from remote server so i want faster way to data fetching.
so Plz help me.
|
|
|
|
|
pank@1234 wrote: but it takes long time to fetch data from remote server so i want faster way to data fetching.
There really isn't any faster way. If you're retrieving many, many records, it's going to take a while. This also depends on the structure of the database, any indexing, and the SQL statement you're using to retrieve them. If it's just a simple SELECT, like SELECT * FROM table , and you're using the SQL data provider, there's nothing you can do to speed this up.
|
|
|
|
|
thanx for reply.
ok.
i m still searching for solution if u got any new idea plz inform me about tht.
Thanks
|
|
|
|
|
Is this a 100% complete backup everytime, or are you only add new data? What are the requirements? This makes a HUGE difference in how you should attempt to accomplish your goal.
If you only have to record the differences, then you could transfer only the new rows, updated, etc. Another option would be to use DTS. Alot of options, but require some effort in developing the method(s) in filtering and transferring the data.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
With the limited information you've given, there are no new ideas.
|
|
|
|
|
Dave Kreskowiak wrote: With the limited information you've given, there are no new ideas.
Sigh. The classic "I want to go to the moon. Can you tell me how to build a machine to do so?"
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
hi
i developed a windows application for my company.it is working fine.
now my company needs to convert it to webapplication and put it in the company's website.
now how can i convert the windows application to web application
is there any tool for it
i developed windows application using 3 tier archtecture
plz help me
thanks in advance
vijay kumar D
|
|
|
|
|
vijaylumar wrote: is there any tool for it
No.
vijaylumar wrote: i developed windows application using 3 tier archtecture
Good. Take two of those tiers (the business layer and the database layer) and put a new presentation layer on it.
|
|
|
|
|
there is no tool for it.
you have to create it.
Sathesh.
Blessed is the season which engages the whole world in a conspiracy of love.
|
|
|
|
|
start writing some asp files first
|
|
|
|
|
Hi
does anyone have an idea on how to disable the MS-Office Web Component's context menu?
I'm using OWC11 on a form and would like to some how prevent the OWC context menu to pop-up.
thanks
|
|
|
|
|
hi,how i can communicate with bluetooth device in vb.net?
for example i have an external gps bluetooth antenna...
how can i recive nmea string from device?
can you post code or link of this argument?
thanks
|
|
|
|
|
|
حقیقتش منم مشکل دارم اگه کسی بلد هست کمکم کنه
Silvervbnet@yahoo.com
|
|
|
|
|
I'm finalizing a proposal for a potential client who wants to upgrade their VB6 application to .NET. I hate to reinvent the wheel, so I'm wondering what tools or scripts exist to automate the conversion process.
I am aware of:
Microsoft's Code Advisor
Aivosto's Project Analyzer
Microsoft's Upgrade Wizard
Artinsoft's Upgrade Companion
Code Architects' VB Migration Partner
Great Migration's gmBasic
Microsoft's VB PowerPacks
Microsoft's Interop Forms Toolkit
We're planning on using 1, 2 and 4.
Are there any other tools, utilities, scripts, etc. to automate the conversion process?
|
|
|
|
|
You've pretty much hit them all, except for your own hands and eyes. No tool is going to do a 100% perfect migration, and it's still going to be VB6 code running inside a .NET wrapper.
|
|
|
|
|
Hi Dave,
Thanks. Well, if you or anyone else can thing of something that I missed let me know.
The Upgrade Wizard and Upgrade Companion don't do enough to make the source code more .NET-like, such as renaming variables prefixed with "lng" to "int".
In VB6, it was common to prefix your variables with an abreviation to indicate data type. For example:
Dim intNumber1 As Integer
Dim lngNumber1 As Long
In .NET, an integer is now called a short and a long is now called an integer. So the tool will upgrade that code to:
Dim intNumber1 As Short
Dim lngNumber1 As Integer
The problem with that code is that the prefix no longer matches the data type.
It should be:
Dim shoNumber1 As Short
Dim lngNumber1 As Integer
And actually, Microsoft recommends against using Hungarian notation so it really should be:
Dim number1 As Short
Dim number1 As Integer
The UW and VBUC do not handle changes like this. I can't be the first developer who's faced this problem. I figure that someone somewhere has already written some sort of utility or script that handles changes like this. I don't want to reinvent the wheel if I don't have to.
|
|
|
|
|
There is nothing that will rename variables during the upgrade. It's just too dangerous to the functionality of the code.
emunews wrote: I can't be the first developer who's faced this problem.
No, but you're going to end up doing what everybody else does and just re-write the code.
emunews wrote: I figure that someone somewhere has already written some sort of utility or script that handles changes like this.
Not that I've ever seen.
|
|
|
|
|
Hi,
I have a problem in invoking a method in the class
I have a Database class say DBAccess, in that I have a method to be invoked, I have created object to that class in this manner
Dim objDBAccess as DBAccess
when i used like this objDBAccess.GetData() Sometimes I am encountered with the error message "Object Reference not set to an Instance of an Object". I have overcomed by instantiating the object as
Dim objDBAccess as New DBAccess
I want to know how in some access the First statement itself worked fine and sometimes it failed on invoking that method.
|
|
|
|
|
it is very simple:
for Eg:
Dim thing as New Thing<br />
thing = Nothing<br />
<br />
‘do something at start of load event<br />
if thing = "sandwich" Then<br />
thing = "jelly" <br />
Clearly the thing object is set to an instance of on object at this point. It’s an instance of the Thing class.
Sathesh.
Blessed is the season which engages the whole world in a conspiracy of love.
|
|
|
|
|
This is basic programming concepts in OOP. I HIGHLY suggest picking up a book on VB.NET for beginners.
Your first statement just created a variable that CAN contain a reference to an object of type DBAccess. When you define it, it doesn't actually reference any DBAcess object, it points to Nothing, or null in C#.
Your second statement (with the "New" in it) does the same thing as the first statement in creating a variable that CAN point to an object of type, then it creates an instance of the DBAccess class, called an object, and points the variable at that instance. Now you can call the methods and properties on that object.
|
|
|
|
|
aakkpp wrote: I am encountered with the error message "Object Reference not set to an Instance of an Object"
Because you need to use the New keyword.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
declaring an object is different from creating an instance of an object.
Unless you get an instance of an object it is not ready to be used in oo environment.
You have to go through some books and tutorials.
|
|
|
|
|
Hello
I am using VB.Net in VS2008 Professional SP1 on Vista Business SP1.
Installation was without error messages but it seems only the VB templates were installed, i.e. I don't see any 'Setup and Deployment Project' option when I want to start a new project even though the folder 'Setup and Deployment Project' does exist.
Likewise I don't see templates for other programming languages in .Net even though the entire VS2008 package was installed.
Do the templates not install automatically? Is there a place to download them and copy them manually into the template folder?
Many thanks
ccdmf
|
|
|
|