一提起mysql数据库,好像就是在说java,jsp或者php,其实在所有程序中都可以使用mysql 数据库,其它的程序使用my sql数据库的方法是使用my sql 提供的odbc驱动,在.net 中可以使用类似于jdbc似的东东.它的名字是:MySQLDriverCS.dll.把它添加到.net的组件面板里,至于如何添加,则不是本篇的任务了(^_^)!
下面是创建一个数据库链接:
using MySQLDriverCS;
MySQLConnection conn = new MySQLConnection( new MySQLConnectionString("localhost","test","root","").AsString );
conn.Open();
如果你使用的是.net的集成开发环境(visual studio.net)那么在代码中输入MySQLDriverCS后再输入一个”.”就可以看到MySQLDriverCS名称空间中的所有的东西了.
下面是commond:
MySQLCommand cmd;
cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cmd = new MySQLDriverCS.MySQLCommand("CREATE TABLE test.mysqldrivercs_test("+
"SettingID tinyint(3) unsigned NOT NULL auto_increment,"+
"SettingValue text, "+
"PRIMARY KEY (SettingID), UNIQUE KEY SettingID(SettingID), KEY SettingID_2 (SettingID))"+
" TYPE=MyISAM COMMENT='MySQL test table'",conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
下面是insert:
string Value = "Value";
int SettingID = 1;
new MySQLInsertCommand(conn,
new object[,] {{"SettingID",SettingID},{"SettingValue",Value}},
"mysqldrivercs_test"
);
下面是update
Value = "Value2";
new MySQLUpdateCommand(conn,
new object[,] {{"SettingValue",Value}},
"mysqldrivercs_test",
new object[,] {{"SettingID","=",SettingID}},
null
);
下面是select
DataTable dt = new MySQLSelectCommand(conn,
new string[] {"SettingID","SettingValue"},
new string[] {"mysqldrivercs_test"},
new object[,] {{"SettingID","=",SettingID}},
null,
null
).Table;
string storedValue = dt.Rows[0]["SettingValue"].ToString();
下面是delete
new MySQLDeleteCommand(conn,"mysqldrivercs_test",new object[,] {{"SettingID","=",SettingID}},null);
关闭链接:
conn.Close();
怎么样,很方便吧!
209.213.30.* 于 2007-09-07 01:38:16发表:
5a9d283b3746e699f481f9b4e2bf45eb http://emigrazione-italiana-america-xx-secolo.yojewt.org/ http://orologiopolsobussola.yufywt.org/art-198-codice-stradale-commentato/ http://ciclomotori-omologati.odiioj.org/ http://agenziaimmobiliarelavagna.ukcvbo.org/chalet-gabriele-como/ http://affittacamere-pisa.yavpvy.org/ http://sito-di-the-o-c.odiioj.org/ http://valvolare.ufftiy.org/ http://samsung-electronics-italia-spa.vozlau.org/ http://chattare-gratis-yahoo.ufftiy.org/ http://corso-feltro.yojewt.org/ ef5da0821261872f3a177fbd4ce2e9fc
24.44.176.* 于 2007-09-06 08:28:18发表:
2521581a477ab7d73dd9f4f13a4781a3 http://iris.lib.virginia.edu/phpBB2/viewtopic.php?t=7689 http://payson.tulane.edu/techeval/forums/viewtopic.php?t=74 http://transatlantic.ipo.asu.edu/forum/viewtopic.php?t=208 http://www.rstm.edu/phpBB/viewtopic.php?t=1450 http://www.cide.au.edu/audasaforum/viewtopic.php?t=458 http://www.cide.au.edu/audasaforum/viewtopic.php?t=458 http://iris.lib.virginia.edu/phpBB2/viewtopic.php?t=7689 http://transatlantic.ipo.asu.edu/forum/viewtopic.php?t=208 http://www.international.ucf.edu/myphp/community/viewtopic.php?t=124 http://transatlantic.ipo.asu.edu/forum/viewtopic.php?t=208 d950163e2bc04fe30175aa17834ab13d
88.168.144.* 于 2007-09-05 19:42:57发表:
251cedb90da6a900ffc4fdc2a2688f98 http://myweb.msoe.edu/~chaversa/phpBB2/viewtopic.php?t=2012 http://www.mat.ucsb.edu/CUI/viewtopic.php?t=1142 http://myweb.msoe.edu/~chaversa/phpBB2/viewtopic.php?t=2012 http://forum.jalc.edu/phpBB2/viewtopic.php?t=2267 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2657 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2656 http://forum.jalc.edu/phpBB2/viewtopic.php?t=2267 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2656 http://www.mat.ucsb.edu/CUI/viewtopic.php?t=1142 http://www.mat.ucsb.edu/CUI/viewtopic.php?t=1142 db62d9d137e7999ef0c8bbd27991ea41
69.139.71.* 于 2007-09-05 05:15:38发表:
a9dc5c94987eb79ffe6ece788fd610d3 http://cercasi-auto-blindata.dfmviz.info/ http://villa-di-corlo.dfmviz.info/ http://maschera-ferro.dfmviz.info/ http://lettere-scuse.dfmviz.info/ http://agapornis-roseicollis-pezzati.dfmviz.info/ http://matera-immagine-sasso.dfmviz.info/ http://superenalotto-1-04.dfmviz.info/ http://donna-nude-molto-pelose.dfmviz.info/ http://campeggio-elba.dfmviz.info/ http://inizio-vacanza-natale-studente-tutta-italia.dfmviz.info/ 21817dd0dbd87cb119a7471ab31fd121
81.202.131.* 于 2007-08-15 23:42:16发表:
55b800dc860b443bb0918ce551be84bd http://soldato-legionario.ddxsak.com/ http://scarpa-calcio-nike-adidas.flroxk.com/ http://cellula-batterica.flroxk.com/ http://caricatore-cd-originale-lancia-salta.flroxk.com/ http://terrari-iguana.akrmtn.com/ http://assunzione-posta-italiana-sardegna.zpvztz.com/ http://yaooh-giochi.flroxk.com/ http://articolo-154-codice-strada.akrmtn.com/ http://wcf-esposizioni-feline.flroxk.com/ http://cuccioli-campagna.flroxk.com/ f79720dbd018955dfd9068d527cd2031
62.57.58.* 于 2007-07-26 00:31:32发表:
8b2489fc105d845e92d87a327f6bbe2d http://porta-blindate-porta-blindata-modello.cuxojo.biz/ http://coppia-firenze-accompagnatrice-escort.ftgmns.biz/ http://piano-sicurezza-privacy.txcbmz.biz/ http://compravendita-titoli-on-line.cuxojo.biz/ http://impresa-lavoro.smtpld.biz/ http://primo-soccorso-frattura.zqemjp.biz/ http://maria-valentina-boi.smtpld.biz/ http://adesivi-ms.txcbmz.biz/ http://cristallo-terminillo.sfupeh.biz/ http://nitro-scarpone.zqemjp.biz/ f0bd15bc4c04b02533089147dbde4c5b
80.35.194.* 于 2007-07-25 18:24:19发表:
77c397aec56d91a6659a7a77d9a9c296 http://foto-maschio-peloso.gohktw.biz/ http://tutti-modello-motorola-pebl-u6.gohktw.biz/ http://piazza-vittoria-gorizia.gohktw.biz/ http://bilancio-consuntivo-azienda-municipalizzate.gohktw.biz/ http://istruzioni-per-l-uso-rai.gohktw.biz/ http://accordo-di-licenza.pzgvuv.biz/ http://cartoni-animati-della-rai-it.ggjrfj.biz/ http://donna-allo-specchio-di-picasso.mbgzfn.biz/ http://blog-tronista-giorgio-alfieri.ytxxxk.biz/ http://valeria-marini-hard.mbgzfn.biz/ bfdd7bec9230a10317341e982495b689
190.46.130.* 于 2007-07-25 14:17:52发表:
5300f54a38720b91e9b462dbe6b3a535 http://pizzo-coca-ascensione.kajgdw.biz/ http://emorroidi-roma.zibtye.biz/ http://conciliazione-tim.tzlnou.biz/ http://donna-pelo.iuatju.biz/ http://mercato-agroalimentare-cosenza.tzlnou.biz/ http://rona-noleggio-bus.tzlnou.biz/ http://lavoro-tempo-indeterminato.iuatju.biz/ http://adriatica-vacanze.kajgdw.biz/ http://transilvania-bisceglie-2006.iuatju.biz/ http://codice-sblocco-nec-e616-umts.tzlnou.biz/ 69fae163d26a9b1682339a4eb6fc4ad9
200.112.117.* 于 2007-07-24 04:34:03发表:
f3e788bd8f21e0c14c98150104fdfcbb http://fonderie-leghe-leggere.jnbwct.org/ http://accompagnatrice-per-serata.hdpwsk.org/ http://filmato-sesso-donna-italiana-visione-gratuita.jnbwct.org/ http://4-mosca-velluto-grigio.pvaeyo.org/ http://inizio-stagioni.pvaeyo.org/ http://film-porno-guarda-gratis.vywyuh.org/ http://albo-degli-avvocati-di-milano.hdpwsk.org/ http://abitare-confine.gbdrme.org/ http://gdr-tempi-moderni.vywyuh.org/ http://valutazione-tecnica-dei-migliore-aspirapolvere-casa.cqhnnx.org/ eb89aa2351bfb8dd061b0dc25061dcdb
59.24.179.* 于 2007-07-21 12:16:28发表:
b127935107cb9c9876a80eb77ab8656a http://stufaalimentatemais.cerfmd.org/castello-di-pavone/ http://prezzariooperaedileregionemarcheanno.ghoouy.org/orario-volo-orario-volo/ http://materassofalomo.ghoouy.org/fili-elettrici/ http://videoadaltadefinizione.qemqrg.org/affitto-vacanza-san-benedetto-tronto/ http://essolubrificante.nfnzro.org/pulizia-suono-cassetta/ http://funzionedirettoregeneralesrl.cerfmd.org/letto-ortopedico-bari/ http://articolo633cpc.rozdha.org/appartamento-affittare-capodanno-verona/ http://forumdeitifosocesena.kprskz.org/banana-culo/ http://minneapolisspaolocampiello.nfnzro.org/dario-gonzatti/ http://morteabramolincoln.pehabe.org/canzone-instabile-nek/ b8fb7d84153cc5c69600cbe1497734b2
83.36.78.* 于 2007-07-20 03:14:26发表:
5fe66be1a723a72ec294d9821190f2cf http://agenzia-pubblicita-c3-a0-internet.jnesky.in/ http://modulo-verbale-vane-ricerca.iznvge.in/ http://vendita-casa-lidi-ferraresi.kmyeyh.com/ http://cartuccia-vuota.fzhoas.in/ http://testi-jim-morrison.aoknmm.in/ http://vacanza-lusso.vbglda.com/ http://albergo-sole-val.uylqdg.com/ http://testi-di-irene-grandi.jvzulp.in/ http://un-cappuccino-per-un-pc-it.jvzulp.in/ http://usato-occasioni.vbglda.com/ b8a12f78e2ab8d9c8e5e94f78e975725
201.208.247.* 于 2007-07-18 15:48:06发表:
3a65864a0ea6db8794bb2b20b50f9c98 http://cibeleomosessuale.copdkj.org/analisi-serie/ http://indirizziprefettura.vniybd.org/trucco-pc-call-of-duty-2/ http://macchinapastaimperia.cdvduz.org/segnale-ttl/ http://bimbiprimavera.cdvduz.org/liceo-artistico-martini-schio/ http://venditacasacervia.ppnxyq.org/varese-news-cinema/ http://bustafacpagasimile.jpwypc.org/documento-adozione-gatto/ http://comunediagliana.ppnxyq.org/foto-digitale/ http://archiviarticoli.wfdklb.org/accessorio-bar/ http://coccogiuseppe.cdvduz.org/wind-tim-tre/ http://lucamarini.qbmkwd.org/sesso-a-tutto-spiano/ 8ea4fcdde1a965ef95e68187f350c6f6
213.103.25.* 于 2007-07-18 15:39:19发表:
http://6cee84540de1f2938f6d400d5b632574-t.xkktxb.org 6cee84540de1f2938f6d400d5b632574 http://6cee84540de1f2938f6d400d5b632574-b1.xkktxb.org 6cee84540de1f2938f6d400d5b632574 http://6cee84540de1f2938f6d400d5b632574-b3.xkktxb.org 8d1f2bfe3cbc5359328d95464cab8b7c
201.208.189.* 于 2007-07-17 07:13:20发表:
115ef7608db3c309d807a79262dd4936 http://emule-0-46-c-scaricare.xxmndb.biz/ http://bella-patatina.mxkrxs.com/ http://livello-radar.xxmndb.biz/ http://finta-travi-polistirolo.drncar.biz/ http://sexy-incontro-tt.xmjviq.com/ http://suffisso-teca.xxmndb.biz/ http://sms-amore-gia-pronti.jmncsw.biz/ http://didone-coro-pdf.ynpojb.biz/ http://fatebenefratelli-roma-ospedale.xsixxz.biz/ http://mappa-stradale-ticino-ch.gwedas.com/ 8cff813cd5cdf93d908a9e43c4704dad
81.202.96.* 于 2007-07-15 22:10:29发表:
0da48bc45a856a399508f643110632b3 http://palcoallopera.vozulo.org/pulizia-viso-uomo/ http://testdellamorecoloreluscher.havjsk.org/termocamino-combustibile-solidi-granulari/ http://sessoaltel.mongnb.org/camping-village-baia-degli-aranci/ http://scioperobustrieste.kqjhpm.org/articoli-sanitaria/ http://lampadariocartadiriso.mqyawz.org/citizen-orologio-automatico/ http://acquistooro.jlmwbv.org/bat-provincia/ http://sexsidonnabrasiliana.kqjhpm.org/dueemme-antenne/ http://filialemilanossangyong.havjsk.org/orto-roma-san-giovanni/ http://itinerariopuglia.vozulo.org/cuore-carta/ http://catamaranivela.havjsk.org/sistema-copertura-vetrata/ a875aa102e91579b074fe29fa7a13e81
125.134.12.* 于 2007-07-14 15:12:09发表:
a6fa2832a019d08e27f433b165269b0d http://appartamento-stagionali-pila.wxamgv.org/ http://lampedusa-disabile-accesso.aoonyx.org/ http://luciano-pavarotti-testo.aoonyx.org/ http://case-basso-consumo.ubetii.org/ http://progetto-preliminare-ospedale.njylwy.org/ http://mondiali-di-calcio-2006-in-tv.njylwy.org/ http://dvd-r-supporti.tttfhp.org/ http://prevenzione-bulimia-anoressia.mhjqva.org/ http://acquistare-un-portatile.tttfhp.org/ http://trucchi-per-singles-2.aoonyx.org/ 8c2a5fabd273020cebfaea52010ee4bb
189.6.189.* 于 2007-07-13 08:27:47发表:
d667e959f3964f3937af43f24c57c7fd http://confronto-principe-discorso-machiavelli.yorcfb.org/ http://zucca-secche-colorata.rtistm.org/ http://lavoro-estivo-jesolo.qpjnvy.org/ http://telecomando-urc22b.orjndo.org/ http://cucciago-co-it.rtistm.org/ http://ricetta-tuma-al-miele.mtfkmx.org/ http://prodotti-on-line.udzjxi.org/ http://catene-da-neve-trak.orjndo.org/ http://museo-scienza-interattivo-monaco.jdcyvo.org/ http://3.rakzmw.org/prodotti/scheda_sintetica.asp?cod=2+32 d8d97f68bc274489b372d34e17b3a169
211.206.9.* 于 2007-07-06 00:40:42发表:
http://494d72afd34aabf8e6c9804575e3fc3f-t.lwgmrw.org 494d72afd34aabf8e6c9804575e3fc3f http://494d72afd34aabf8e6c9804575e3fc3f-b1.lwgmrw.org 494d72afd34aabf8e6c9804575e3fc3f http://494d72afd34aabf8e6c9804575e3fc3f-b3.lwgmrw.org 7323937625928ec2c2b389a5c949efe8