By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 910 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

dataset designer problem iwth Primary key

P: n/a
GS
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
Oct 28 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
GS
never mind. close and reopen vb studio. problem gone
"GS" <gs**********************@msnews.Nomail.comwrote in message
news:%2******************@TK2MSFTNGP05.phx.gbl...
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


Oct 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.