Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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;
  


Ïà¹ØÎĵµ£º

asp.net Ò³ÃæÌí¼ÓFlash

        <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="100%" height="100%">
    <param name="movie" value="<%= ResolveUr ......

Asp.net URLÖض¨Ïòºócss·¾¶ÎÊÌâ


Èç¹ûÄã²»×ÜÊÇÓà Windows

É쵀 Internet
Explorer
À´ÉÏÍøµÄ»°£¬Äã¿ÉÄÜ»á×¢Òâµ½£¬Ðí¶àÍøÕ¾ÉϵÄÊÓƵµã²¥Ö®ÀàµÄ¶àýÌåÄÚÈÝ£¬ÄãÎÞ·¨Ö±½ÓÔÚ Internet Explorer
ÒÔÍâµÄÆäËüä¯ÀÀÆ÷Öйۿ´£¬±ÈÈçÃ÷Ã÷ÒѾ­°²×°
Á˲å¼þÈ´ÌáʾȱÉÙ²å¼þ£¬»òÕßʲô¶¼²»Ìáʾ³öÏֿյĿò¿ò£¬»òÕßÏÔ
ʾÁ˲¥·ÅÆ÷²å¼þȴʼÖÕÁ¬²»ÉÏ´ò²»¿ªÖ®ÀàµÄÎÊÌ⣠......

ASP.NETÍøÕ¾¿ª·¢Öг£Óõ½µÄ¹ã¸æЧ¹û´úÂë

ÔÚASP.NETÏîÄ¿¿ª·¢ÖÐ,»á±»ÒªÇóÌí¼Ó¹ã¸æ,Óз­ÆÁЧ¹û¡¢Óйã¸æÂÖÁ÷ÏÔʾ¡¢Æ®¸¡¹ã¸æ¡¢×ó²à¹ã¸æ¡¢ÓÒ²à¹ã¸æµÈ¡£Óñ¾Ìù³ÖÐø¼Ç¼һЩÊÕ¼¯µÄ¹ã¸æЧ¹û¡£Ï£Íû¸øÓÐÐèÇóµÄÅóÓÑÃÇһЩ֧³Ö¡£Ò²Ï£ÍûÅóÓÑÃÇ°ÑÎÒδ¼Ç¼µÄ¹ã¸æÐÎʽҲ¸øÓèÒ»Æð»ØÌù¡£Ê¹±¾Ìù¸ü¼ÓµÄÍêÉÆ£¬Ò²Èøü¶àµÄÅóÓÑÃÇ·ÖÏí¡£
1.·­ÆÁЧ¹û
·­ÆÁЧ¹û
<html>
<head>& ......

Ò»¸öasp.netµÄÉú³ÉÇúÏßͼµÄ¹ý³Ì

ÕâÀïÊÇ´ÓDatasetÀïµÄÊý¾ÝÉú³ÉÇúÏßͼ.
ÎÒµÄDatasetÊÇ´Ó±íSendrecÀï¶ÁÈ¡µÄÊý¾Ý,·Ö±ðÓÐId,Sendid(¶©µ¥ºÅ),Sendtime(¼Ç¼ʱ¼ä),Sendnum(µ¥Î»Ê±¼ä·¢ËÍÁ¿/ÎÒÕâÀïÊÇÎå·ÖÖÓ)¼¸¸ö×Ö¶Î
¹ý³ÌÈçÏÂ:
public void draw(Page page,DataSet ds,int Tnum){}
ÆäÖÐpageÊÇÓÃÀ´´«µÝÒýÓÃÕâ¸ö¹ý³ÌµÄÒ³Ãæ,ÕâÑùÈÃÒ³ÃæÊÇJPG·½Ê½Ö±½ÓÏò¿Í»§¶ËÊä³öÉú ......

mysqlÊý¾Ýµ¼³öµ½sqlserver·½·¨

ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ