c# - How can I create an if else statement with this situatiion? -

-

i want command if enter nothing or null value not execute insert command.im using c# , sql server. code this:

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)";           sqlparameter p1 = new sqlparameter("@studentid", sqldbtype.nchar);         p1.value = textbox1.text;         cmd.parameters.add(p1);         sqlparameter p2 = new sqlparameter("@firstname", sqldbtype.nvarchar);         p2.value = textbox2.text;         cmd.parameters.add(p2);         sqlparameter p3 = new sqlparameter("@lastname", sqldbtype.nvarchar);         p3.value = textbox3.text;         cmd.parameters.add(p3);         sqlparameter p4 = new sqlparameter("@middleinitial", 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(p9);         sqlparameter p10 = new sqlparameter("@course", sqldbtype.varchar);         p10.value = combobox5.text;         cmd.parameters.add(p10);         sqlparameter p11 = new sqlparameter("@contactnumber", sqldbtype.varchar);         p11.value = textbox6.text;         cmd.parameters.add(p11);          textbox1.text = "";         textbox2.text = "";         textbox3.text = "";         textbox4.text = "";         textbox5.text = "";         textbox6.text = "";         combobox1.text = "";         combobox2.text = "";         combobox3.text = "";         combobox4.text = "";         combobox5.text = "";         messagebox.show("data inserted!", "information ... ", messageboxbuttons.ok, messageboxicon.information, messageboxdefaultbutton.button1);          cmd.executenonquery();         con.close();

can generate constraint in table, when can try insert null values, , in program can exception.

other alternative make loop , check values in paramaters on cmd.parameters, , if found 1 null, nothing or blank should not send insert database.


Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more