日期:2014-05-17 浏览次数:20907 次
/// MySql常量
private static string SERVERIP = "192.168.1.100"; //服务器IP,如果是在本机架设的数据库就用127.0.0.1
private static string DATABASE = "haoma"; //数据库名,建立的数据库名就是haoma
private static string USERNAME = "root"; //用户名,默认为root
private static string PASSWORD = ""; //密码,默认为空
private static string CHARSET = "utf8"; //编码方式
public static string HMSTRING; //连接mysql语句
private MySqlConnection HaomaConnection; //连接数据库
private MySqlCommand HaomaCommand; //数据库语句
private void Btn_Server_Click(object sender, RoutedEventArgs e)
{
HMSTRING = "Server=" + SERVERIP + ";Database=" + DATABASE + ";Uid=" + USERNAME + ";Pwd=" + PASSWORD + ";Charset=" + CHARSET + ";";//数据库连接语句
try
{
HaomaConnection = new MySqlConnection(HMSTRING);//连接实例
HaomaConnection.Open();
HaomaCommand = HaomaConnection.CreateCommand();//数据库命令
HaomaCommand.CommandText = "SELECT * FROM table;";//查询表table所有数据,其他功能参考sql语句用法
&