It works perfectly, but how to involve the data relation in it?

Current code:

myDS.Relations.Add("EmpUsrRts", myDS.Tables("Employee").Columns("EmployeeID"), myDS.Tables("UserRights").Columns("EmployeeID"))

Me.dgUserRights.SetDataBinding(myDS, "Employee.EmpUsrRts")

Thanks again Plamen


>No, you do not need to change or remove your DataSet. Just bind DataGrid to the DataView of the table. If now you have:
>

>DataGrid1.DataSource = DataSet1.Tables(0)
>

>you must change this to:
>

>DataSet1.Tables(0).DefaultView.AllowNew = False
>DataGrid1.DataSource = DataSet1.Tables(0).DefaultView
>