Hi,
oDsUserList.Tables[0].DefaultView.RowFilter = "[USER_NAME] LIKE '" + oTools.CompileSQL(txtLookForNames.Text) + "%" + "'";
oDsUserList.Tables[0].DefaultView.RowFilter = "USER_NAME LIKE '" + oTools.CompileSQL(txtLookForNames.Text) + "%" + "'";
The above mentioned codes of mine turns out an exception when the txtLookForNames.Text is " [ " (Left - Square bracket )
Can you find me a solution for the same.
oDsUserList.Tables[0].DefaultView.RowFilter = "[USER_NAME] LIKE '" + oTools.CompileSQL(txtLookForNames.Text) + "%" + "'";
oDsUserList.Tables[0].DefaultView.RowFilter = "USER_NAME LIKE '" + oTools.CompileSQL(txtLookForNames.Text) + "%" + "'";
The above mentioned codes of mine turns out an exception when the txtLookForNames.Text is " [ " (Left - Square bracket )
Can you find me a solution for the same.