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

ASP.NETÖеÄÊý¾Ý¿â²Ù×÷Ààsqlhelper¼°·½·¨Ê¹ÓÃÖ¸ÄÏ

ÒªÔÚVS2005ÖÐʹÓÃsqlhelperÀà,±ØÐë°ÑMicrosoft.ApplicationBlocks.Data.dllÒýÓõ½ÏîÄ¿ÖÐ.
1.ͨ¹ý´æ´¢¹ý³Ì²éѯµÄ·½·¨SqlHelper.ExecuteDataset(Êý¾Ý¿âÁ¬½Ó×Ö·û, ´æ´¢¹ý³Ì×Ö·û, ²ÎÊýÊý×é);
2.ͨ¹ý×Ö·û´®²éѯµÄ·½·¨SqlHelper.ExecuteDataset(Êý¾Ý¿âÁ¬½Ó×Ö·û, CommandType.Text , ²éѯ×Ö·û´®,²ÎÊýÊý×é);
3.ͨ¹ý´æ´¢¹ý³Ì²åÈëµÄ·½·¨SqlHelper.ExecuteScalar(Êý¾Ý¿âÁ¬½Ó×Ö·û, ´æ´¢¹ý³Ì×Ö·û, ²ÎÊýÊý×é);
4.ͨ¹ý×Ö·û´®²åÈëµÄ·½·¨SqlHelper.ExecuteScalar(Êý¾Ý¿âÁ¬½Ó×Ö·û, CommandType.Text , ²åÈë¼°Ë¢ÐÂ×Ö·û´®,²ÎÊýÊý×é);
5.ͨ¹ý´æ´¢¹ý³ÌË¢Ðµķ½·¨SqlHelper.ExecuteNonQuery(Êý¾Ý¿âÁ¬½Ó×Ö·û, ´æ´¢¹ý³Ì×Ö·û, ²ÎÊýÊý×é);
6.ͨ¹ý×Ö·û´®Ë¢Ðµķ½·¨SqlHelper.ExecuteNonQuery(Êý¾Ý¿âÁ¬½Ó×Ö·û, CommandType.Text , Ë¢ÐÂ×Ö·û´®,²ÎÊýÊý×é);
ÔËÓÃʵÀý
using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.IO;
namespace SK.VideoDAL
{
 /// <summary>
 /// File µÄժҪ˵Ã÷¡£
 /// </summary>
 public class File
 {
  
  /// <summary>
  /// ÎļþÊý¾Ý·ÃÎÊÀà
  /// </summary>
  public File()
  {
   //
   // TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
   //
  }
  /// <summary>
  /// Ìí¼ÓÎļþ
  /// </summary>
  /// <param name="FileClassID">Îļþ·ÖÀà±àºÅ</param>
  /// <param name="SetCommend">ÍÆ¼ö·½Ê½</param>
  /// <param name="SetTop">¹Ì¶¥·½Ê½</param>
  /// <param name="Name">ÎļþÃû³Æ</param>
  /// <param name="Intro">¼ò½é</param>
  /// <param name="FileSize">´óС</param>
  /// <param name="Grade">ÆÀ¼¶</param>
  /// <param name="Keyword">¹Ø¼ü×Ö</param>
  /// <param name="PreviewUrl">Ô¤ÀÀͼµØÖ·</param>
  /// <param name="MemberID">·¢²¼ÈËID</param>
 &nb


Ïà¹ØÎĵµ£º

40ÌõASP.NET¿ª·¢Tip

1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾­³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ­»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ­»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤·½Ê½(²»ÒªÃ¿´Î¶¼ÔÚ·þÎñ¶ËÑéÖ¤)¡£
6¡ ......

40ÌõASP.NET¿ª·¢Tip

»¶Ó­ÅÄש£¬¹²Í¬½ø²½£¡£¡£¡
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
 
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾­³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ­»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ­»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤ ......

asp.netʹÓþ«ÁéÄ«ÁÖÌáʾÕÒ²»µ½Ö¸¶¨Ä£¿é

´°Ìå´úÂë:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using AgentObjects;
using SpeechLib;
using System.Web;
using System.Threading;
using System.Text.RegularExpressio ......

asp.net C#ÃüÃû²ÎÊýSqlParameterÏê½â

DBHelper:
         /// <summary>
        /// Ö´Ðвéѯ
        /// </summary>
        /// <param name="sql">ÓÐЧµÄselectÓï¾ä</param ......

ASP.NETÏÂÔØÎļþ³öÏÖÌáʾ¿ò»òÕßÖ±½ÓÏÔʾÔÚä¯ÀÀÆ÷ÖÐ

ASP.NETÏÂÔØÎļþ³öÏÖÌáʾ¿ò»òÕßÖ±½ÓÏÔʾÔÚä¯ÀÀÆ÷ÖÐ
¼¼Êõ½»Á÷   2008-06-20 11:44   ÔĶÁ42   ÆÀÂÛ0  
×ֺţº ´ó´ó  ÖÐÖР СС
1£º³öÏÖÎļþÏÂÔØÌáʾ¿ò
string strFile="F:\\a.doc";//·¾¶¸ù¾Ýʵ¼ÊÇé¿ö¶ø¶¨
if(!System.IO.File.Exists(strFile))
  {
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ