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

C#

 
AnswerRe: MessageBox Appearing Behind Window Pin
Gerry Schmitz17-Mar-24 6:37
mveGerry Schmitz17-Mar-24 6:37 
GeneralRe: MessageBox Appearing Behind Window Pin
Richard Andrew x6417-Mar-24 8:04
professionalRichard Andrew x6417-Mar-24 8:04 
GeneralRe: MessageBox Appearing Behind Window Pin
Gerry Schmitz17-Mar-24 10:09
mveGerry Schmitz17-Mar-24 10:09 
AnswerRe: MessageBox Appearing Behind Window Pin
#realJSOP19-Mar-24 2:12
mve#realJSOP19-Mar-24 2:12 
AnswerRe: MessageBox Appearing Behind Window Pin
M Imran Ansari6-Apr-24 10:57
mveM Imran Ansari6-Apr-24 10:57 
GeneralRe: MessageBox Appearing Behind Window Pin
Richard Andrew x647-Apr-24 6:09
professionalRichard Andrew x647-Apr-24 6:09 
QuestionUpdating sql table where textbox = ID Pin
cencom0116-Mar-24 6:51
cencom0116-Mar-24 6:51 
AnswerRe: Updating sql table where textbox = ID Pin
Dave Kreskowiak16-Mar-24 7:05
mveDave Kreskowiak16-Mar-24 7:05 
So little code and so many problems.

You never said what the error message was, but a quick glance shows this little gem:
C#
con.Close();
cmd.ExecuteNonQuery();

Why would you close the connection to the database and then try to tell it to execute your query?

And then look at your query.
C#
Update [Law_Responses] SET (Calltaker=@Calltaker, Date=@Date, City=@City, County=@County, Address=@Address) where TextBox171.text=@ID

How would your SQL server know anything at all about a TextBox in your app? It doesn't have any access to the controls in your app at all, let alone it's Text property, and it's very improbable that you have a column in your table called "Textbox171.text".

Since you're using parameters to pass values to the query already, I find it odd that you're trying, and failing, to use string concatentation to pass the value of a textbox to the query. The @ID value should also be passed as a parameter to the query.

You should also be giving your control names meaningful names and not accepting the default names in the designer. Given that this textbox is numbered 171, it seems you have a lot of work to do to make your code readable, understandable, debuggable, and supportable.

AnswerRe: Updating sql table where textbox = ID Pin
Richard Deeming17-Mar-24 23:37
mveRichard Deeming17-Mar-24 23:37 
AnswerRe: Updating sql table where textbox = ID Pin
Wei Xue2-Apr-24 20:58
Wei Xue2-Apr-24 20:58 
QuestionCreating a shortcut (LNK) Pin
Richard Andrew x6416-Mar-24 3:38
professionalRichard Andrew x6416-Mar-24 3:38 
AnswerRe: Creating a shortcut (LNK) Pin
Dave Kreskowiak16-Mar-24 4:50
mveDave Kreskowiak16-Mar-24 4:50 
GeneralRe: Creating a shortcut (LNK) Pin
Richard Andrew x6416-Mar-24 7:23
professionalRichard Andrew x6416-Mar-24 7:23 
GeneralRe: Creating a shortcut (LNK) Pin
Dave Kreskowiak16-Mar-24 11:44
mveDave Kreskowiak16-Mar-24 11:44 
QuestionHow to read and update existing language MST file (1033.mst) which is part of MSI Package using C# application? Pin
krish8812-Mar-24 20:02
krish8812-Mar-24 20:02 
AnswerRe: How to read and update existing language MST file (1033.mst) which is part of MSI Package using C# application? Pin
OriginalGriff12-Mar-24 20:02
mveOriginalGriff12-Mar-24 20:02 
QuestionSystem.Security.Cryptography.Aes Class Pin
Kevin Marois12-Mar-24 13:40
professionalKevin Marois12-Mar-24 13:40 
AnswerRe: System.Security.Cryptography.Aes Class Pin
Peter_in_278012-Mar-24 15:50
professionalPeter_in_278012-Mar-24 15:50 
GeneralRe: System.Security.Cryptography.Aes Class Pin
Kevin Marois13-Mar-24 7:44
professionalKevin Marois13-Mar-24 7:44 
AnswerRe: System.Security.Cryptography.Aes Class Pin
JudyL_MD13-Mar-24 2:05
JudyL_MD13-Mar-24 2:05 
GeneralRe: System.Security.Cryptography.Aes Class Pin
Kevin Marois13-Mar-24 7:44
professionalKevin Marois13-Mar-24 7:44 
GeneralRe: System.Security.Cryptography.Aes Class Pin
Kevin Marois13-Mar-24 8:16
professionalKevin Marois13-Mar-24 8:16 
SuggestionRe: System.Security.Cryptography.Aes Class Pin
Richard Deeming17-Mar-24 23:46
mveRichard Deeming17-Mar-24 23:46 
QuestionI want to display both Old and New Values in Form2. Pin
Sonika B S10-Mar-24 4:14
Sonika B S10-Mar-24 4:14 
AnswerRe: I want to display both Old and New Values in Form2. Pin
Dave Kreskowiak10-Mar-24 4:33
mveDave Kreskowiak10-Mar-24 4:33 

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.