ÓÃasp.net»¹ÔÓë»Ö¸´sqlserverÊý¾Ý¿â
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬
È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌâ×î´óÁË£¬ÓбðµÄÓû§Ê¹ÓÃÊý¾Ý¿âµÄʱºòÎÞ·¨»¹Ô£¬½â¾ö°ì·¨¾ÍÊÇÔÚMASTERÊý¾Ý¿âÖÐ
Ìí¼ÓÒ»¸ö´æ´¢¹ý³Ì£º
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500)
declare @spid int
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status<>-1
begin
exec('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
end
GO
ÔÚ»¹Ô֮ǰÏÈÖ´ÐÐÕâ¸ö´æ´¢¹ý³Ì£¬ÐèÒª´«µÝdbname£¬¾ÍÊÇÄãµÄÊý¾Ý¿âµÄÃû×Ö¡£Ï±ßÊÇÀàµÄÔ´úÂ룺£¨web.configÀïµÄÊý
¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇconstr£©
using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace web.base_class
{
/// <summary>
/// DbOperÀà,Ö÷ÒªÓ¦ÓÃSQLDMOʵÏÖ¶ÔMicrosoft SQL ServerÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´
/// </summary>
public class DbOper
{
private string server;
private string uid;
private string pwd;
private string database;
private string conn;
/// <summary>
/// DbOperÀàµÄ¹¹Ô캯Êý
/// </summary>
 
Ïà¹ØÎĵµ£º
INSERT´¥·¢Æ÷
INSERT¼°UPDATE´¥·¢Æ÷¾³£ÓÃÓÚ¼ì²â´¥·¢Æ÷Ëù¼à¿Ø±íµÄÁм°ÆäÊý¾ÝÊÇ·ñ·ûºÏËù¶¨ÒåµÄ¹æÔò¡£ËüÃÇ¿ÉÒÔÔÚÊý¾ÝÊäÈë±í֮ǰ£¬¶ÔÆä½øÐÐÔÚ¶¨ÒåÒýÓÃÍêÕûÐÔʱÎÞ·¨Íê³ÉµÄÔ¼Êø¼ìÑé¡£
ÏÂÃæÒÔѧÉúÊý¾Ý¿âstudentΪÀýÀ´½éÉÜINSERT´¥·¢Æ÷µÄʹÓ᣸ÃÊý¾Ý¿â°üÀ¨Èý¸ö±í£¬·Ö±ðÊÇÃèÊöѧÉúÇ ......
ÕÒµ½Ò»±é½²½âÈý²ã½á¹¹±È½ÏÇå³þÒ×¶®µÄÎÄÕ£¬ÒýÓÃһϣ¬ÁôΪѧϰ¡£
Èý²ãʽ¿ª·¢ÖеIJã´Î»®·ÖÌÖÂÛ
ÏȾÙÒ»¸öÔø¾ÔÚÄı¾ÊéÉÏ¿´µ½µÄÀý×Ó£ºÏÖÔÚÄãÏëÔÚ1Ã׿íµÄСϪÉϽ¨Ò»×ùÇÅ£¬Äã»áÔÚÉÏÃæ·Å¿éľ°å¾ÍÍêÁË¡£Èç¹ûÏëÔÚ¿íÒ»µãµÄСºÓÉϽ¨ÕâÇÅ£¬Äã¾ÍÐèÒª¼ÆËãľ²ÄÓÃÁÏ£¬¼Û¸ñµÈ£¬Èç¹ûÐèÒª±ðÈ˰ïæ£¬Ä㻹Ҫ¶àһЩͼֽʲôµÄÈñðÈËÀí½âÄãµÄÏë ......
Bitmap srcImg = new Bitmap(300, 300); //Ò²¿ÉÒÔ¶ÁÈëÒ»ÕÅͼƬ
Graphics graphics = Graphics.fromImage(srcImg);
Font font = new Font("ËÎÌå", 16); //×ÖÌåÓë´óС
Brush brush = new SolidBrush(Color.Red);
graphics.DrawString("www.cftea.com", font, brush, 50, 50); //д×Ö£¬×îºóÁ½¸ö²ÎÊý±íʾλÖÃ
Pen pen = ne ......
1. config½á¹¹
Framework\Config\Machine.config, ΪËùÓÐconfigµÄ¸ù£¬ÌرðÖ»ÓÐËü²ÅÄܾßÓÐ<processMode>½Ú£¬¸Ã½ÚÐ޸ĺó±ØÐëÖØÆôIIS·½ÄÜÉúЧ£¬¶øÆäËü½ÚµÄ¸Ä¶¯£¬Ö»ÒªÒ»±£´æ£¬¾ÍÓÐЧÁË£¬ÕâÊÇIIS6µÄÒ»´ó½ø²½¡£
ÒÔÏ·ֱðÊÇ´ÓÉÏÍùÏµļ¸¸ö¼Ò×åÀࣨΪ¼Ì³Ð¹ØÏµ£¬ÕâÖÖÉè¼Æ¿ÉÒÔ´ó ......
ÏÖÔÚÖ÷Á÷µÄÍøÕ¾¿ª·¢ÓïÑÔÎÞÍâºõasp¡¢php¡¢asp.net¡¢jspµÈ¡£
ÍøÒ³´Ó¿ªÊ¼¼òµ¥µÄhmtlµ½¸´ÔӵķþÎñÓïÑÔ£¬×ß¹ýÁË10¶à¸öÄêÍ·£¬¸÷ÖÖ¼¼Êõ²ã³ö²»Çµ¥¸öµÄÖ÷Á÷¼¼ÊõÒ²ÔÚ²»¶Ï·Ðµİ汾£¬ÏÖÔÚ·ÖÎöϸ÷ÖÖÓïÑÔµÄÇø±ð¡¢ÓÅÊÆ¡¢ÁÓÊÆ¡¢¿ª·¢×¢ÒâÊÂÏ
HTML:µ±È»ÕâÊÇÍøÒ³×î»ù±¾µÄÓïÑÔ,ÿһ¸ö·þÎñÆ÷ÓïÑÔ¶¼ÐèÒªËüµÄÖ§³Ö,Ҫѧϰ,Õâ¸ö¿Ï¶¨ÊÇ¿ªÊ¼ ......