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
Ïà¹ØÎĵµ£º
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤·½Ê½(²»ÒªÃ¿´Î¶¼ÔÚ·þÎñ¶ËÑéÖ¤)¡£
6¡ ......
»¶ÓÅÄש£¬¹²Í¬½ø²½£¡£¡£¡
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤ ......
´°Ìå´úÂë:
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 ......
DBHelper:
/// <summary>
/// Ö´Ðвéѯ
/// </summary>
/// <param name="sql">ÓÐЧµÄselectÓï¾ä</param ......
ASP.NETÏÂÔØÎļþ³öÏÖÌáʾ¿ò»òÕßÖ±½ÓÏÔʾÔÚä¯ÀÀÆ÷ÖÐ
¼¼Êõ½»Á÷ 2008-06-20 11:44 ÔĶÁ42 ÆÀÂÛ0
×ֺţº ´ó´ó ÖÐÖРСС
1£º³öÏÖÎļþÏÂÔØÌáʾ¿ò
string strFile="F:\\a.doc";//·¾¶¸ù¾Ýʵ¼ÊÇé¿ö¶ø¶¨
if(!System.IO.File.Exists(strFile))
{
  ......