lianzhifeng的专栏

private void button3_Click(object sender, System.EventArgs e) { if(textBox1.Text!="") { p[i,0]=textBox1.Text; p[i,1]=comboBox1.Text; p[i,2]=textBox2.Text; p[i,3]=textBox3.Text; p[i,4]=textBox4.Text; p[i,5]=fname; if(radioButton1.Checked) { p[i,6]=radioButton1.Text; } if(radioButton2.Checked) { p[i,6]=radioButton2.Text; } if(radioButton3.Checked) { p[i,6]=radioButton3.Text; } if(radioButton4.Checked) { p[i,6]=radioButton4.Text; } if(i==0) listBox1.Items.Add(textBox1.Text); if(i>0) { for(int j=0;j<i;j++) { if(p[i,0]==p[j,0]) { MessageBox.Show("通讯录里已有一个同名的联系人，不能插入同名联系人"); for(int m=0;m<7;m++) { p[i,m]=""; } i--; num--; break; } else { if(j==i-1) { listBox1.Items.Add(textBox1.Text); } } } } textBox1.Text=""; textBox2.Text=""; textBox3.Text=""; textBox4.Text=""; comboBox1.Text=""; radioButton1.Checked=false; radioButton2.Checked=false; radioButton3.Checked=false; radioButton4.Checked=false; pictureBox1.Image=null; fname=""; i++; num++; } else { MessageBox.Show("名字不能为空"); } }

#region SQL数据库备份 /// <summary> /// SQL数据库备份 /// </summary> /// <param name="ServerIP">SQL服务器IP或(Localhost)</param> /// <param name="LoginName">数据库登录名</param> /// <param name="LoginPass">数据库登录密码</param> /// <param name="DBName">数据库名</param> /// <param name="BackPath">备份到的路径</param> public static void SQLBACK(string ServerIP,string LoginName,string LoginPass,string DBName,string BackPath) { SQLDMO.Backup oBackup = new SQLDMO.BackupClass(); SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass(); try { oSQLServer.LoginSecure = false; oSQLServer.Connect(ServerIP, LoginName, LoginPass); oBackup.Database = DBName; oBackup.Files = BackPath; oBackup.BackupSetName = DBName; oBackup.BackupSetDescription = "数据库备份"; oBackup.Initialize = true; oBackup.SQLBackup(oSQLServer); } catch (Exception e) { throw new Exception(e.ToString()); } finally { oSQLServer.DisConnect(); } }