在ODBC中处理单引号问题 [英] Handling Single Quote Issue in ODBC

问题描述

大家好，

我正在尝试使用where语句查询CSV文件.以下是代码:-

Hi Guys,

I am trying to query a CSV file using where statement. Following is the code:-

Line 1: string sDataValue = "Icom 20'' Extension Cable f/COMMANDMIC";
Line 2: DataTable dtCSV = new DataTable();
Line 3: string strConnString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=data.csv;Extensions=asc,csv,tab,txt"
Line 4: OdbcConnection CsvConn = new OdbcConnection(strConnString);
Line 5: CsvConn.Open();
Line 6: string strSQL;
Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = ''" + sDataValue + "''";
Line 8: OdbcCommand cmdSelect = new OdbcCommand(strSQL, CsvConn);
Line 9: cmdSelect.Connection = CsvConn;
Line 10: OdbcDataAdapter daCSV = new OdbcDataAdapter(cmdSelect);
Line 11: daCSV.Fill(dtCSV);

在第11行中，引发了以下异常:

In Line 11 the following exception is thrown:

ERROR [42000] [Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression ''[ProductXName] = ''Icom 20'' Extension Cable f/COMMANDMIC''.

当我从sDataValue中删除单引号('')时，查询将毫无例外地执行.但是sDataValue应该具有单引号.如何解决此问题?

非常感谢您对他的解决方案.

Mohandas

When I remove the single quote ('') from sDataValue, the query executes without any exception. But the sDataValue should have the single quote. How could this issue be handled?

Your solution to his issue will be highly appreciated.

Mohandas

推荐答案

最简单的方法，

Easiest way,

Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = ''" + sDataValue.Replace("''", "''''") + "''";

正确的方法，
使用参数化查询.

Proper way,
Use parameterised query.

Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = ?";
Line 8: OdbcCommand cmdSelect = new OdbcCommand(strSQL, CsvConn);
        cmdSelect.Parameters.AddWithValue("@column1", sDataValue);
Line 9: cmdSelect.Connection = CsvConn;

检查下面给出的链接:

快速CSV阅读器 [

Check the link given below:

A Fast CSV Reader[^]

这篇关于在ODBC中处理单引号问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！