Type: Posts; User: Shuja Ali
Search took 0.14 seconds.
November 18th, 2009, 02:58 PM
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...
November 17th, 2009, 01:34 PM
The answer to your question is "yes".
November 16th, 2009, 03:01 PM
You can create a separate class that will do all the operations on the players, like move, change color, etc.
November 16th, 2009, 02:59 PM
Google would help you.
Take a look at these samples, each showing a different way of building n-tier model:
November 15th, 2009, 01:10 PM
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.
November 13th, 2009, 03:10 PM
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.
November 13th, 2009, 03:09 PM
If it is a Winform application and you are just using one form, you can simply write this.Close();.
November 13th, 2009, 03:03 PM
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...
November 12th, 2009, 02:22 PM
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...
November 11th, 2009, 01:26 PM
You should look at BackgroundWorker Component It will let you do multi-threading without too much of complexity.
November 11th, 2009, 01:24 PM
Here is a simple solution to your problem.
Private Sub Form_Load()
On Error GoTo Errorhandler
MsgBox "Hello World!"
November 10th, 2009, 02:05 PM
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...
November 10th, 2009, 02:02 PM
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...
November 9th, 2009, 02:54 PM
I have never tried it with code, however you can try using the devices rather than directly giving the location. Something similar to this
RESTORE DATABASE MYDATABASE FROM TAPE =...
November 9th, 2009, 02:51 PM
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...
November 9th, 2009, 02:48 PM
The solution is already given, you just need to write the code. Just write it. :thumb:
November 9th, 2009, 02:45 PM
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...
November 6th, 2009, 04:45 PM
Yes it is possible using VB.NET as long as you are developing a Web Application.
November 6th, 2009, 04:44 PM
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...
November 6th, 2009, 04:35 PM
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...
November 6th, 2009, 04:33 PM
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...
November 4th, 2009, 02:22 PM
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...
November 4th, 2009, 02:17 PM
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...
November 4th, 2009, 02:14 PM
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.
November 4th, 2009, 02:04 PM
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,...
Click Here to Expand Forum to Full Width