日期:2014-05-18 浏览次数:21073 次
private 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); } } } } }