-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: maestrosajesh
Message 1 in Discussion
Dim Dt As New DataTable()
DataGrid1.DataSource = Dt
Dt01.Columns.Add("PrinterName", GetType(String))
Dt01.Columns.Add("JobID", GetType(String))
Dt01.Columns.Add("Over", GetType(Boolean))
Dt02.Columns.Add("CID", GetType(String))
Dt02.Columns.Add("PrinterName", GetType(String))
Dt02.Columns.Add("JobID", GetType(String))
dtTemp.Columns.Add("CID", GetType(String))
dtTemp.Columns.Add("PrinterName", GetType(String))
dtTemp.Columns.Add("JobID", GetType(String))
Ds.Tables.Add(Dt01)
Ds.Tables.Add(Dt02)
Ds.Relations.Add("test01", Ds.Tables("t1").Columns("JobID"),
Ds.Tables("t2").Columns("JobID"))
Dim i As Integer
For i = 1 To 5
Dim Dr As DataRow
Dr = Dt01.NewRow
Dr("PrinterName") = "A"
Dr("JobId") = i
Dr("Over") = False
Dt01.Rows.Add(Dr)
Next
i = 0
For i = 3 To 5
Dim Dr As DataRow
Dr = Dt02.NewRow
dr("CID") = i + 1
Dr("PrinterName") = "A"
Dr("JobId") = i
Dt02.Rows.Add(Dr)
Next
Dim drCol As DataRow
Dim drChildCol() As DataRow
MsgBox(Dt01.Rows.Count)
For Each drCol In Ds.Tables("t1").Rows
drChildCol = drCol.GetChildRows("test01")
If drChildCol.Length = 0 Then
'Dt01.Rows.Find(drCol("JobID")).Delete()
'here i want to delete a particular Row from dt01 Datatable which dont have childs
records in dt02 Datatable
Else
Dim dr As DataRow
For Each dr In drChildCol
MsgBox(dr("CID"))
Next
End If
Next
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_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]
