Keyword Not Supported UNICODE in visual studio

Question

Hello,i'm Using Visual Studio 10 and as a back end using oracle 9 i,when i do operations on data like insert,update,delete through web form i got the error that keyword UNICODE is not supported. Please suggest me and Thanks in Advance.

I have wriiten my conncetion string as like,

<add name="conn"  connectionstring="Data Source=CGS1DB15; User ID=cgs1db; unicode=true"/> 

Answer 1

Use Linq to datatable, refer sample.

DataTable dtMain = new DataTable();
DataTable dt1 = new DataTable();
//bind datatable

var rows1_10 = from item in dt1.AsEnumerable()
     select item;
var top1_10 = rows1_10.Take(10);

//do a for-loop and insert into dtMain

DataTable dt2 = new DataTable();
//bind datatable
var rows2_10 = from item in dt2.AsEnumerable()
     select item;
var top2_10 = rows2_10.Take(10);

//do a for-loop and insert into dtMain

Answer 2

Hi Purna,
Try to create  two temp datasets with a datatable containing 10 rows. and bind these two dataset to gridviews seperately.
Thanks
Rajesh