非常方便的免费在线mysql数据库,感谢sqlPub社区(https://www.sqlpub.com/#/) ,需要做测试朋友可以免费申请。。
用C#实现连接数据库,执行简单的查询,插入,删除功能
string query = "select * from orderForm";
string del = "delete from orderForm where orderName=\"zhangjiayan\"";
string ins = "insert into orderForm(orderId,orderName,orderCount) values ( 8888 , \"zhangxinlei\",5)";
MySqlConnection conn = new MySqlConnection("Server=mysql.sqlpub.com;port=3306;Database=zhenmeijiangyue;user=mingyou123;Pwd=c5a480dd27215f1b");
conn.Open();
MySqlCommand cmd = new MySqlCommand(ins, conn);
var ii=cmd.ExecuteNonQuery();
MessageBox.Show(ii.ToString());