Comments by Alek Massey (Top 32 by date)

Have you considered using a union?

And what does your current output look like?

I updated the solution with a link.

Can you show the code you have tried?

Good call, I withdraw my flawed solution.

I would say get started and see how far you get.
SQL will return results
Version 9 of Active reports will let you save as a pdf. There's a vb.net exxmple on the page linked below.
Export Method (PdfExport)[^]

What is the problem you are having?

Use the debugger to step through your code.

Can you show the line of code (in context) that is giving the error?

If formatting of visible objects is dependent on whether another, potentially hidden object is visible, you need to to remove that dependency.

Are you attempting to separate the date and time out of a cell with datetime?

Possibly he means it works fine as is but he doesn't know how to add multiple datetime columns.

You need to provide some code for us be able to help you.

Updates rarely(if ever) should be attempting to create permanent views or tables)

What is failing?

Send them a verification email with a link containing a guid that will take them to a page on your site that will use that guid to mark it verified on your system.

This is more valuable than just knowing it is a real email address. You then know if it is really their email.

Lots of sites do this.

Answer is here.sql server - Pass string into SQL WHERE IN - Stack Overflow[^]

Likely suspects, the ' is not a single quote in your db or the - is not a dash in your db.

Debug your app and see what vList looks like with a broader 'contains' expression statement.
Something like,

var expression = "ClaimInfo"var vList= (from vocab in db.Vocabularies           where vocab.Expression.ToUpper().Contains(expression.ToUpper())           select vocab).ToList();

Compare that result to using the following:

var expression = "'ClaimInfo'"

and

var expression = "local-name"

I updated my solution. Thanks for the upvote.

Were there blank lines in the output from your code previously?

The word you want is impersonation.

User Impersonation in .NET[^]

Here is a method using regex.replace to filter a string of unwanted characters.
I got this from https://docs.microsoft.com/en-us/dotnet/standard/base-types/how-to-strip-invalid-characters-from-a-string

using System;
using System.Text.RegularExpressions;

public class Example
{
static string CleanInput(string strIn)
{
// Replace invalid characters with empty strings.
try {
return Regex.Replace(strIn, @"[^\w\.@-]", "",
RegexOptions.None, TimeSpan.FromSeconds(1.5));
}
// If we timeout when replacing invalid characters,
// we should return Empty.
catch (RegexMatchTimeoutException) {
return String.Empty;
}
}
}

You've checked the session value is returning what you expect?

Agreed, an Excel application is huge resource wise.
Use the openxml SDK. It works.

What does the generated csv file (MappingData.txt) look like in notepad?

Excel is interpreting commas in your data as a delimeter between separate values.