Selecting datarow from datatable using parameters

Question

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?

Vulpes · 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 + ');