//查询 private void button2_Click(object sender, EventArgs e) { 注册 a1 = new 注册(); if (a1.check_textbox(textBox1, textBox2)) { try { string mystr = string.Format("select * from {0}", textBox2.Text.Trim()); string lian_jie = string.Format("server=localhost;port=3306;database={0};user={1};password={2};charset=utf8;", textBox1.Text.Trim(), mysql账号密码.use, mysql账号密码.password); DataSet myds = new DataSet(); MySqlConnection conn = new MySqlConnection(lian_jie); conn.Open(); if (conn.State == ConnectionState.Open) { MySqlDataAdapter myad = new MySqlDataAdapter(mystr, conn); myad.Fill(myds, textBox2.Text.Trim()); dataGridView1.DataSource = myds.Tables[textBox2.Text.Trim()]; } else { MessageBox.Show("连接失败", "提示", MessageBoxButtons.OK); } } catch (Exception err) { MessageBox.Show("错误为:" + err.Message, "提示", MessageBoxButtons.OK); } } }
private void button1_Click(object sender, EventArgs e) { 注册 aa = new 注册(); try { if (aa.check_textbox(textBox1, textBox2)) { use = textBox1.Text.Trim(); password = textBox2.Text.Trim(); string conn = string.Format("server=localhost;port=3306;database=text_database;user={0};password={1};charset=utf8;", use, password); MySqlConnection lianjie_state = new MySqlConnection(conn); lianjie_state.Open(); if (lianjie_state.State == ConnectionState.Open) { label3.Text = "数据库连接成功"; } else { label3.Text = "数据库连接失败!"; } } } catch (Exception arr) { label3.Text = "数据库连接失败!"; MessageBox.Show("错误:" + arr.Message); } }