Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃ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>
    


Ïà¹ØÎĵµ£º

ɾ³ýSQLServer²éѯ·ÖÎöÆ÷ÖеÄÁ¬½Ó¼Ç¼

SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ­¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀï¶¼»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Micr ......

asp.net Êý¾Ý¿â²Ù×÷

ASP.NET²Ù×÷Êý¾Ý¿â
ͨ¹ý¶ÔADO.NETµÄ»ù±¾½²½â£¬ÒÔ¼°½²½âÁËһЩÊý¾ÝÔ´¿Ø¼þµÄ»ù±¾Ó÷¨ºó£¬±¾Õ½«½éÉÜһЩASP.NET²Ù×÷Êý¾Ý¿âµÄ¸ß¼¶Ó÷¨£¬°üÀ¨Ê¹ÓÃSQLHelper£¬ÒÔ¼°Êý¾ÝÔ´¿Ø¼þ¶ÔÊý¾ÝµÄ²Ù×÷¡£±¾ÕÂÊǶÔÇ°ÃæµÄÊý¾Ý¿â֪ʶµÄÒ»ÖÖ²¹³äºÍÌáÉý¡£
9.1  ʹÓÃADO.NET²Ù×÷Êý¾Ý¿â
ÉÏÒ»ÕÂÖнéÉÜÁËADO.NETµÄ»ù±¾¸ÅÄî¡¢ADO.NETµÄ¶ÔÏó£¬ÒÔ¼ ......

asp.net ͼƬ »­Ïß

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 ......

asp.net Éú³ÉÑéÖ¤ÂëÁ½¸öÀý×Ó

#region 1
private void CreateCheckCodeImage()
{
//»ñÈ¡Ëæ¼´×Ö·û´®
int number;
char code;
string checkCode = String.Empty;
System.Random random1 = new Random();
for (int i = 0; i < 5; i++)
{
number = random1.Next( ......

ASP.NET MVC¼°IIS6.0ÅäÖÃ×ܽá

1. config½á¹¹
     Framework\Config\Machine.config, ΪËùÓÐconfigµÄ¸ù£¬ÌرðÖ»ÓÐËü²ÅÄܾßÓÐ<processMode>½Ú£¬¸Ã½ÚÐ޸ĺó±ØÐëÖØÆôIIS·½ÄÜÉúЧ£¬¶øÆäËü½ÚµÄ¸Ä¶¯£¬Ö»ÒªÒ»±£´æ£¬¾ÍÓÐЧÁË£¬ÕâÊÇIIS6µÄÒ»´ó½ø²½¡£
    ÒÔÏ·ֱðÊÇ´ÓÉÏÍùÏµļ¸¸ö¼Ò×åÀࣨΪ¼Ì³Ð¹ØÏµ£¬ÕâÖÖÉè¼Æ¿ÉÒÔ´ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ