jonnod123

Hi All, Just a quick question to see what others think is the best preactise... You have an Windows application that connects to a SQL Server DB. You use a dataset to represent the database locally. Is it better to write queries locally in your dataset, or in SQL Server …

Hi all, Just thought I'd quickly see if anyone had come across this before, or could point me in the right direction. I have several DataGridViews on various forms of an application I'm working on. I want to allow the users to update the DGVs and then click an update …

Hi. Let's say I have a method in a foreach statement, for example: [ICODE] foreach(string str in GetStrings()) ... [/ICODE] Does the method (GetStrings() in our example) get called once or once per iteration?

Hi All, I have two datagridviews on a form, one databound and one not (populated programmatically from Active Directory). I want to allow a user to double click on an item in the unbound DGV and have that item appear at the bottom of the bound DGV. The doubleclick event …

Hi All, I think that answer to this should be fairly easy, but having googled it for a while and changed some settings I am no closer to the solution. I simply want to change the database that a dasaset points to in my c# application. I've got a winform …

Hi all, I have a c# winform with a SQL Server 2005 backend. When I update my database from textboxes in the form, in one particular table all the nvarchar entries are padded with white space. This doesn't happen for other tables. All the fields that are being padded are …

Probably a basic question but... I have an windows application comprising several forms with a SQL Server database in the background. From several of the forms, I keep needing to run the same method, so instead of repeating code in each form, I want to put this (repeated) method in …

Hi all, I have a VS2008 winform application that connects to an Access 2007 database. However, I have been given the task of converting it so that it connects to SQL Server 2005 instead. (I've already migrated the data + database over without too many problems). The question is... is …

Hi, I'm using C#, Access 2007 and VS2008 to write a windows app. I have populated a datagridview from a query (taking data from 2 tables). When the user clicks "Save", I want to be able to save any changes made in the datagridview to the database. Only one column …

Hi all, I need some general advice with a webform using an Access 2007 database backend. (Hope this is the right place to post this, my problem seems to cross between several possible forums.) I've written a ASP.NET webform (using c#) which captures data and sticks it into an Access …