Search:

For Insert, you will have to use Insert Query and for Update you will have to use UPDATE Query. I guess you will need to take a closer look at how data is inserted or updated in the database. Go...

The answer to your question is "yes".

You can create a separate class that will do all the operations on the players, like move, change color, etc.

Google would help you.

Take a look at these samples, each showing a different way of building n-tier model:
http://msdn.microsoft.com/en-us/magazine/cc188750.aspx...

If you are using SQL 2005 then you should look at "OUTPUT DELETED" keyword on MSDN. This can be used with the delete statement to output the deleted rows into a table, etc.

I have never tried this, but you can check "Microsoft ODBC Data Source (ODBC)" in the options that you get when you click on Connect to database.

If it is a Winform application and you are just using one form, you can simply write this.Close();.

I guess you haven't heard of a connection pool till now. There is no need to keep a connection open. Open the connection, do your work, close it and when you try to open it next again it will be...

Not really an ideal way of doing it. You should use the SQLClient rather than ODBC. What is wrong in storing the uid/pwd in config file? If you are concerned about security, same things can be done...

You should look at BackgroundWorker Component It will let you do multi-threading without too much of complexity.

Here is a simple solution to your problem.


Private Sub Form_Load()
On Error GoTo Errorhandler
MsgBox "Hello World!"
Exit Sub

Errorhandler:
MsgBox "Error!"

You question is already answered in Post #2. Just to add, New is used for early binding where in during design time itself your code knows which object is being created and what all...

As I mentioned earlier, it is not a good idea to have such huge data loads in a Win Form/ASP.NET application. If you are familiar with SQL Server, Integration Services would be easy to learn. There...

I have never tried it with code, however you can try using the devices rather than directly giving the location. Something similar to this
USE master
GO
RESTORE DATABASE MYDATABASE FROM TAPE =...

What is the name of the SQL instance.

Well for one thing SQL Server installation is not just for any computer user. Sometimes even the most experienced IT professionals have problems installing...

The solution is already given, you just need to write the code. Just write it. :thumb:

I would rather use Sql Server Integration Services package to perform such kind of heavy data loads. Writing code for it and then processing 130M records would definitely take time. SSIS has been...

Yes it is possible using VB.NET as long as you are developing a Web Application.

Actually both your threads have a common solution. You need to go through System.Diagnostics.Process class on MSDN. You can get the currently running processes, their window titles and handles just...

I could help, but then I also missed the same classes that you did. :rolleyes:

We do not do homework here, ask specific questions and people here would be more than happy to help you out. If you...

Well I guess you have Business Intelligence Development Studio (BIDS) installed. This is part of SQL Server installation and does only SQL Server related projects like Integration Services, Analysis...

Welcome to the Forum :wave:

The culprit is this line of code Form1 frm = new Form1();. You are actually creating a new instance of Form1 and then populating the List Box on this instance and not...

Well it is quite difficult to give a general solution. What is happening during the Page Load event of the Page that you are talking about? Ideally you should first identify bottlenecks and then...

In a similar way, you could open a Datareader and then loop through the datareader and insert 1 record at a time in the second database.

Ok. So your architecture is like this, a client app sends data to a server. On the server there is another app which reads the data and then puts that data into database. If my assumption is right,...