sql - How to pass multiple command in one query? -



sql - How to pass multiple command in one query? -

hi how can write code below more simply? ... 2 sql(oledb) command in 1 query.

con.open(); cmd.commandtext = "delete * customers id_c = 1"; cmd.executenonquery(); cmd.clone(); cmd.commandtext = "delete * books id_b = 1"; cmd.executenonquery(); cmd.clone(); con.close();

provided don't need number of rows affected (returned executenonquery) can set both commands in same sql separated ";"

con.open(); cmd.commandtext = "delete * customers id_c = 1; delete * books id_b = 1"; cmd.executenonquery(); con.close();

sql wpf

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

php - Working with pretty urls on apache and fastcgi after hhvm installation -

php - Working with pretty urls on apache and fastcgi after hhvm installation - i needed slim php work pretty urls using .htaccess , no problem. rewriteengine on rewritecond %{request_filename} !-f rewriterule ^ index.php [qsa,l] now ran using hhvm, fastcgi using virtual host config. <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"> allowoverride order allow,deny allow </directory> </virtualhost> of course, won't read .htaccess file, thought of adding .htaccess config in virtual host config, no, won't work. like so: <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"...
Read more