Search results for query: *

Example Code ok, what you need is not a problem. Given your stated abilities I would not recommend anything overly complex. I have written a small piece of code that might do what you wish. Please note that I have set the properties of the control to only fire once every minute so only...

what sample code you after? What sample code are you after? Is it timer code? or is it code that is thread based?

You are absolutely correct. I did not consider these issues. While I have been programming for years and years and am somewhat knowledgeable in solving problems (sometimes in a way that is not the best way )... I only recently graduated from technical college with my diploma is software design...

I will post a generated DAL project from start to finish of any 10 table or less database that someone wishes to post. Of course, I would make no statement of requirement on how the code I post gets used, but I would prefer that someone not make a million dollars on it and not share with all of...

Another possibility Hmm.. I am certain there is a way to do that, however you can automate the above solution as well. Create a new table in your access database that will contain the reported data. That way your application can still store all the data that it needs to but when you want to see...

Use of Timer Using Timer can cause you difficulties if your not careful. The best design as listed is the use of a windows service (specifically scheduler). I personally avoid the use of timer where possible, it usually is the source of more headaches than problems solved, but that is opinion...

Thanks for this link JohnH, I am going to take a look at this, to date I have been mainly working with SQL server and looking for a tutorial much like this one. Cheers.

First note. I have worked on many SQL server systems and to date all of them have been disconnected datasets, by this I mean that you fetch the data, then send the updates back. In order to determine if your row has been changed, you would have to have a field of type TimeStamp in your...

Many solutions, this is a possible one. Here is a solution that you can use. If your anti-virus isn't too Vindictive against Word Macros and your security environ allows for macros to be embedded into word Documents you might consider the following code as part of a word macro to solve your...

I don't bother editing my procedures and stuff when I make a change to my database, and I am not afraid of making those changes either... This is due to the fact that myself and a buddy of mine wrote a database designer app. In essence it writes ALL the CRUD and a huge number of other procedures...

However, getting your strongly typed dataset to exist in the first place without a database, I have never tried this. I assume that its easy, I just never bothered. Besides, with SQL 2005 or SSX with the new SQL Server Mgmt Studio creating the shell of a database to base your Strongly Typed...

Help to be provided. Can you provide me with what application you are doing your mail/merge in? Is is word? and can you send a copy of your access file (with dummy data) and I will do my very level best to help you out. If you cannot provide these, let me know as much detail as you can about...

Here is your steps to starting to learn the resource file format for .NET 2005. 1. Load a new project or an existing project into the Development Environment. 2. Find the item labeled MyProject in the solution explorer and double click. This will open the MyProject settings editor with tabs...

How to Serialize and Deserialize in VB.NET 2005 (Datasets) The code for vb.net2005 for Serialize is: It takes in two parameters and makes the assumption that your custom type class has a default constructure (ie: Sub New() with no params) and the outputfilename has already been checked out...

In response to TechGnome: If your using a dataset to store your data and you just serialize it to your XML and back again you are all set for reporting. As you know Crystal which is the tried and true standard of reporting for vb has a nifty little method called SetDataSource and the parameter...

Then you will get it to work via maintaining STATE of your form Every time you click a new button set the user created m_STATE variable to the state that the datagrid is in. When you click update, detect the m_State Variable in a case statement and then all the appropriate code. This is not...

Why Use a database? For a one user one database system I actually do not use a database at all. Depends on the number of tables but if you have only a couple of tables and no relationships to speak of (other than those you maintain by virtue of design) then why not use a DataSet object that you...

Possible Solution Hi cjard, there is only one way I can think of to do this and that is a mult-state form. These are elegent little beasts that I have used from time to time. Essentially it works like this. Have a new constructor that defines each adapter type that the form containing your...

what cjard says is 100% and I align my recomendations with his. I use Pooling=false in very specific circumstances in my apps and only when I am designing for local servers such as MSDE or SQLEXPRESS. To reinforce cjard's point, I did some testing with Pooling=false on a sample app writing...

I am not sure if you have your full answer yet, but in order to close off any active connections to your database from a single instance add a Pooling=False to your connection string. This will cause both SQL 2000 and SQL 2005 to flush their cache of connections that are not currently in use...