asp.netµÄÒ»¸ödbhelperÀà
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.Text;
namespace Maticsoft.DBUtility
{
/// <summary>
/// Copyright (C) 2004-2008
/// Êý¾Ý·ÃÎÊ»ù´¡Àà(»ùÓÚSQLServer)
/// Óû§¿ÉÒÔÐÞ¸ÄÂú×ã×Ô¼ºÏîÄ¿µÄÐèÒª¡£
/// </summary>
public abstract class DbHelperSQL
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®(web.configÀ´ÅäÖÃ)
//<add key="ConnectionString" value="server=127.0.0.1;database=DATABASE;uid=sa;pwd=" />
protected static string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
public DbHelperSQL()
{
}
#region ¹«Ó÷½·¨
public static int GetMaxID(string FieldName,string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = GetSingle(strsql);
if (obj == n
Ïà¹ØÎĵµ£º
ÔÚC#ÖУ¬static±äÁ¿±íʾ¸Ã±äÁ¿ÊôÓÚÀ࣬¶ø²»ÊÇÀàµÄʵÀý¡£¿ÉÒÔ˵ÊǸÃÀàµÄËùÓÐʵÀý¹²ÏíÒ»¸östatic±äÁ¿¡£
asp.netµÄÒ³Ãæ¾ÍÊÇÒ»¸öÀ࣬ÎÒÃÇ·ÃÎÊÒ»¸öÒ³Ãæ¡£¾Í»áÔÚ·þÎñÆ÷ÉÏʵÀý»¯Ò»¸ö¸ÃÀàµÄʵÀý£¬À´ÏìÓ¦ÎÒÃǵÄÇëÇó¡£
“ËùÓÐʵÀý¹²ÏíÒ»¸östatic±äÁ¿” Õâ¾ÍÒâζ×Å£¬ËùÓеĿͻ§¶Ë·ÃÎʵ½µÄasp.netÒ³ÃæÖÐstatic±äÁ¿¶¼ÊÇͬһ¸ ......
1.newÓм¸ÖÖÓ÷¨
µÚÒ»ÖÖ:new Class();
µÚ¶þÖÖ:¸²¸Ç·½·¨
public new XXXX(){}
µÚÈýÖÖ:new Ô¼ÊøÖ¸¶¨·ºÐÍÀàÉùÃ÷ÖеÄÈκÎÀàÐͲÎÊý¶¼±ØÐëÓй«¹²µÄÎÞ²ÎÊý¹¹Ô캯Êý¡£
2.ÈçºÎ°ÑÒ»¸öarray¸´ÖƵ½arrayListÀï
foreach( object o in array )arrayList.Add(o);
3.datagrid.datasous ......
MVC×Ô´øµÄActionFilter
ÔÚAsp.Net WebFormµÄÖÐÒª×öµ½Éí·ÝÈÏ֤΢ÈíΪÎÒÃÇÌṩÁËÈýÖÖ·½Ê½£¬ÆäÖÐ×î³£ÓõľÍÊÇÎÒÃǵÄFormÈÏÖ¤£¬ÐèÒªÅäÖÃÏàÓ¦µÄÐÅÏ¢¡£ÀýÈçÏÂÃæµÄÅäÖÃÐÅÏ¢£º
<authentication mode="Forms">
<forms loginUrl="Login.aspx" defaultUrl="Default.aspx" protection="All" />
</authenticati ......
ÔÚasp.netÖе¼³öexcel ÖбȽÏͨÐеÄ×ö·¨ÊÇ: Response.ContentType = "application/vnd.ms-excel";
È»ºóÖ±½ÓÏòÀïÃæÈÓ html µÄtable
µ«ÊÇÓÐÖÐÎĵÄʱºò ÀϳöÏÖÂÒÂ룬Óкܶà½â¾ö·½°¸£¬µ«¶¼²»ÄÜͨÅ̽â¾ö, ¾ÍÊÇÔÚ Êä³öhtmlÁ½Í·Êä³ö
Response.Write("<html><head><meta http-equiv=Content-Type conte ......