private void button1_Click(object sender, System.EventArgs e) { try { if (this.m_strCon == "") { MessageBox.Show("请先测试连接!"); return; } SqlConnection sCon = new SqlConnection(this.m_strCon); sCon.Open(); SqlCommand sCmd = new SqlCommand(); sCmd.Connection = sCon; sCmd.CommandText = "use master"; sCmd.ExecuteNonQuery(); string strSql = String.Format("select count(*) from sysdatabases where name='{0}'", "dbBengZhan"); sCmd.CommandText = strSql; string strCount = sCmd.ExecuteScalar().ToString(); if (strCount != "0") { MessageBox.Show("数据库已存在,请先进入系统再进行备份还原!"); return; } frmBackRestoreDB frmBackResDB = new frmBackRestoreDB(); frmBackResDB.m_bIni = true; frmBackResDB.m_bRestore = true; frmBackResDB.ShowDialog(); sCon.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button1_Click(object sender, System.EventArgs e) { try { if(this.m_strCon=="") { MessageBox.Show("���Ȳ������ӣ�"); return; } SqlConnection sCon=new SqlConnection(this.m_strCon); sCon.Open(); SqlCommand sCmd=new SqlCommand(); sCmd.Connection=sCon; sCmd.CommandText="use master"; sCmd.ExecuteNonQuery(); string strSql=String.Format("select count(*) from sysdatabases where name='{0}'","dbBengZhan"); sCmd.CommandText=strSql; string strCount=sCmd.ExecuteScalar().ToString(); if(strCount!="0") { MessageBox.Show("���ݿ��Ѵ��ڣ����Ƚ���ϵͳ�ٽ��б��ݻ�ԭ��"); return; } frmBackRestoreDB frmBackResDB=new frmBackRestoreDB(); frmBackResDB.m_bIni=true; frmBackResDB.m_bRestore=true; frmBackResDB.ShowDialog(); sCon.Close(); } catch(Exception ex) { MessageBox.Show(ex.ToString()); } }