C#ʹÓÃSQLDMOʵÏÖ¶ÔMSSQLÊý¾Ý¿â½øÐб¸·ÝºÍ»Ö¸´
public sealed class DbOper
{
///<summary>
/// DbOperÀàµÄ¹¹Ô캯Êý
///</summary>
private DbOper()
{
}
///<summary>
/// Êý¾Ý¿â±¸·Ý
///</summary>
public static void DbBackup()
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "1234");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "Northwind";
oBackup.Files = @"d:\Northwind.bak";
oBackup.BackupSetName = "Northwind";
oBackup.BackupSetDescription = "Êý¾Ý¿â±¸·Ý";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
&nbs
Ïà¹ØÎĵµ£º
´æ´¢¹ý³ÌPagination£º
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Pagination]
@tblName varchar(255), -- ±íÃû
@PKName varchar(255), -- ×Ö¶ÎÃû
@strGotFields varchar(1000) = '*' , --²éѯ×Ö¶ÎÃû
@PageSize int = 10, -- Ò³³ß´ç
@PageIndex int = 1, -- Ò³Âë
@OrderType bi ......
Ribbon ÔÀ´³öÏÖÔÚ Microsoft Office 2007 µÄ Word¡¢Excel ºÍ Powerpoint 組¼þÖУ¬ºóÀ´Ò²±»ÔËÓõ½ Windows 7 µÄһЩ¸½¼Ó×é¼þµÈÆäËüÈí¼þÖУ¬Èç»Í¼ºÍд×Ö°å¡£ËüÊÇÒ»¸öÊÕ²ØÁËÃüÁî°´Å¥ºÍͼ±êµÄÃæ°å¡£Ëü°ÑÃüÁî×éÖ¯³ÉÒ»×é"±êÇ©"£¬Ã¿Ò»×é°üº¬ÁËÏà¹ØµÄÃüÁÿһ¸öÓ¦ÓóÌÐò¶¼ÓÐÒ»¸ö²»Í¬µÄ±êÇ©×飬չʾÁ˳ÌÐòËùÌṩ ......
C#ÐòÁл¯xml
¹Ø¼ü²½Ö裺
XmlSerializer xSerializer = new XmlSerializer(typeof(MyObj));
StringWriter sWriter = new StringWriter(CultureInfo.InvariantCulture);
XmlTextWriter xTextWriter = new XmlTextWriter(sWriter);
......
/// <summary>
/// ´´½¨Êý¾Ý¿â¡£
/// </summary>
/// <param name="srvName">±íÊ ......