Search results for query: *

Thanks guys. I got it sorted. I used the namespace Microsoft.VisualBasic.Devices; Much Appreciated!!

Does anyone know of a C#.NET equivalent to the "My" object in VB.NET? I am using Visual Studio 2005 and am having to convert my VB.NET code to C#.NET. I am trying to display the current time on a status bar and the VB code for this used this object. Surely there is an object in C# that can do...

Thanks SHelton. I have got it to trim the white space in the textboxes now. Never created a delegate before but now I understand how useful they are. One thing I have noticed however is that when the form loads and the datagrid is filled, I have to click on the datagrid before the white space...

My apologies SHelton. Your initial post using the DataGridViewCellFormatting Event was in fact correct and did remove the white space in each cell. Not sure why it didn't work for me first time round. Now all I need to do is figure out how to repeat this method for a textbox field. Many...

Good suggestion, but unfortunately in seems that Informix is not able to handle VARCHAR at all, unless the length of the data is the same i.e all data is 5 characters long - which in this case is not true.

I'd thought of that too but CONVERT is not recognised by Informix.

Thanks for your quick reply. The source column is a char(fixed in length). I tried this code but it didn't remove the white space in the datagrid or the textbox. I should have mentioned in my original post that I have tried using 'trim' in the select command but this didn't work either. Also...

Hi all, I am working in VS 2005 and have a datagridview that correctly displays data through an ODBC connection. each column in the datagridview is then displayed in a textbox which the user can edit. However my problem is that the fields in the datagridview are 40 characters long and say the...

I have just landed a project that requires a connection to an Informix database (of which I have no experience). Using Visual Studio 2005, I am able to create a connection in Server Explorer using the System DSN I created but I cannot see any tables. The System DSN uses the Informix 3.80 32BIT...

I have just landed a project that requires a connection to an Informix database (of which I have no experience). Using Visual Studio 2005, I am able to create a connection in Server Explorer using the System DSN I created but I cannot see any tables. The System DSN uses the Informix 3.80 32BIT...

Thanks very much. That worked a treat....

Hi all, I have just made a move into Visual Studio 2005 and am having a few problems when trying to copy data in a datagridview and displaying each row in a listbox. It's only the data in the first column that I need copied and the datatype is 'double'. Here is the code that I have written to...

Hi all... I am trying to create a linked server on SQl Server 2000 that will connect to an excel document on a local hard drive using Microsoft.Jet.4.0.OLEDB I configured the Linked server with the following information: Server Type - Other Data Source Provider Name - Microsoft Jet 4.0 OLEDB...

Thanks for all your help guys. My remote views are set to be updateable. I have removed the local views which caused the error msg but I am still having trouble with creating a parent-child relationship. Mike, I have checked the datasession property of my forms and all are set to default. I...

The problem arose at run-time. I was able to create the local view without any problems and the data is visible through this. I have a variety of controls on my form and this problem occurs in all. I have also tried various classes as the edit control but this made no difference. I'm at a...

Thanks Mike for your input so far. I originally had a remote view with two tables. However once this view was created, I was unable to modify the Query, receiving the alert "Unable to modify query" which is why I created the local view. Apart from this edit problem, I am able to view the...

That is it exactly. I am the only one editing the record and therefore cannot understand as to why this alert appears. I do need to detect multi-user collisions so I set the "Update Where" settings to Key and modified fields and "Update using" SQL Update. As far as I know, the tables and views...

Yes all the required fields are set to update and the send SQL Updates checkbox is ticked.

I am running a foxpro database with a SQL Server backend. On one of my forms, when I edit a record and then save I get the message: "Data has been changed by another user. Overwrite changes with your edits?." This form has a local view with a full join between two tables that are remote...

Hi I am using the automated process whereby an e-mail is sent with an attachment but I am wondering if it is possible to view the e-mail , allowing a user to check its details before sending it themselves. I am able to view the attachment which is in word (doc)format using "visible = .t." but...