Click here to Skip to main content
14,540,528 members
   

C#

 
GeneralRe: Igroupping with Parallel Pin
Pete O'Hanlon1-Mar-20 22:42
subeditorPete O'Hanlon1-Mar-20 22:42 
GeneralRe: Igroupping with Parallel Pin
Richard Deeming1-Mar-20 23:57
mveRichard Deeming1-Mar-20 23:57 
Generaladd DISTINCT drop PARALLEL Pin
Luc Pattyn2-Mar-20 0:48
sitebuilderLuc Pattyn2-Mar-20 0:48 
Generaldrop TOLIST, avoid memory stress Pin
Luc Pattyn2-Mar-20 9:13
sitebuilderLuc Pattyn2-Mar-20 9:13 
AnswerRe: Igroupping with Parallel Pin
Eddy Vluggen1-Mar-20 13:47
professionalEddy Vluggen1-Mar-20 13:47 
GeneralRe: Igroupping with Parallel Pin
Member 110035101-Mar-20 22:18
MemberMember 110035101-Mar-20 22:18 
QuestionError must declare scalar variable @ISBN update statement c# Pin
Member 1164145429-Feb-20 5:20
MemberMember 1164145429-Feb-20 5:20 
AnswerRe: Error must declare scalar variable @ISBN update statement c# Pin
OriginalGriff29-Feb-20 5:38
mveOriginalGriff29-Feb-20 5:38 
Firstly, that's not how you use Parameterised queries:
string cmd_query = "UPDATE [book_tbl] SET [Type_ID] = '@cmbtyp', ...";
Does not set the Type_ID column to the value of cmbtype.Text it sets it to a litteral string "@cmbtype". To set a parameter value, you need to get rid of the quote marks:
string cmd_query = "UPDATE [book_tbl] SET [Type_ID] = @cmbtyp, ...";
In addition, you don't need square brackets round every name, just teh ones that contain spaces, or which conflict with SQL keywords:
string cmd_query = "UPDATE book_tbl SET Type_ID = @cmbtyp, ...";


Secondly, AddWithValue doesn't have an override that takes a Type: so the value it initially sets is the value of the enum, not the value you think.
Try this:
cmd.Parameters.AddWithValue("@isbn", txtISBN.Text);


Thirdly, an ISBN is not an integer! The max value in an SQL INT is 2,147,483,647, which is only 10 digits, and from 2007 they are always 13 digits.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
Member 1164145429-Feb-20 22:20
MemberMember 1164145429-Feb-20 22:20 
GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
OriginalGriff29-Feb-20 22:42
mveOriginalGriff29-Feb-20 22:42 
GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
phil.o29-Feb-20 22:44
mvephil.o29-Feb-20 22:44 
QuestionESENTUTL in C# Pin
colins528629-Feb-20 4:28
Membercolins528629-Feb-20 4:28 
AnswerRe: ESENTUTL in C# Pin
OriginalGriff29-Feb-20 5:40
mveOriginalGriff29-Feb-20 5:40 
AnswerRe: ESENTUTL in C# Pin
Luc Pattyn29-Feb-20 9:27
sitebuilderLuc Pattyn29-Feb-20 9:27 
AnswerRe: ESENTUTL in C# Pin
Dave Kreskowiak29-Feb-20 10:38
mveDave Kreskowiak29-Feb-20 10:38 
AnswerRe: ESENTUTL in C# Pin
colins52861-Mar-20 22:50
Membercolins52861-Mar-20 22:50 
GeneralRe: ESENTUTL in C# Pin
Richard Deeming1-Mar-20 23:49
mveRichard Deeming1-Mar-20 23:49 
GeneralRe: ESENTUTL in C# Pin
colins52862-Mar-20 6:48
Membercolins52862-Mar-20 6:48 
GeneralRe: ESENTUTL in C# Pin
Richard Deeming2-Mar-20 7:08
mveRichard Deeming2-Mar-20 7:08 
AnswerRe: ESENTUTL in C# Pin
Mc_Topaz3-Mar-20 21:48
MemberMc_Topaz3-Mar-20 21:48 
QuestionNeed to Change DatagridView POP background color from Vincenzo Rossi Pin
Member 1464144527-Feb-20 17:25
MemberMember 1464144527-Feb-20 17:25 
AnswerRe: Need to Change DatagridView POP background color from Vincenzo Rossi Pin
Pete O'Hanlon27-Feb-20 20:30
subeditorPete O'Hanlon27-Feb-20 20:30 
AnswerRe: Need to Change DatagridView POP background color from Vincenzo Rossi Pin
OriginalGriff27-Feb-20 20:33
mveOriginalGriff27-Feb-20 20:33 
QuestionOutlookaddin Pin
Member 1475442324-Feb-20 19:26
MemberMember 1475442324-Feb-20 19:26 
AnswerRe: Outlookaddin Pin
OriginalGriff24-Feb-20 20:28
mveOriginalGriff24-Feb-20 20:28 

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.