//查询
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);
}
}
