PlausiblyDamp

Defaults are really just a legacy SQL way of providing default values for columns. These really shouldn't be used as a Default Constraint provides almost identical functionality and are the standard way of doing it now.

If you right click on the runtime security policy node you can select the 'Create Deployment Package' entry and get the relevant settings expoted to a MSI file. This can then be deployed via group policies.

What reason are you looking at skipping over the entry? Is this security related? If so then siteMaps have built in support for removing entries that are not accessibly for a given user anyway.

I find it annoying that they bring the languages closer together (VB now gets operator overloading and the using statement), but then go and make them differ in other ways. I really don't see the point of the My namespace as all the functionality offered by it is available elsewhere in the framework anyway...

Under .Net garbage collection is used to reclaim unused memory. The GC is lazy by design and will only collect memory when there appears to be any benefit in doing so. Out of interest how much RAM do you have installed in this particular PC? Is 7M really such a large amount for an application compared to your physical RAM?

If it is a windows application or a console application it will have an app.config file. The single line of code you posted should work - however without seeing what else you are doing or more details about how it is failing to work it is quite difficult to help.

Web applications do not work that way. There is no way for the broswer to automatically notify the server that it has been closed. Every time a page is accessed it is created on the server side, it's code is run to generate HTML and then it is destroyed.

Could you not either just call flush when you add data to the stream or alternatively one of the overloads for the FileStream's constructor allows you to specify the buffer size so you could choose a more appropriate value. Also IIRC instance members of the FileStream object are not thread safe - therefore you could hit a race condition if the timer fires at the same time as you are adding data to the stream.

What code do you have so far?

Looks like you are trying to add a null value to a combo box somewhere in your frmMain_Load event.

You will probably need to use Redim Preserve parent(id) - otherwise it doesn't keep the array contents. Also you might find the code cleaner if you create a class or structure to manage the pair of strings as a single item rather than creating an array of a string array. Also you may want to look at using a collection class rather than an array as constantly redimming an array can cause unnecessary memory allocations / deallocations.

The big question is though how much more time consuming is it to do data access with parameters in the first place compared to the time and effort taken to debug your string concatenation based code. Plus the time taken to handle all the special cases that only crop up at runtime. Plus invalid input / data types. Plus security implications. In the end did you save anytime by having to resort to RegEx to make this work...

If you use either a stored procedure or a parameterised query then this wouldn't be an issue. String concatenation and SQL statements are always error prone, subject to odd issues like localisation and a potential security risk.

After re-reading the original I think you might be correct. If that is the case then go with Cag's idea of saving the results to a file rather than executing the query each time.

Firstly is there anyway to reduce the time of the query? Is there any particular bottleneck or reason why it takes so long? Secondly you probably want to use either threading to execute the query in the background or an asynchronous delegate to acheive a similar result.

Where are you actually binding the controls to the dataset? Where is the dataset declared? If you could post more of the relevant code it might help... It looks as though you are doing the binding in the Page_Load event but binding against the dataset loaded on the previous button click. Also are you sure you mean to check the parameters' current value agains string.empty rather than the textbox content's agains string.empty. In your code the first time it is executed each parameter is probably empty so you set it to '%', on subsequent executions they will not be empty and so you then assign the textbox contents to the control regardless of the textbox's value.

IE has restricted permissions on what a non-trusted site is allowed to do - automatically installing software is one of these things.

private void Page_Load(object sender, System.EventArgs e) { System.Data.OleDB.OleDBDataReader myReader; OleDBConnection1.Open(); myReader= OleDbCommand1.ExecuteReader(); ISPDataGrid1.DataSource = myReader; ISPDataGrid1.DataBind(); }

Just tried it here and FireFox worked ok. If you really can't get it to work could you not choose a different character?

You could always use something like System.Net.WebClient to read the raw data from the page in question. However the big issue is going to be parsing the page contents correctly. If you know the format of the page isn't going to change then you may be able to do this. Probably the way forward is to look at regular expressions - be warned though that they are not a trivial thing to learn.

Is there any difference between the framework service pack version on the client and the development PC? Also could you give a bit more detail about the error on the client PC - is there further info other than InvalidOperationException?

The error message pretty much tells you what you need to do - you need to specify a protocol for the upload and a filename. try something like My.Computer.Network.UploadFile("c:test.txt", "ftp://10.2.2.10/test.txt", "username", "password")

The results will always need to be valid SOAP in terms of the format - however this does give you quite a good amount of customisation. If you are trying to work with a predefined XML structure then I would suggest you have a look at XML Schemas (XSDs) as these will allow you to define your data structures. Also if you are using your own classes etc. then the attributes found under System.XML.Serialization may help.

If you added the web reference via VS then you can select the webreference through the solution explorer and in the property grid change it from static to dynamic. This will move the URL to the appropriate config file (web.config or app.config) for you.

Webservices are an open standard and can be called from any language or toolset that follows the standards.