datatable select rows

Question

I am using a datatable created by program. In this datatable i want to insert values in some specified columns.

Initially I am inserting primary key values leaving remaining columns null, when I am querying datatable with recently inserted value in Primary column to update same row, I am facing error Missing operand after ID operator

Can any one tell me the exact issue.

I am trying following code:

 dt.Rows.Add(1);
 int insertedValue = 1;
 DataRow[] dr = dt.Select("ID = '" + insertedValue.toString() + "'");

And the table structure after entring primary value is as follows.

ID    Volumn1    Volumn2    volumn3
--------------------------------------
1

Answer 1

You can do this more cleanly with LINQ and make this a strongly typed operation.

Something like:

dt.Rows.Add(1);
int insertedValue = 1;
var result = 
        dt.AsEnumerable().Where( dr => dr.Field<int>( "ID" ) == insertedValue );

Working example:

DataTable dt = new DataTable();
dt.Columns.Add( "ID", typeof( int ) );
dt.Rows.Add( 1 );

var result = dt.AsEnumerable().Where( dr => dr.Field<int>( "ID" ) == 1 );

Answer 2

You can simply format the selection string as shown below:

    DataRow[] dr = dt.Select(string.Format("ID ='{0}' ", insertedValue));

Feel free to let me know if this works for you.. Thanks