Search results for query: *

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...

vovan1415, my advice is and has always been to invest in some type of training rather than a book. .NET is immense and there is a lot to learn and it can be overwhelming. Check out the .NET training series from AppDev, its what I used and it brought me up to speed a lot quicker than a book...

How do I bind a grid to a stored procedure in Visual Studio 2005? The twist is that I would like to setup the grid at design time. Column headings, sizes, any additional formatting that I would otherwise have to do in code. Do I somehow create a dataset to bind the grid to initially?

longolongo, my advice is and has always been to invest in some type of training rather than a book. .NET is immense and there is a lot to learn and it can be overwhelming. Check out the .NET training series from AppDev, its what I used and it brought me up to speed a lot quicker than a book...

chrisse1, I'm using the Data Access Application Block and I'm able to just pass in the name of the stored procedure and a parameter array and it figures everything else out... I'm not creating my own command object... the DAAB is doing that for me.

Consider this code... If a = True Then 'add sqlparameter to parameter array End If If b = True Then 'add sqlparameter to parameter array End If If c = True Then 'add sqlparameter to parameter array End If Each time this code runs the parameter array could change sizes... The first...