Question: I have to select specific column from my DataTable using linq
I am using this code

```
ds.Table[0].AsEnumerable().Where<DataRow>(r=>r.Field<int>("productID")==23).CopyToDataTable();

```

~

But it is giving me all columns and I need only PRODUCTNAME , DESCRIPTION , PRICE

How I can write this query?

Answer: 
`index` is a reserved word and should have not used for a table name. In your query put the word ``index`` in *`back quotes`* and execute then it should be working. 

```
String sql = "insert into `index`(iddocument,chapter,chapterdate) values (?,?,?)";

```
Try adding a space between the 2 SQL lines - the `)` and the word `values` should be separated...

```
String sql = "insert into index (iddocument,chapter,chapterdate) "
           + "values (?,?,?)";

```

Similarly, it wouldn't hurt to try adding a space between `index` and `(` - it just depends on how picky the SQL interpreter is.

Also, `index` is a bad name for a table, as index has special meaning in many databases. I assume that `index` is the name of your table, and you aren't actually trying to insert data into an index!?

Finally, not sure if you need a `;` at the end of the statement? It isn't usually required when building up the code like this, so maybe try without it first, and perhaps add it later if you're still having problems.