You searched for the word(s): userid:760899

More Search Options

RSS Available

• Re: problem in validating email address in C#

  Probably the regular expression you are using. Look around on regexlib.com or somewhere to find a better regular expression: http://regexlib.com/DisplayPatterns.aspx?cattabindex=0&categoryId=1

  Posted to Web Forms (Forum) by doyleits on 7/31/2008

• Re: writing " inside a ""

  In VB.NET, use 2 double-quotes to represent a single double-quote in the string: TXTWriter.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>") In C#, use the backslash to escape the double-quote in the string: TXTWriter.WriteLine("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");

  Posted to Getting Started (Forum) by doyleits on 7/7/2008

• Re: How to keep synchronized

  There are several products available that can help sync your files. One in particular that I've heard good things about is FolderShare ( https://www.foldershare.com/learnmore.aspx ), which I believe uses bittorrent to sync the files.

  Posted to Getting Started (Forum) by doyleits on 5/20/2008

• Re: Capturing a passed variable for use with an SQL Query?

  VB.NET does not do string replacements unless you explicity specify (using the String's Format or Replace methods). If you are looking for string concatenation, try "... where Program_ID = " & pid.ToString()

  Posted to Visual Basic .NET (Forum) by doyleits on 5/19/2008

• Re: CSV - Ignoring Splitters in columns with quotes

  I think you could still use a single INSERT statement, you just need to retrieve all the values first. The code that follows is an approximation, so you'll likely have to tweak it. string line = reader.ReadLine(); // get position of first quote int quotePosition = line.IndexOf( "\" "); // get the first part, which should be IDs string firstPart = line.SubString(0, quotePosition); // get second part string secondPart = line.SubString(quotePosition, line.Length - quotePosition);

  Posted to C# (Forum) by doyleits on 5/19/2008

• Re: CSV - Ignoring Splitters in columns with quotes

  What you could do is find the first index of a quote, and split the string there. The first portion would then be split with commas to get your IDs out, and the second would be your entire Verse input (minus the beginning and ending quotes). Its seems like a hack, but it might work the way you need.

  Posted to C# (Forum) by doyleits on 5/19/2008

• Re: Insert Null into Database

  If you were using parameterized queries, you could use DBNull.Value as the parameter value, which would pass null. If you were using a stored procedure, you could have logic to examine the fields and replace empty strings with null. However, for your example, you can check the value of PH as you build your SQL string, using the IIF statement, which is similar to a ternary operator: Dim MYSQL As String = "INSERT INTO mytable (UnitNumber, Time, PH, Other) VALUES ( '" & _ UnitNumber

  Posted to Data Access and ObjectDataSource Control (Forum) by doyleits on 5/19/2008

• Re: Why is this hanging on HandleDBNull?

  The other application either has the function HandleDBNull declared (in the same page, a Utility class, etc), or is referencing an library or assembly in which HandleDBNull is declared. You need to either reference that same library, or add the HandleDBNull function (code and all) to your new application. Bottom line, the function is not declared in your assembly right now

  Posted to Web Forms (Forum) by doyleits on 5/19/2008

• Re: String Replace not working from web service results

  Remember, strings are immutable objects (they can't be changed after they are created -- they create new objects). So, try text = text.Replace("200.00", "225.00");

  Posted to Web Forms (Forum) by doyleits on 5/15/2008

• Re: Need Help to solve this problem

  Use your variables you pass into the procedure: declare @CountryName varchar(255) -- or whatever set @CountryName = (select [Name] from dbo.Country where [Id] = @Country_Id) set @Branch_Name = @City + ' ' + @CountryName

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by doyleits on 5/15/2008