c# - The SqlParameterCollection only accepts non-null SqlParamter type objects, not String objects -

- 

sqlcommand cmd = con.createcommand(); cmd.commandtext = "insert records ([student id], [first name], [last name], " +                    "[middle initial], gender, address, status, year, email, course, " +                    "[contact number]) values ( @student id,  @first name, @last name, " +                    "@middle initial, @gender, @address, @status, @year, @email, " +                    "@course, @contact number)";          sqlparameter p1 = new sqlparameter("@[student id]", sqldbtype.int);         p1.value = textbox1.text;         cmd.parameters.add("1");         sqlparameter p2 = new sqlparameter("@first name", sqldbtype.varchar);         p2.value = textbox2.text;         cmd.parameters.add("p2");         sqlparameter p3 = new sqlparameter("@last name", sqldbtype.nvarchar);         p3.value = textbox3.text;         cmd.parameters.add("p3");         sqlparameter p4 = new sqlparameter("@middle initial", sqldbtype.nchar);         p4.value = combobox1.text;         cmd.parameters.add("p4");         sqlparameter p5 = new sqlparameter("@gender", sqldbtype.nchar);         p5.value = combobox2.text;         cmd.parameters.add("p5");         sqlparameter p6 = new sqlparameter("@address", sqldbtype.varchar);         p6.value = textbox4.text;         cmd.parameters.add("p6");         sqlparameter p7 = new sqlparameter("@status", sqldbtype.nchar);         p7.value = combobox3.text;         cmd.parameters.add("p7");         sqlparameter p8 = new sqlparameter("@year", sqldbtype.varchar);         p8.value = combobox4.text;         cmd.parameters.add("p8");         sqlparameter p9 = new sqlparameter("@email", sqldbtype.varchar);         p9.value = textbox5.text;         cmd.parameters.add("9");         sqlparameter p10 = new sqlparameter("@course", sqldbtype.varchar);         p10.value = combobox5.text;         cmd.parameters.add("p10");         sqlparameter p11 = new sqlparameter("@contact number", sqldbtype.varchar);         p11.value = textbox6.text;         cmd.parameters.add("p11");          cmd.executenonquery();         con.close();

add instance of parameter collection, not string "p11" 

    sqlparameter p11 = new sqlparameter("@contactnumber", sqldbtype.varchar);     p11.value = textbox6.text;     cmd.parameters.add(p11);

and don't need make life difficult spaces in parameter names. 

sqlcommand cmd = con.createcommand(); cmd.commandtext = "insert records ([student id], [first name], [last name], " +                    "[middle initial], gender, address, status, year, email, course, " +                    "[contact number]) values ( @studentid,  @firstname, @lastname, " +                    "@middleinitial, @gender, @address, @status, @year, @email, " +                    "@course, @contactnumber)";  .....  // name parameters without spaces sqlparameter p1 = new sqlparameter("@studentid", sqldbtype.int); p1.value = textbox1.text; cmd.parameters.add(p1); .....

the parameters placeholders inside command text replaced value of parameter same name, no need complicate things adding spaces inside parameter placeholder.


Comments

Post a Comment

Popular posts from this blog

Admob integration with pygame in android -

-
hello curious know solution integrating admob app written in pygame subset android. have tried below things did' t work me :( still nothing working me may there no way :( try 1: followed google https://developers.google.com/mobile-ads-sdk/docs/admob/fundamentals#android solution has no code change build.xml modification didt works me :( try 2: tried below solutio also. http://www.michenux.net/android-admob-tutorial-461.html did't work me :( try 3: tried hack pythonactivity.java. getting below related errors. have googleadmobadssdk-6.4.1.jar in \pgs4a-0.9.4\libs path still below kind of error. below code: protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //vrbilgi setcontentview(r_layout_main); // setcontentview(r.layout.main); // create adview // adview = new adview(this, adsize.banner, my_ad_unit_id); adview = new adview(this, adsize.banner,"a15...
Read more

mod rewrite - Using "?" when rewriting the URL -

-
i have been researching weeks looking how rewritting file/directory complementary "?" or "question mark" what need: http://mydomain.com/demo01.php to like: http://mydomain.com/?theme=jerus theme > simple directory need use websites products(in case themes) jerus > name of theme extra info: i plan on rewritting every url individually refrain wildcard varibles.** wouldn't easy instead of doing url rewriting put php in directory called theme , name index.php? http://mydomain.com/theme/?t=jerus but if you're re-writing urls make rule acutally make route this: http://mydomain.com/theme/jerus/ which waaaay prettier see question: using clean urls in restful api
Read more

installer - what is Hex representation of MSIUSEREALADMINDETECTION? -

-
i need run installer admin , not system needs connect sql server database using windows authentication. based on research, need set msiuserealadmindetection property "1" i figure these installer properties have hex representation shown in blog @ http://blogs.msdn.com/b/astebner/archive/2007/05/28/2958062.aspx var msidbcustomactiontypeinscript = 0x00000400; var msidbcustomactiontypenoimpersonate = 0x00000800 the script set value available here , not give hex representation of msiuserealadmindetection. know hex representation of msiuserealadmindetection? or has better solution editing installer post build? you can find definitions of these kind of identifiers on machine in windows sdk directory. didn't mention vs version, start looking in c:\program files (x86)\microsoft sdks\windows\x.x\include. if have vs2012+ start looking windows kits. msidefs.h file of interest. contains: // properties related uac #define ipropname_msi_uac_deployment_compliant...
Read more