Recent content by sqlsamurai

You're right ca8msm I could but I want to preserve the case of the text. Thanks for the sugg though.

I'm sorry if i was unclear. I'm looking for an expression that will find the word INTO. Basically i would like the pattern to find the word INTO followed by a space then a pound sign (#) then a wildcard for the temp table name then another space. Thanks

Thanks jebenson! I just posted another question about regular expressions... think you could take a peak. ;-) [2thumbsup]

These are my examples: SELECT * INTO #TEMP FROM TABLE SELECT * INTO #TEMP FROM TABLE Could somebody please show me how to create a regex pattern that would find the bolded area in the texts above. The portion in italics, TEMP, can vary as that will be the name of the temp table. Thanks

Can I do a case insensitive replace using String.Replace? Is there a better way?

Thanks for all the suggestions guys. ;-) In the end this is what I used. If My.Settings("StartDate").GetType.Equals(GetType(Date)) Then End If

I want to test an object for type and I'm not sure how. Here is the object: My.Settings("StartDate") I want to test the value to see what type it is. Like this If My.Settings("StartDate").GetType = DateTime then ... End IF Could somebody help?

Yes it is... I guess I was making it more complicated that it was. ;-) Star for you.

How would I consolidate these three statements? The only difference is one of the fields in the WHERE statements. I'm using SQL Server 2005 if that makes any difference. SELECT Inventory.*, Products.IjoistTypeID FROM Products INNER JOIN Inventory ON Products.ProductID = Inventory.ProductID...

Here is an excerpt from a book called: "Visual Studio .NET Tips and Tricks" By Minh T. Nguyen Rethrowing the Same Exception Whenever an exception needs to be logged, developers tend to use code similar to the following to log an exception without eating it up: Try {...} catch (Exception...

Here's a response I got on another board just thought it might help somebody else: The reason you can butt the parenthasis together is because of the way the properties work. It is the same concept as that of chaining together a bunch of dots, like this: Me.TextBox1.Text The first dot tells...

Thanks guys. I just wasnt sure if there was a name for this concept.

Can someone help me decifer this line of code? I saw it somewhere and have used it a couple of times but I'm not sure what the concept is called or why it works. Me.cboDivisions.Properties.GetDataSourceRowByKeyValue(Me.cboDivisions.EditValue)("LocationID").ToString If this piece of code were...

I cant find "Generate Method Stub" in VB .Net 2005. Anybody know where it is? I was also bummed to learn that VB doesnt have all the refactoring features that C# does. :(

I was messing around with the datasources window, I drug a stored procedure from there onto a form and a lot of stuff created itself automatically. Here is my question. The Fill method on the TableAdapter looks like this: and the code created looks like this...