【c# mysql】第一次使用c#对mysql进行操作的心得 花了2个多小时，终于成功的使用c#完成对mysql的操作，查询、修改和删除，不知道是该高兴呢，还是悲伤呢（竟然花了2个小时），总之还是有必要写下一点经验，防止以后再走同样的弯路： sql语句的式非常重要，比
【c# mysql】第一次使用c#对mysql进行操作的心得
花了2个多小时，终于成功的使用c#完成对mysql的操作，查询、修改和删除，不知道是该高兴呢，还是悲伤呢（竟然花了2个小时），总之还是有必要写下一点经验，防止以后再走同样的弯路：
sql语句的格式非常重要，比如table名应使用`table`符号，不是普通的单引号，如果不清楚如何敲出，建议使用mysql图形化工具（如phpmyadmin）自动生成，然后拷贝，eg: string sql = "select * from `365232` where `pics id` like 'a.4.1-1/1'"; "insert
into `picsdic`.`365232` (`pics id` ,`pics description` ,`ref.` ,`release` ,`mnemonic` ,`comments`)values ('a.1/2', 'test', 'test', 'test', 'test', 'test');" string sqldelete = "delete
from `picsdic`.`365232` where `365232`.`pics id` = 'a.1/3'";
不用盲目在internet上导出搜索，先认真看下官方的文档，很多时候internet上都是翻译官方文档，而且不是很全面
msdn和connectornet.chm帮了不少忙，至少比internet上的资料靠谱多了
using system;
using system.data;
using system.configuration;
using system.collections;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.web.ui.htmlcontrols;
using mysql.data.mysqlclient;
namespace mysqlconnection
{
public partial class _default : system.web.ui.page
{
protected void page_load(object sender, eventargs e)
{
string connstr = "server=127.1.1.1;user=root;database=picsdic;port=3306;password=hongxing;";
mysqlconnection conn = new mysqlconnection(connstr);
try
{
//console.writeline("connecting to mysql...");
label1.text = "connecting to mysql...";
conn.open();
// perform database operations
//query
string sql = "select * from `365232` where `pics id` like 'a.4.1-1/1'";
mysqlcommand cmd = new mysqlcommand(sql, conn);
mysqldatareader rdr = cmd.executereader();
while (rdr.read())
{
txt1.text = rdr[0] + " -- " + rdr[1];
}
rdr.close();
//insert
string sqlinsert = "insert into `picsdic`.`365232` (`pics id` ,`pics description` ,`ref.` ,`release` ,`mnemonic` ,`comments`)values ('a.1/3', 'test', 'test', 'test', 'test', 'test');";
mysqlcommand cmdinsert = new mysqlcommand(sqlinsert, conn);
cmdinsert.executenonquery();
//delete
//string sqldelete = "delete from `picsdic`.`365232` where `365232`.`pics id` = 'a.1/2' and `365232`.`pics description` = 'test' and `365232`.`ref.` = 'test' and `365232`.`release` = 'test' and `365232`.`mnemonic` = 'test' and `365232`.`comments` = 'test' limit 1";
string sqldelete = "delete from `picsdic`.`365232` where `365232`.`pics id` = 'a.1/3'";
mysqlcommand cmddelete = new mysqlcommand(sqldelete, conn);
cmddelete.executenonquery();
}.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}
【说明】：
本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！