<div>
use a disconnected recordset (set rs.activeconnection = nothing)
</div>


use a disconnected recordset (set rs.activeconnection = nothing)

<div>
Thanks,i have got it right from the solution u have provided.<br />
rgds,
</div>


Thanks,i have got it right from the solution u have provided.
rgds,

<div>
<div class="content wysiwyg-content">
I want to update more than one row in datagrid.Single row updation is working perfect.But when i try to go to next rw it says insufficent key information for inserting or updating. Iam manually writing code for updation, so is it possible to capture the row change event of datagrid so i can prevent the datagrid from updating by itself?<br />
Iam stuck up at this point, mabe one of u out there could figure an answer easily.<br />
thanks , 
</div>
</div>


I want to update more than one row in datagrid.Single row updation is working perfect.But when i try to go to next rw it says insufficent key information for inserting or updating. Iam manually writing code for updation, so is it possible to capture the row change event of datagrid so i can prevent the datagrid from updating by itself?
Iam stuck up at this point, mabe one of u out there could figure an answer easily.
thanks , 

Updating more than one row in datagrid

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.