[code=csharp]
// 1.在项目中引用SQLDMO.DLL文件。
// 2.在引用中的SQLDMO.DLL文件右击->属性->[嵌入互操作类型]为flash
public static void DBBackup(string serverName, string userName, string password, string dataBaseName, string backPath)
{
SQLDMO.Backup dbBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer sqlServer = new SQLDMO.SQLServerClass();
try
{
if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password))
{
sqlServer.LoginSecure = true;
sqlServer.Connect(serverName, null, null);
}
else
{
sqlServer.LoginSecure = false;
sqlServer.Connect(serverName, userName, password);
}
dbBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
dbBackup.Database = dataBaseName;
dbBackup.Files = backPath;
dbBackup.BackupSetName = "没用";
dbBackup.BackupSetDescription = "没用";
dbBackup.Initialize = true;
dbBackup.SQLBackup(sqlServer);
}
catch
{
throw;
}
finally
{
sqlServer.DisConnect();
}
}
private static void DBReply(string serverName, string userName, string password, string dataBaseName, string backPath)
{
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password))
{
svr.LoginSecure = true;//平江县房产网http://www.pingjiangxian.com
svr.Connect(serverName, null, null);
}
else
{
svr.LoginSecure = false;
svr.Connect(serverName, userName, password);
}
SQLDMO.QueryResults qr = svr.EnumProcesses(-1);
int iColPIDNum = -1;
int iColDbName = -1;
for (int i = 1; i <= qr.Columns; i++)
{
string strName = qr.get_ColumnName(i);
if (strName.ToUpper().Trim() == "SPID")
{
iColPIDNum = i;
}
else if (strName.ToUpper().Trim() == "DBNAME")
{
iColDbName = i;
}
if (iColPIDNum != -1 && iColDbName != -1)
break;
}
for (int i = 1; i <= qr.Rows; i++)
{
int lPID = qr.GetColumnLong(i, iColPIDNum);
string strDBName = qr.GetColumnString(i, iColDbName);//湖南墙体广告http://www.csxzgg.com
if (strDBName.ToUpper() == dataBaseName.ToUpper())
svr.KillProcess(lPID);
}
SQLDMO.Restore res = new SQLDMO.RestoreClass();
res.Action = 0;
//SQLDMO.RestoreSink_PercentCompleteEventHandler pceh = new SQLDMO.RestoreSink_PercentCompleteEventHandler(Step);
//res.PercentComplete += pceh;
res.Files = backPath;
res.Database = dataBaseName;
res.ReplaceDatabase = true;
res.SQLRestore(svr);//湖南墙体导航http://www.QiangTiGuangGao.cn
}
catch (Exception err)
{
throw (new Exception(err.Message));
}
finally
{
svr.DisConnect();//大口段http://www.dakouduan.com
}
}
[/code]
[url=http://www.csxzgg.com]湖南墙体广告[/url]www.csxzgg.com
[url=http://www.QiangTiGuangGao.cn]湖南墙体导航[/url]www.QiangTiGuangGao.cn
[url=http://www.dakouduan.com]大口段[/url]www.dakouduan.com
[url=http://www.pingjiangxian.com]平江县房产网[/url]www.pingjiangxian.com
嘻嘻。。楼主换编辑器了。都快2012了。。
还用什么：eWebEditor。赶快的kindeditor
Re:DataGridView的一些技巧 wtq 2011-07-25 16:32
你好，你这边有一个例子，如下
16、新行指定默认值
Specify Default Values for New Rows in the Windows Forms DataGridView Control
Sample：
private void dataGridView1_DefaultValuesNeeded(object sender, System.Windows.Forms.DataGridViewRowEventArgs e)
{
e.Row.Cells["Region"].Value = "WA";
e.Row.Cells["City"].Value = "Redmond";
e.Row.Cells["PostalCode"].Value = "98052-6399";
e.Row.Cells["Region"].Value = "NA";
e.Row.Cells["Country"].Value = "USA";
e.Row.Cells["CustomerID"].Value = NewCustomerId();
}
当新增加一行数据时，会调用这个方法，可我新增一行数据时，不会执行这边的函数。 。我的代码如下：
bList.Insert(intTypeThreeIndex+1,new Person("","","",3,23));
并不会执行刚才的事件。
ALTER TABLE distributors ADD COLUMN address varchar(30);
sql 2000 表示无法执行
删了吧，别在误导大家了
ALTER TABLE distributors RENAME COLUMN address TO city;
sql 2005 根本就不支持
re: 代码实现DataList控件的分页显示 nihao110 2009-04-08 16:09
为什么在第一页那些记录都会出来呢？datalist 和 翻页功能脱节。
re: 使用正则表达式Replace 大民122 2009-04-08 13:50
我的这个是替换div的你看一下是否有帮助
private static string Get_PageText(string text)
{
if (text.IndexOf("
([\s\S]*?)", "$1", RegexOptions.IgnoreCase);
text = Get_PageText(text);
}
else
{
text = text;
}
return text;
}
}
管理