Click here to Skip to main content
15,887,312 members
Home / Discussions / C#
   

C#

 
SuggestionRe: loop an existenting Labels from my aspx page in my cs page Pin
Richard MacCutchan12-Mar-15 0:09
mveRichard MacCutchan12-Mar-15 0:09 
AnswerRe: loop an existenting Labels from my aspx page in my cs page Pin
F-ES Sitecore12-Mar-15 1:34
professionalF-ES Sitecore12-Mar-15 1:34 
GeneralRe: loop an existenting Labels from my aspx page in my cs page Pin
Member 1151896215-Mar-15 22:44
Member 1151896215-Mar-15 22:44 
GeneralRe: loop an existenting Labels from my aspx page in my cs page Pin
Member 1151896215-Mar-15 22:51
Member 1151896215-Mar-15 22:51 
QuestionQuickly find the information on the GridView ? Pin
Member 245846711-Mar-15 19:59
Member 245846711-Mar-15 19:59 
AnswerRe: Quickly find the information on the GridView ? Pin
OriginalGriff12-Mar-15 0:02
mveOriginalGriff12-Mar-15 0:02 
SuggestionRe: Quickly find the information on the GridView ? Pin
Matt T Heffron12-Mar-15 10:24
professionalMatt T Heffron12-Mar-15 10:24 
QuestionHow to Save changes in Dataset back to my Database Pin
David_Pollard11-Mar-15 19:24
David_Pollard11-Mar-15 19:24 
Hi Guys,
I'm running Visual Studio 2008. I have a simple project that displays data in a DataGridView that is linked to Dataset, BindingSource and TableAdapter.

My data is in SQL Server and in a single table.

My program so far reads the data in no problem but I'm stuck saving my changes back to the database.

I can see I need to create an update query. I found the properties of the TableAdapter named "UpdateCommand" When I run Query Builder it creates a query like this.

SQL
UPDATE       ExecuteItem
SET                iOrderBy =, sDescription =, bContinueOnFailure =, dLastRunTime =, bLastRunStatus =, sSQLCode =, bActive =


Obviously it is missing a name between the equals and the comma.

What is the syntax for specifying the names of my fields in the dataset?
Can someone point me to an example of how this query should look for a simple single table update?

Thanks
David
SuggestionRe: How to Save changes in Dataset back to my Database Pin
Matt T Heffron12-Mar-15 10:25
professionalMatt T Heffron12-Mar-15 10:25 
GeneralRe: How to Save changes in Dataset back to my Database Pin
David_Pollard12-Mar-15 12:36
David_Pollard12-Mar-15 12:36 
GeneralRe: How to Save changes in Dataset back to my Database Pin
David_Pollard12-Mar-15 12:54
David_Pollard12-Mar-15 12:54 
GeneralRe: How to Save changes in Dataset back to my Database Pin
Matt T Heffron12-Mar-15 13:04
professionalMatt T Heffron12-Mar-15 13:04 
Questionactivex control Pin
Member 1149283311-Mar-15 16:20
Member 1149283311-Mar-15 16:20 
QuestionMessage Removed Pin
11-Mar-15 10:22
professionalN_tro_P11-Mar-15 10:22 
AnswerRe: EntityFramework Self referencing one to many Pin
Gerry Schmitz11-Mar-15 13:02
mveGerry Schmitz11-Mar-15 13:02 
GeneralMessage Removed Pin
12-Mar-15 2:38
professionalN_tro_P12-Mar-15 2:38 
GeneralRe: EntityFramework Self referencing one to many Pin
Gerry Schmitz12-Mar-15 3:28
mveGerry Schmitz12-Mar-15 3:28 
GeneralMessage Removed Pin
12-Mar-15 4:25
professionalN_tro_P12-Mar-15 4:25 
GeneralRe: EntityFramework Self referencing one to many Pin
Gerry Schmitz12-Mar-15 4:47
mveGerry Schmitz12-Mar-15 4:47 
GeneralMessage Removed Pin
12-Mar-15 5:04
professionalN_tro_P12-Mar-15 5:04 
GeneralRe: EntityFramework Self referencing one to many Pin
Gerry Schmitz12-Mar-15 5:43
mveGerry Schmitz12-Mar-15 5:43 
QuestionTrick IIS forms authentification Pin
jonas7811-Mar-15 4:14
jonas7811-Mar-15 4:14 
AnswerRe: Trick IIS forms authentification Pin
F-ES Sitecore11-Mar-15 4:39
professionalF-ES Sitecore11-Mar-15 4:39 
GeneralRe: Trick IIS forms authentification Pin
jonas7813-Mar-15 1:51
jonas7813-Mar-15 1:51 
QuestionUpdating Code For a Newer Version Pin
Member 997225111-Mar-15 2:52
Member 997225111-Mar-15 2:52 

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.