Search results for query: *

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?

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?

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

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

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?

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

When I add tokens to my Task list and then close my app and re-open it they're gone. Has anybody else run into this? The default tokens are TODO, HACK, UNDONE, etc. It doesnt seem to be saving my custom ones.

What is the difference between the bin and the obj folder in Visual Studio?

MessageBox.Show(My.User.Name) The above code returns nothing. Anybody know why?

I used to be able to add code after InitializeComponent in the contructor for a form in Visual Studio 2003. I'm not sure where this got moved to in Visual Studio 2005. When I look in the partial class for the form I'm able to find the InitializeComponent method but I dont know where its...

My boss found this piece of code and liked the concept of it. He wants to design an interface that has a treeview on the left and a panel on the right. When you click on one of the treeview nodes it loads a user control into the panel. I've examined the code and understand how it works but...

I like to throw this question out there every once in a while... What technical magazines do you subscribe to? Where do you pick up tips and tricks? Podcasts? RSS Feeds? I've recently made the jump to Visual Studio 2005 and SQL Server 2005. Here are two books that have provided me with a lot...

Does anybody know where to find the publish version number in the Visual Studio 2005 framework? I can find the Assembly version in My.Application.Info.Version. Thanks

I have validation code in my cellvalidating event. The only problem is that when i move to a new row in my datagrid the validating event fires. Why is this? Obviously I dont want the validating event to fire unless I've tried to enter something in the particular cell. I'm using a DataGridView...

I am new to XML Commenting. I'm using Visual Basic 2005 and I wondered outside of the IDE how I would use the XML file that it generates. It seems to me that I would be able to open it in the MSDN library but not sure how.

When I call My.User.Name to return my username it returns a blank. Has anybody else run into this?