Loading

Selecting datarow from datatable using parameters

Dean

Hi all;

In a Windows form, I'm trying to select a value from a datatable like so:

DataRow[] row = Customers.Select("name = '" + this.tbName.Text + "'");

Problem is, the value in tbName.Text can contain a string with an apostrophe, so naturally I need to escape it. Is there any way of using a parameter in this statement to get around this problem? Something like DataRow[] row = Customers.Select("name = @Name"); where Name = this.tbName.Text for example?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
I think what you'll need to do is to test whether tbName.Text already contains any apostrophes and, if it does, double them before including it in the filter:

string temp = this.tbName.Text;

if(temp.Contains("'"))
{
temp = temp.Replace("'", "''");
}

DataRow[] row = Customers.Select("name = '" + temp + "'");