asp.net utf 8 ÖÐÎÄÂÒÂëÎÊÌâ
Unicode ±àÂëÕýÖð½¥³ÉΪ¶àÓïÑÔÖ§³ÖµÄ×îͨÓýâ¾ö·½°¸¡£²ÉÓà Unicode ±àÂëµÄÖÐÎÄÍøÒ³ÄÜÔÚ¸÷ÖÖƽ̨¡¢¸÷ÖÖÀàµÄä¯ÀÀÆ÷É϶¼µÃµ½ºÜºÃµÄ¼æÈÝ¡£utf-8 ÊÇ Unicode µÄÒ»ÖÖ´æ´¢/½»»»ÊµÏÖ·½Ê½¡£¶ÔÓÚ²»Í¬ÊýÖµ·¶Î§µÄ Unicode Â룬Ëü²ÉÓñ䳤µÄ·½Ê½À´±àÂ룺ËùÓÐ ASCII ×Ö·ûÕ¼ÓÃ1¸ö×Ö½Ú£¬´óÓÚ 0x7f µÄÔòÕ¼ÓÃ2µ½4×Ö½Ú²»µÈ¡£¿ÉÒÔ¿´³ö£¬ËùÓÐ ASCII ÎļþÖ±½Ó¼æÈÝ utf-8¡£ÁíÍ⣬¶ÔÓÚÍøÒ³Ô´´úÂëÕâÑù ASCII ×Ö·ûÕ¼ÄÚÈݺܴ󲿷ֵÄÎļþÀ´Ëµ£¬Ëüͨ³£±ÈÆäËû Unicode ´æ´¢/½»»»¸ñʽ£¨Èçutf-16£¬utf-32µÈ£©¸ü½ÚÊ¡¿Õ¼ä¡£Òò´Ë£¬utf-8 ¸ñʽÒÑÔÚÍøÕ¾Éè¼ÆÖй㷺µÄʹÓá£
µ«ÊÇ£¬ÔÚ asp.net ÖÐÎÄÍøÒ³ÖÐʹÓà utf-8 ±àÂëʱ£¬ÉÔ²»Ð¡ÐľͻáÔì³ÉÖÐÎÄÂÒÂ룬ÁîÈËÍ·ÌÛ¡£¶ÔÓÚÕâ¸öÎÊÌ⣬ÍøÉϺܶàµØ·½½¨Ò飺ÔÚ±ØÒªµÄµØ·½ÈÔʹÓà GB2312 ±àÂë¡£ÕâÑùÏÔÈ»²»ÊÇÒ»¸ö³¹µ×µÄ½â¾ö·½°¸¡£±¾ÎÄÌÖÂÛÁËÈçºÎÈçºÎÔÚ asp.net ÍøÕ¾ÖÐÍêȫʹÓà utf-8 ±àÂë¡£
ÔÚ Visual Studio 2005 ÖÐн¨Ò»¸ö asp.net Õ¾µã¡£ÔÚ web.config ÎļþÖÐÉèÖÃÕ¾µãʹÓà utf-8 ±àÂ룺
<?xml version="1.0"?>
...
<configuration>
<system.web>
<globalization fileEncoding="utf-8" />
</system.web>
<configuration>
...
ÕâÑùÒ»À´£¬VS ¿ÉÒÔÔÚÒ»¶¨³Ì¶ÈÉÏʵÏÖ¶Ô utf-8 µÄ×Ô¶¯»¯Ö§³Ö£¬µ«²»ÊǺÜÍêÉÆ¡£¾³£»¹ÊÇ»áÓÐÂÒÂëÎÊÌâ¡£ÏÂÃæµÄÌÖÂÛÔÚ¼´Ê¹Ã»ÓÐÉèÖÃÕ¾µã±àÂëµÄÇé¿öÏÂÒÀÈ»ÄÜÓÐЧ½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
´´½¨Ò»¸ö asp.net Ò³Ã棬²¢±àд´úÂëÈçÏ£º
<%--sample.aspx--%>
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="sample.aspx.cs" Inherits="sample" %>
<!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">
<head runat="server">
<title>²âÊÔ</title>
</head>
<body>
<form id="form1" runat="server">
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem>¾ÉÈÕÖØÀ´</asp:ListItem>
<asp:ListItem>http://live.mingliang.org</asp:ListItem>
</asp:RadioButtonList>
<asp:Button ID="Button1" runat="server" Text="Submit"
Ïà¹ØÎĵµ£º
SiteMapDataSource Web ·þÎñÆ÷¿Ø¼þ´ÓÕ¾µãµØͼÌṩ³ÌÐòÖмìË÷µ¼º½Êý¾Ý£¬È»ºó½«Êý¾Ý´«µÝ¸ø¿ÉÏÔʾ¸ÃÊý¾ÝµÄ¿Ø¼þ£¬Èç TreeView ºÍ Menu ¿Ø¼þ¡£
˵Ã÷£º SiteMap ¿Ø¼þÒ²ÏÔʾµ¼º½Êý¾Ý£¬µ«¸Ã¿Ø¼þ²»ÐèÒª°ó¶¨µ½ SiteMapDataSource ¿Ø¼þ¡£
SiteMapDataSource ¿Ø¼þ°üº¬À´×ÔÕ¾µãµØͼµÄµ¼º½Êý¾Ý¡£´ËÊý¾ ......
¿ÉÒÔʹÓà SiteMapPath¡¢TreeView »ò Menu ¿Ø¼þΪÓû§ÌṩÔÚÍøÕ¾Öе¼º½µÄÒ»Öµķ½·¨¡£
SiteMapPath ¿Ø¼þÏÔʾµ¼º½Â·¾¶£¨Ò²³ÆΪ Breadcrumb »ò Eyebrow£©£¬¸Ã·¾¶ÏÔʾµ±Ç°Ò³µÄλÖò¢ÏÔʾ×÷Ϊ·µ»ØÖ÷Ò³µÄ·¾¶µÄÁ´½Ó¡£
˵Ã÷£º Èç¹ûÒ»¸ö .aspx Ò³°üº¬Ò»¸ö SiteMapPath ¿Ø¼þ£¬Îª³ÊÏִ˿ؼþ£¬±ØÐ ......
Step 1£ºÐ½¨Êý¾Ý¿â(¿â£ºMyForms £»±í£ºusers £»×ֶΣºID£¬userName, userPwd)£»
Step 2£ºÐ½¨ÍøÕ¾£¬web.config µÄÎļþÈ«²¿´úÂëÈçÏ£º
web.config µÄÈ«²¿´úÂë
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings/>
......
ÈçºÎ°Ñ²Ù×÷µÄÊý¾ÝÌí¼Óµ½Êý¾Ý¿âÖУ¿
н¨´¥·¢Æ÷µÄ·½·¨¼°ÔÀí£¿
½ÌʦÈçºÎÌí¼Ó(Éϱ¨)¿ÎÌ⣬ÊÇ·ñÊÇÓÃEXCEL»òÊÇÆäËûµÄ·½·¨OR add task£¨°üÀ¨ä¯ÀÀ¿ÎÌâ¡¢²éÔÄѧÉúÑ¡ÌâÇé¿ö£©£¿
½ÌʦÉóÉóºËÊÇ·ñͨ¹ý£¿
PLAN:
¸ü¸Ä¸öÈËÐÅÏ¢¡¢ÃÜÂëµÈ
½ÌʦµÇ¼¡¢Éϱ¨¿ÎÌâ ( ¼´ÊÇInsert Óï¾ä)£Û Ìí¼Ó¿ÎÌâ ¡¢¿ÎÌâä¯ÀÀ £Ý
½ÌÊ¦È ......
public class SqlCheck
{
public SqlCheck()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
public SqlConnection oconn()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["StudyConnectionString"] ......