//测试连接
呵呵,刚用Sqldmo组件编程实现对sql2000数据库的备份
private void btnTestConn_Click(object sender, EventArgs e)
{
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
_ServerName = this.txtServerName.Text.Trim();
_UserName = this.txtUserName.Text.Trim();
_Password = this.txtPwd.Text.Trim();
oSQLServer.Connect(_ServerName, _UserName, _Password);
MessageBox.Show("连接成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
IsConn = true;
btnCreateDb.Enabled = true;
}
catch
{
btnCreateDb.Enabled = false;
MessageBox.Show("连接失败,请检查网络配制!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
finally
{
oSQLServer.DisConnect();
}
}
呵呵,刚用Sqldmo组件编程实现对sql2000数据库的备份
private void btnTestConn_Click(object sender, EventArgs e)
{
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
_ServerName = this.txtServerName.Text.Trim();
_UserName = this.txtUserName.Text.Trim();
_Password = this.txtPwd.Text.Trim();
oSQLServer.Connect(_ServerName, _UserName, _Password);
MessageBox.Show("连接成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
IsConn = true;
btnCreateDb.Enabled = true;
}
catch
{
btnCreateDb.Enabled = false;
MessageBox.Show("连接失败,请检查网络配制!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
finally
{
oSQLServer.DisConnect();
}
}
解决方案 »
- Winform中Form1窗体调用Form2窗体中的ListBox控件。
- 如何用 C#做语音识别系统?
- 求c#实现堆排序的代码
- C#如何获取系统服务的开启状态,高手进
- 有没有可能通过代码得到数据库字段的长度之类的信息
- JAVA代码转为c#,java原来用到的类库,在c#中怎么调用?
- C#动态绘图,频率较快,如何减弱绘图区的闪动?
- 如何将word中的表格复制到另外一个word文件中
- crystal report中创建的报表宽度是否可以拉的更大?我试了,不行压?
- XAML在X64下不能显示自定义控件,在anycpu下正常
- 如何取datatime类型记录的一部分
- 在C#.NET中的DataGrid如何取得选中行的记录并记录中的每个字段内容啊
private void btnBack_Click(object sender, EventArgs e)
{
if (dgvDb.SelectedRows.Count <=0)
{
MessageBox.Show("请选择要备份的数据库!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
} folderBrowserDialog.Description = "请选择备份位置";
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
string strDbName=dgvDb.SelectedRows[0].Cells["DbName"].Value.ToString();
string strFileName ="["+folderBrowserDialog.SelectedPath + "\\" + strDbName+".bak"+"]";
// MessageBox.Show(strFileName);
pBarBackUp.Visible = true;
pBarBackUp.Value = 1;
if (BackUPDB(strDbName, strFileName, pBarBackUp))
{
MessageBox.Show("数据库备份成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
} }
public bool BackUPDB(string strDbName, string strFileName, ProgressBar pgbMain)
{
ProgressBar PBar = pgbMain;
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
svr.Connect(_ServerName, _UserName, _Password);
SQLDMO.Backup bak = new SQLDMO.BackupClass();
bak.Action = 0;
bak.Initialize = true;
SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(StepBackUp);
bak.PercentComplete += pceh;
bak.Files = strFileName.Trim();
bak.Database = strDbName;
bak.SQLBackup(svr);
return true;
}
catch (Exception err)
{
MessageBox.Show("备份数据库失败" + err.Message);
//throw (new Exception(err.Message));
return false;
}
finally
{
svr.DisConnect();
pBarBackUp.Visible = false;
}
} //进度
private void StepBackUp(string message, int percent)
{
pBarBackUp.Value = percent;
}
processbar+button+openfiledialog?
还有别的吗?