set primary key option is greyed out in the dataset designer for a table
Details
In an vb.net express 2005 project, I have a dataset associated with table.
lets call this table codetable. the dataset is an ms sql express mdf.
in a different project, I use the vb studio data designer to change the
codetable in the mdf. I set Primary Key first columns instead of just one.
saved also changed the corresponding vsd file in designer.. it worked
wonderfully for the 2nd project.
after I open the original project, open the corresponding dataset .vsd file
in designer, I found, the codetable still has only one column as primary
like before.
"No problem". I thought I can highlight the columns and set primary key
again. however the set primary key option is greyed out.
the only difference between the datasets in the projects is: the first
project dataset has an extra table adapter is, GetDataBy I use to fill
with a datagridview with order by
I tried in the first project to delete the extra adaptor but no luck
what can I do
Details
In an vb.net express 2005 project, I have a dataset associated with table.
lets call this table codetable. the dataset is an ms sql express mdf.
in a different project, I use the vb studio data designer to change the
codetable in the mdf. I set Primary Key first columns instead of just one.
saved also changed the corresponding vsd file in designer.. it worked
wonderfully for the 2nd project.
after I open the original project, open the corresponding dataset .vsd file
in designer, I found, the codetable still has only one column as primary
like before.
"No problem". I thought I can highlight the columns and set primary key
again. however the set primary key option is greyed out.
the only difference between the datasets in the projects is: the first
project dataset has an extra table adapter is, GetDataBy I use to fill
with a datagridview with order by
I tried in the first project to delete the extra adaptor but no luck
what can I do
Comment