Click here to Skip to main content
16,005,181 members
Home / Discussions / C#
   

C#

 
AnswerRe: Resolution independent application Pin
Wjousts17-Oct-06 4:35
Wjousts17-Oct-06 4:35 
Questiontab page disable question Pin
rzvme17-Oct-06 3:51
rzvme17-Oct-06 3:51 
AnswerRe: tab page disable question Pin
Thomas Chester17-Oct-06 7:03
Thomas Chester17-Oct-06 7:03 
QuestionMDI child problem... Pin
IamHuM17-Oct-06 3:45
IamHuM17-Oct-06 3:45 
AnswerRe: MDI child problem... Pin
Stefan Troschuetz17-Oct-06 4:18
Stefan Troschuetz17-Oct-06 4:18 
QuestionDataGridViewComboBoxColumn - Setting SelectedIndex Pin
KCI-VA17-Oct-06 3:31
KCI-VA17-Oct-06 3:31 
QuestionProblems with primary key Pin
mrclash88817-Oct-06 3:21
mrclash88817-Oct-06 3:21 
AnswerRe: Problems with primary key Pin
bearfx17-Oct-06 4:19
bearfx17-Oct-06 4:19 
This is basically saying you can't autogenerate the command without primary key information.

If you want to use the CommandBuilder, you need to be aware of it's limitations.

The CommandBuilder classes can be used to build update commands for single-table select queries that include at least one unique column.

Your SQL command doesn;t include a unique column, so it cannot be used. Include the primary key in your select query, and it should work, as long as it is a single-table query. If probably looks something like this
Select col1, col2, col3 from table1 where col1 = somevalue
change it to
Select pkey, col1, col2, col3 from table1 where col1 = somevalue

If it is not a single-table query, you will need to build your own insert, update, and delete queries using the InsertCommand, UpdateCommand, and DeleteCommand properties.
AnswerRe: Problems with primary key Pin
Jim Conigliaro17-Oct-06 4:23
Jim Conigliaro17-Oct-06 4:23 
GeneralRe: Problems with primary key Pin
mrclash88817-Oct-06 4:43
mrclash88817-Oct-06 4:43 
QuestionTerminating multithreaded application Pin
Pseudonaja Cyanide17-Oct-06 3:16
Pseudonaja Cyanide17-Oct-06 3:16 
AnswerRe: Terminating multithreaded application Pin
Stefan Troschuetz17-Oct-06 4:32
Stefan Troschuetz17-Oct-06 4:32 
GeneralRe: Terminating multithreaded application Pin
Pseudonaja Cyanide17-Oct-06 4:48
Pseudonaja Cyanide17-Oct-06 4:48 
GeneralRe: Terminating multithreaded application Pin
Pseudonaja Cyanide20-Oct-06 2:47
Pseudonaja Cyanide20-Oct-06 2:47 
QuestionPolicy Manager Pin
Super Lloyd17-Oct-06 2:44
Super Lloyd17-Oct-06 2:44 
AnswerRe: Policy Manager Pin
bearfx17-Oct-06 4:23
bearfx17-Oct-06 4:23 
GeneralRe: Policy Manager Pin
Super Lloyd17-Oct-06 12:52
Super Lloyd17-Oct-06 12:52 
Questionresizable movable borderless form? Pin
dolce_ckj17-Oct-06 2:36
dolce_ckj17-Oct-06 2:36 
AnswerRe: resizable movable borderless form? Pin
Martin#17-Oct-06 2:56
Martin#17-Oct-06 2:56 
AnswerRe: resizable movable borderless form? Pin
dolce_ckj17-Oct-06 22:18
dolce_ckj17-Oct-06 22:18 
QuestionHow to close a messagebox Pin
engsrini17-Oct-06 2:34
engsrini17-Oct-06 2:34 
AnswerRe: How to close a messagebox Pin
sam#17-Oct-06 2:58
sam#17-Oct-06 2:58 
GeneralRe: How to close a messagebox Pin
engsrini17-Oct-06 3:38
engsrini17-Oct-06 3:38 
AnswerRe: How to close a messagebox Pin
Guffa17-Oct-06 4:45
Guffa17-Oct-06 4:45 
GeneralRe: How to close a messagebox Pin
Dan Neely17-Oct-06 7:11
Dan Neely17-Oct-06 7:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.