asp.net̽Õë·ÂpetshopµÄÒ»¸öÊý¾Ý·ÃÎʲãµÄÀà
·ÂpetshopµÄÒ»¸öÊý¾Ý·ÃÎʲãµÄÀà ³Ë·çÏÖÓÐÔ´´³ÌÐò³Ë·ç¹ã¸æÁªÃËϵͳ³Ë·ç¶àÓû§¼ÆÊýÆ÷ ³Ë·ç¶àÓû§PHPͳ¼ÆÏµÍ³ ³Ë·çµçÓ°³ÌÐò³Ë·çÍøÖ·³ÌÐò³Ë·ç¹ã¸æ¹ÜÀíϵͳ³Ë·çasp.net̽Õë·ÂpetshopµÄÒ»¸öÊý¾Ý·ÃÎʲãµÄÀà using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace yueying.Components
{
/// <summary>
/// DBClass µÄժҪ˵Ã÷¡£
/// </summary>
public class DBClass
{
protected static string strConn = ConfigurationSettings.AppSettings["strConn"];
public DBClass()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
//¹¦ÄÜ:Ö´ÐÐsqlÓï¾ä,·µ»Øbool
internal bool ExecuteSql(string strSQL)
{
bool success=false;
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand myCmd = new OleDbCommand(strSQL,conn);
try
{
conn.Open();
myCmd.ExecuteNonQuery();
success=true;
}
catch(System.Data.OleDb.OleDbException e)
{
throw new Exception(e.Message);
}
finally
{
myCmd.Dispose();
conn.Close();
}
return success;
}
//¹¦ÄÜ:Ö´ÐÐsqlÓï¾ä,Èç¹ûÓмǼµÄ»°·µ»Ø1,·ñÔò·µ»Ø0
internal int ExecuteSqlDr(string strSQL)
{
OleDbConnection myCn = new OleDbConnection(strConn);
OleDbCommand myCmd = new OleDbCommand(strSQL,myCn);
try
{
myCn.Open();
OleDbDataReader myDr = myCmd.ExecuteReader();
if(myDr.Read())
{
Ïà¹ØÎĵµ£º
ʲôÊÇCache¶ÔÏó?
ÄãÔÚÉú³É¸ßÐÔÄÜÍøÂçÓ¦ÓóÌÐòʱËùÓöµ½µÄÒ»¸öÎÊÌâ¾ÍÊÇÐèÒª±ÜÃâÖØ¸´¡£Ò»¸öCache¶ÔÏóÔÊÐíÔÚËüÃǵÚÒ»´Î±»ÇëÇóʱÔÚÄÚ´æÖлº´æÏȻºó½«±»»º´æµÄ¸±±¾ÓÃÓÚÒÔºóµÄÇëÇó¡£Ê¹Óñ»»º´æµÄ¸±±¾ÔÊÐíÄã±ÜÃâÖØ½¨Âú×ãÒÔǰÇëÇóµÄÐÅÏ¢£¬ÌرðÊÇÄÇЩÿ´Î´´½¨Ê±¶¼ÐèÕ¼ÓÐÃ÷ʾµÄ·þÎñÆ÷ÉϵĴ¦ÀíÆ÷ʱ¼äµÄÃüÁî¡£
³ý»º´æ¸ö±ðÏÈç» ......
public static string TheColor(string color,string enumName)
{
return string.Format("<span style=\"color={0}\">{1}</span>",color,enumName);
  ......
×î½üÔÚѧУÀïÃæ£¬ÀÏʦÈÃÎÒÃÇ×öÒ»¸öÀàËÆÓÚÉçÇøÐ͵IJ©¿ÍÍøÕ¾£¬¾ÍÏñ°Ù¶È¿Õ¼äÄÇÖֵģ¬¸Ð¾õ²»ÊǺܸ´ÔÓ£¬¹Ø¼üÊÇÑùʽҪ×öµÃºÃ¿´£¬»»·ôµÄ¹¦ÄÜÈÃÎҺܾÀ½á£¬ÎâSir¸øÎÒÃǵĽ¨ÒéÊǰÑÄÇЩ¹¦Äܶ¼×ö³ÉÓû§¿Ø¼þ£¬È»ºóÒªÓõÄʱºò£¬Ö±½ÓÍϽøÀ´¾ÍÐÐÁË£¬¿ÉÒÔ×öÁ½Ì×ÍêÈ«ÍêÈ«²»Í¬·ç¸ñµÄÍøÒ³£¬ÔÚÎÒÃÇĿǰDIV+CSSˮƽÏ൱²ËµÄÇé¿öÏ£¬Õâ ......
aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ArticlePage.aspx.cs" Inherits="ArticlePage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" > ......
¶ÔÓÚ´óÁ¿µÄÊý¾Ý£¬ÓÐʱºòµ¼³öµ½ExcelÖн«¸ü¼Ó·½±ã½øÐÐÊý¾Ýͳ¼Æ·ÖÎö£¬¶ø¶ÔÓÚÅŰæ´òÓ¡Ôòµ¼³öµ½WorldÎĵµÖиü¼Ó·½±ã¡£ÔÚASP.NET¿ÉÒÔͨ¹ýÉÙÁ¿´úÂëʵÏÖÕâÁ½ÖÖµ¼³ö¡£
н¨Ò»Ò³Ã棬¸ÃÒ³Ãæ²¼¾ÖHtmlÔ´ÂëÈçÏ£º
<form id="form1" runat="server"><div> ......