Data adapter configureation error

liunx

Guest
Hi everybody. I got a db in sql server and it has 6 tables inside it .One of
the table that i want to create a datagrid using visual studio .net 2003 is
called matches. Unfortunetly when i try Right-click on the DataAdapter and choose Generate DataSet
i get the following errors.The table matches exist in sql server 2000 with data inside it but
i do not know why i get these error. I be happy if some one help me fix this problem.Thanks

1)Data adapter configureation error

Generated INSERT statement
Could not determine which columns uniquely identify the rows for "MATCHES"

Generated Delete statement

Cold not determine which columns uniquely identify the rows for " MATCHES"

2)date adaper configuration wizard

The wizard detected the following problems when configurng the data adapter
"sqlDataAdapter1"

Details:

Generated SELECT statement
invalid object name " matches"

3)
sqlDataAdpater1.The data adapter could not return the data from the
data source.

Invalid objet name "MATCHES"

4)
Retrieving the schema for SqlDataAdpater1 failed.
Invalid object name "MATHES"
 
Back
Top