Search results for query: *

im sorry i didnt realize that this Stars service was used. I will use this in the future. FYI I am very grateful from the help that I have received - it is invaluable. Please accept my apologies. JB

Hi sorry about the delay - have been out of town for ages. Yeah i just wanted to overwrite the existing file automatically

Hi I want to write a function in vba to save excel automatically, overwriting the existing excel 2007 workbook. Something like this? Sub SaveIt() Thisworkbook.Save Application.OnTime Now + TimeSerial(0, 1, 0), "SaveIt" End Sub

Thanks for this - Do I put my connection string here replacing "Default"? string connectionString = ConfigurationManager .ConnectionStrings["Default"] .ConnectionString;

Hi All, I just cant seem to get this to work?? private void button1_Click(object sender, EventArgs e) { //The connection string is used to describe the type of database, the security information and the location to the database. string ConnStr =...

At present I have a field "DOB" in DD/MM/YYYY format - I want to use SQL to reformat this to MM/DD/YYYY Format. Any ideas as Im stuck! Thanks JB

LOL @ Adrianus Van Der Bruge.

its a data migration - the migrated fields in the staging db all contain nulls from the import and I want to place a value in the NULL's so that the next stage of the migration isnt affected by them.

Hi I want to write a query that will fix names with apostrophes like O' and Mc For example I want to : Convert all surnames in my table beginning with “O Name” to “O’ Name“. I also want to fix all surnames beginning with “McName” to “Mc Name” (where Name represents a surname). Help!

Hi all, what is the sql to replace all cells in a table taht contain NULL's? I want to do this in one query: at present I have to write a query for each column Thanks JB :o

It uses the webservice "getquote" using a stock symbol that the user enters into textbox1.text e.g the user enters "GS" into the textbox, clicks submit and all the stock data is pulled from the web service

Hi Thanks Again - I changed it but its still throwing out "illegal characters in path" Imports System.Xml Imports System.Text.RegularExpressions Imports System.IO Imports System.Net Public Class Form1 Dim ws As New stock.StockQuote Dim wsdoc As New XmlDocument Dim wsurl As...

Thanks - Its now throwing "illegal characters in path"

VS 2005 .NET CF Hi everyone, I am writing a mobile app in vb that returns stock data in xml format from a web service. This works fine but it returns it all in xml format. I want to parse the xml so that each item is on a separate line. I cant get it to work. I would be grateful if you could...

Hi everyone, I am writing a mobile app in vb that returns stock data in xml format from a web service. This works fine but it returns it all in xml format. I want to parse the xml so that each item is on a separate line. I cant get it to work. I would be grateful if you could have a look for...

Hi, I have a csv file with around 220000 records that I want to import into MySQL 5 but the data in the csv file is quite messy, as its from our old mainframe system and there wasnt much validation done to it etc. I want to clean the data up. Should I use Microsoft Access to clean up the...

just in a label

Hi If I use option 2 how do I specify the path for the xml as all of the examples I have found request an xml filepath e.g see this example it asks for a filepath: http://support.microsoft.com/kb/317069

Hi I want to properly display a webservice xml data in an application but i keep getting: illegal characters in path error what am i doing wrong? public Form1() { InitializeComponent(); } WSREF.StockQuote ws; private void Form1_Load(object...

Hi I want to enter a text file with around 1300 rows/6 columns of comma separated values into a sql server compact edition database however normal sql commands dont seem to work. Does anyone know the correct sql syntax for this in vb 2005? Thanks!