-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: DotNetSaavy (Mr.BabuRaj)
Message 3 in Discussion
Sooraj,
I'm still not able to get rid , now I am getting the error This row already
belongs to another table.
earlier the error was This row already belongs to this table.
The code that generates the above error is as follows
Dim rowpos As Integer
Dim DS As DataSet
Dim MyCommand As SqlDataAdapter
Dim dt As New DataTable
Dim dr As DataRow
Dim cnt As Integer
cnt = 0
'Get the row position of the row to copy
'***************************************
rowpos = CInt(e.Item.ItemIndex + 1)
MyCommand = New SqlDataAdapter("select * from testbabu", myConnection)
DS = New DataSet
MyCommand.Fill(DS, "table1")
'************************************************************************************************
Dim dc As DataColumn
Dim newRow As DataRow
newRow = dt.NewRow
For Each dr In dt.Rows
If cnt = CInt(e.Item.ItemIndex) Then
For Each dc In dt.Columns
newRow(dc.ColumnName) = dr(dc.ColumnName)
Next
Exit For
End If
cnt = cnt + 1
Next
DS.Tables(0).Rows.InsertAt(newRow, rowpos)
DS.Tables(0).AcceptChanges()
DataGrid1.DataSource = DS.Tables("table1").DefaultView
DataGrid1.DataBind()
DataGrid1.EditItemIndex = rowpos
BindGrid()
Thanks
BabuRaj
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
