Search code examples
c#winformsreplication

(Replication) System.Data.SqlClient.SqlException: 'Invalid column name'

I encounter this error while trying to load data from a subscription

Subscription's articles:

Subscription's articles

Error:

Error details

Translation:

In table SINHVIEN(Student) there are columns include MASV(student ID), HO(last name), TEN(first name), MALOP(Class ID, Foreign Key), DANGHIHOC(Dropped out)

Columns: PHAI(sex), DIACHI(address), NGAYSINH(date of birth), PASSWORD from subscription database aren't exist due to replication.

How can I solve this error? I think i should add a new Dataset from subscription but is there any better method?

Solution

  • Since you don't have some columns you have to try to change the select statement

    Try this

    SELECT MASV, HO, TEN, MALOP, DANGHIHOC FROM SINHVIEN