Update query in c#

I also checked during the step-thru to make sure the value was assigned. Can you test your update query in SSMS with a hard coded CustomerID value in your short update query and this page to see how that works? Sorry I double checked something and the short query worked when I hard coded both the name and the CustomerID.

It did not work when I just hard coded the CustomerID. Could you show me your Customer table structure column names and data type? Do you have a column named as CustomerID?

Here is the table structure. I also re-ran the short query with the Name hard coded only and it worked. Do you think it may be something with the textboxes?? It wouldn't work for me. It ran liked it did but when it redirected back to the customer screen is didn't show the update. Ask a question. Quick access. Existing Members Sign in to your account.

This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual.

Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid.

Let's work to help developers, not make them feel stupid. Related Questions. Backup and restore SQL database using system. Sql: group by, sum, update. How to migrate database in ms SQL server. Insert and update in sql table using datagrid in WPF. Saving edits in a SQL database in C. Layout: fixed fluid. Web04 2. Strip HTML. Encode HTML. Paste as-is. Code block. Quoted Text. Best guess. PadRight 10 , dr [ "FirstName" ]. VarChar , 10 ; nonqueryCommand.

Parameters [ " FirstName" ]. Parameters [ " LastName" ]. CommandText ; Console. Map Parameters UpdateCmd. CreateCommand ; nonqueryCommand. Generic ; using System. Linq ; using System.

Related posts: VB. The "main" function in this class will be executed first in the whole project when the project is executed. Tell us what you're thinking Name required. Mail will not be published required. This blog uses the cross-linker plugin developed by Web-Developers. NET Languages. Premium Not Free Video Tutorials.