Recent content by DH

Hello, I have field which currently allows users to enter the ages of their children. Currently this information is entered in one field in the following format 2,12 which means 2 children of ages 2 and 12. The following sql statement returns the information in one row: SELECT...

I guess the best way to put it that initially the value is unkown. A visitor to the site supplies the value as part of the URL so it will be unkown initially. I have been working with the following code that is working nicely but needs a little fine tuning: Dim domainName As String =...

Hmmn. don't follow you. I will not know what the value is until I parse it from the URL, so a variable will not help in this case. I need to extract it from the URL at which time I will store it in a variable. DH

Requirement in this case is that the 'Foo' part is dynamic and will never been the same. DH

Hello, Any suggestions or examples on how to use a regular expression to parse a url address? For example, if the URL address is: http://www.mysite.com/foo -or- http://www.mysite.com/foo/anythingelse I am interested in grabbing the 'foo' part. DH

I display the rows in a datagrid, each row of the datagrid has a checkbox which allows the user to select a row. I then loop through the datagrid rows to grab the ids for the selected rows.

I'm having a little trouble finding the index of a row when I only know the value of a field. For example, I have a column named 'invoiceNumber' with a value '12345' DH

Hello, I am using the following code to create a dataTable: Shared Function GetDataTable() As DataTable Dim da As SqlDataAdapter Dim ds As New DataSet Dim sConn As String = ConfigurationSettings.AppSettings("SqlConnection1.ConnectionString") Dim oConn As...

Awesome, works perfect! Thanks for your help 2night. DH

As an example, lets say I have the follwing exampleTable with 2 columns and data like so: userId expirationDate --------- -------------- 8 6/05/2006 24 6/15/2006 30 6/22/2006 I would like to use the following WHERE clause to grab certain rows of data: SELECT...

Hello, I am writing a query to return results to use in a export file. One of the columns is I need to manually create is 'assetID' and per the specs, I need to: "Starting with the value of 1, increment 'assetID' for each record created. For simple example the following: USE Northwind...

Thank you! DH

Hello, I am using the folling code to hide or display a panel depending on which radio button has been selected. computer selected: display panel1 hide panel2 website selected: display panel2 hide panel1 Works fine except that when the 'website' radio button is selected 'panel2' displays but...

Thanks ESquared, I ended up using the link you provided above along with http://www.4guysfromrolla.com/webtech/031004-1.shtml to arrive at a solution. I created the following User Defined Function (UDF): CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) )...

Thanks ESquared, I will check out the fixed-length array link now! DH