Hi guys
I made this code for win forms datatgridview.
I want to use it in WPF Datagrid but in WPF Datagrid i can't use datagridview.Rows.Add.
Can someone help please
Private Sub fill_plan()
EmployeeGridView.Rows.Clear()
Try Dim i As Integer = 0
con.Open()
Dim query As String = "SELECT UnitID,Unit,Udate,State FROM Units where Month(Udate) =" & cmbMonth.SelectedIndex + 1 & ""
cmd = New SqlCommand(query, con)
myDR = cmd.ExecuteReader If myDR.HasRows Then While myDR.Read
EmployeeGridView.Rows.Add()
EmployeeGridView.Rows(i).Cells(0).Value = myDR.GetInt32(myDR.GetOrdinal("UnitID"))
EmployeeGridView.Rows(i).Cells(1).Value = myDR.GetString(myDR.GetOrdinal("Unit"))
Dim myday As Integer = DatePart(DateInterval.Day, myDR.GetValue(myDR.GetOrdinal("Udate")))
EmployeeGridView.Rows(i).Cells(myday + 1).Value = myDR.GetInt32(myDR.GetOrdinal("State"))
i = i + 1
End While
End If
myDR.Close()
con.Close()
Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Critical, "Σφάλμα")
End Try
End Sub
