how to use datatable as Datasource with Datagridview unless datagridviewrow
-
my idea is to use datatable as Datasource to my datagridview which is named : dgvW2PNew so i tried to convert Datagridviewrow to datarow to import it in datatable just like that can some one tell me if i am doing wrong or suggest some thing else to me this is my code:
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2PNew)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
sField_CodeID,
sField_ExtOrderID,
sField_pscArticleID,
nField_ItemID,
nField_OrderID,
nField_Quantity,
sField_Art,
sField_ArtIntern,
sField_Ref,
sField_InfoValue,
sField_ShippingCompany,
sField_DeliveryDate,
sField_InsertDate,
sField_ArtExtern,
nField_ProductLength,
nField_ProductWidth,
nField_ProductGrammage,
sField_PrintMaterial,
sField_PrintColor,
)dgvW2PNew.Rows.Add(MyRow) Dim dt As New DataTable dt.ImportRow(MyRow) '' bindingSource\_data.DataSource = dt 'dgvW2PNew.DataSource = dt Catch ex As Exception ErrorLogging(True, "Sub FillW2PGrid: Zeile im Grid ergänzen" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel\_Error) Finally If Not MyRow Is Nothing Then MyRow.Dispose() MyRow = Nothing End If End Try
-
my idea is to use datatable as Datasource to my datagridview which is named : dgvW2PNew so i tried to convert Datagridviewrow to datarow to import it in datatable just like that can some one tell me if i am doing wrong or suggest some thing else to me this is my code:
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2PNew)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
sField_CodeID,
sField_ExtOrderID,
sField_pscArticleID,
nField_ItemID,
nField_OrderID,
nField_Quantity,
sField_Art,
sField_ArtIntern,
sField_Ref,
sField_InfoValue,
sField_ShippingCompany,
sField_DeliveryDate,
sField_InsertDate,
sField_ArtExtern,
nField_ProductLength,
nField_ProductWidth,
nField_ProductGrammage,
sField_PrintMaterial,
sField_PrintColor,
)dgvW2PNew.Rows.Add(MyRow) Dim dt As New DataTable dt.ImportRow(MyRow) '' bindingSource\_data.DataSource = dt 'dgvW2PNew.DataSource = dt Catch ex As Exception ErrorLogging(True, "Sub FillW2PGrid: Zeile im Grid ergänzen" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel\_Error) Finally If Not MyRow Is Nothing Then MyRow.Dispose() MyRow = Nothing End If End Try