Ok, I've narrowed down the question. I have a Regex that matches a naked URL ( http://www.whatever.com/whatever.... ) What I need to know is what to add to the beginning and end of that Regex so that it does not match if there is a double quote right before or after the URL. It's the "NOT QUOTES" thing that I'm not getting.

Hi All, I've got text going into a DB which may contain links, or naked URL's. I do cleanup on the way in to avoid XSS attacks, but on the way out, I want any URL's to display as links. So, I've got a couple possibilities. If the link is already within an anchor tag, then I want it to display properly as a link. If the link is a plain URL within the text, I need to add an anchor tag. I'm currently using: Regex.Replace(dr.Item(1), "(http|https):\/\/[\w\-_]+(\.[\w\-_]+)+([\w\-\.,@?^=%&:/~\+#]*[\w\-\@?^=%&/~\+#])", Function(match As Match) String.Format("<a href=""{0}"">{0}</a>", match.ToString()), RegexOptions.IgnoreCase) This will add an anchor tag surrounding a naked URL, but what I need is for it not to act on a URL that is already within an anchor tags. Help please?

I looked up UDTs today, and one thing that has come up is that they aren't supported in Azure, which is somewhat part of the long term plan.

Hi All, I'm looking to be able to predefine a particular user input as String, Int, or Dec (maybe others), as the particular case may be. The available datatypes are stored in a table, associated with the property (see below) that they apply to. When the user submits the filled in textbox, that entry will be put in a table column, probably as a varchar, and converted as needed, to or from the appropriate datatypes as predefined. For example, the textbox may be asking for the property of "Length," for which "Dec" is the predefined datatype. Or, the textbox may be asking for the property "Count," for which INT would be the datatype, or "Color," for which varchar would be the datatype. A single column will store all of the results, no matter which kind of datatype is actually involved. The Question: Is there a standard way of doing this kind of thing? Can you throw some keywords or techniques at me? Is it simply a bad idea to do what I'm talking about doing?

You were right.   I had made a booboo previously in my datatables.   It works now.   :)

Hi All,   I'm new to Linq. I've got the following code to take two tables, and result in the rows from table1 that are NOT in table2.   The Linq is out of the book <u>Pro Linq</u> from Apress.                   Dim seq1 As IEnumerable(Of DataRow) = table1.AsEnumerable()                   Dim seq2 As IEnumerable(Of DataRow) = table2.AsEnumerable()                   Dim except As IEnumerable(Of DataRow) = seq1.Except(seq2, System.Data.DataRowComparer.Default)                   Dim Table3 As New DataTable                   Dim NewTableColumn As DataColumn = Table3.Columns.Add("UserName")                                  'For Each row resulting from LINQ query, add to new table.                   For Each dr As DataRow In except                         Dim NewRow1 As DataRow = Table3.NewRow()                         NewRow1("UserName") = dr.Item(0).ToString                         Table3.Rows.Add(NewRow1)                   Next Obviously I don't understand something about Linq.   When the page runs through the procedure for the first time, everything works.   The variable "except" contains the correct rows.   However, after binding and postback, though I've confirmed that Table1 and Table2 contain the correct rows, the linq doesn't respond as expected.   It's as if it is doing nothing at all.   Any thoughts on this?   Thanks in advance!

Thanks N a v a n e e t h. Of course now I'm thoroughly confused. I'm a bit beyond my comfort zone here.   I know how to deal with datatables, and it seems like Stored Procedures are something that I definately need to learn about.   I just bought a SQL Server Dev book, so hopefully that'll help. It seems to me like getting data into the Stored Procedure is easier than getting it back out, and I think I'm thinking about something dreadfully wrong about the process...

I have a growing number of functions that look like some variation of the below, and it seems like there's got to be a way to generalize the whole process.   Any suggestions? Basically what I want is to load datatables from stored procedures.       Public Function UsersGetIconList(ByVal UserID As String, ByVal SPName As String, ByVal ParamArray args() As String) As DataTable             Dim DS As New DataSet("ResultSet")             Dim dt As DataTable = DS.Tables.Add("ResultTable")             Dim CON As New SqlConnection(strConnString)             Dim CMD As New SqlCommand(SPName, CON)             Dim reader As SqlDataReader             CMD.CommandType = CommandType.StoredProcedure             Try                   'Use Parameters defined in Stored Procedure to pass on Variables.                   Dim Param As SqlParameter = CMD.Parameters.Add("@UserID", SqlDbType.VarChar, 36)                   Param.Value = UserID                   Param = CMD.Parameters.Add("@User_Icon_FileLocation", SqlDbType.NChar, 256)                   CMD.Parameters("@User_Icon_FileLocation").Direction = ParameterDirection.Output                   'Open Database and Execute Query as defined in Stored Procedure.                   CON.Open()                   reader = CMD.ExecuteReader()                   dt.Load(reader)             Catch ex As Exception                   'MsgBox(ex.Message)             Finally                   CON.Close()    &nbs