c#資料庫建立 mysql,C#如何建立資料庫

C# codeprivate void createdata(string sql, string servername, string database,string user, string pwd)

{

string connStr = string.Format("data source=" + servername + ";database="+database+";uid=" + user + ";pwd=" + pwd + "");

SqlConnection conn = new SqlConnection(connStr);

SqlCommand cmd = new SqlCommand(sql, conn);

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

private void button1_Click(object sender, EventArgs e)

{

if (this.textBox2.Text == "")

{

MessageBox.Show("請輸入使用者名");

this.textBox2.Focus();

}

else

{

this.openFileDialog1.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*";

this.openFileDialog1.ShowDialog();

if (this.openFileDialog1.FileName.ToString() == "")

{

MessageBox.Show("未選擇腳本檔案");

}

else

{

StringBuilder sqlblr = new StringBuilder();

sqlblr.Append(File.ReadAllText(this.openFileDialog1.FileName.ToString(), System.Text.Encoding.GetEncoding("GB2312")));

}

try

{

createdata(sqlblr.ToString(), this.comboBox1.SelectedItem.ToString(), "master",this.textBox2.Text, this.textBox1.Text);

this.openFileDialog1.Reset();

MessageBox.Show("建立資料庫成功");

}

catch (Exception E)

{

MessageBox.Show(E.Message);

}

}

}

}

}