Hello.

Can i insert a record in a table B during reading records in a table A (Sql
Compact Edition 3.1)?

Something like this:

SqlCeConnection c=new SqlCeConnection("Data Source=\test.sdf");

SqleConnection d=new SqlCeConnection("Data Source=\test.sdf");

SqlCeCommand cmd=new SqlCeCommand(c,"SELECT * FROM TABLE A");

SqlCeCommand cmd1=new SqlCeCommand();

cmd1.Connection=d;

cmd.Connection.Open();

cmd1.Connection.Open();

SqlceDataReader dr=cmd.ExecuteReader();

while (dr.read())

{

 string a=dr.GetString(0);

 string b=dr.GetString(1);

 cmd1.Text="INSERT INTO B VALUES('"+a+"','"+b+"')";

 cmd1.ExecuteNonQuery();

}

dr.Close();

c.CLose();

d.Close();

Thanks,Simon.