Êý¾Ý½»»»Ñ§Ï°¶þ£ºasp.net C# ¶Ô sqlserver±íµÄ²Ù×÷
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
//ÏÔʾÊý¾ÝʾÀý
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//´´½¨±í¼°²åÈëÊý¾Ý
//use jwcrm
//create table userinfo(username char(10),userpwd char(10))
//insert into userInfo values('ÅËÍò·É','123456')
//insert into userInfo values('ÀîÊÀÃ÷','678910')
//select * from userinfo
//Á¬½ÓSQL
SqlConnection thisConnection = new SqlConnection("Server=127.0.0.1;uid=sa;pwd=123;database=jwcrm");
//´´½¨Êý¾Ý¿âÊÊÅäÆ÷
SqlDataAdapter thisAdapter = new SqlDataAdapter("select * from userinfo", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "userinfo");
int i = 0;
foreach(DataRow rowData in thisDataSet.Tables[0].Rows)
{
i++;
&n
Ïà¹ØÎĵµ£º
ASP.NET CacheÖ§³ÖÈýÖÖÀàÐÍ
Ïëдһ¸ö¼¼Êõ¿ìËÙ¸ÅÊö£¬¿ÉÄÜдµÃÌ«¶àÁË¡£¼¼Êõ¸ÅÂÔµÄÄ¿µÄÊÇÒÔ×î¿ì×î¼òµ¥µÄ·½Ê½ÃèÊö³ö¼¼ÊõÒªµã£¬Ò²ÊÇÎÒÏ£ÍûµÄ×îÓÐЧÂʵÄ֪ʶ´«²¥·½Ê½¡£
1£® Ò³Ãæ/¿Ø¼þcache
2£® Ó¦ÓóÌÐò¼¶cache
3£® ä¯ÀÀÆ÷¿Í»§¶Ëcache
´ÓʵÏÖ·½Ê½À´¿´£¬ASP.NET CacheÖеÄÒ³Ãæ/¿Ø¼þcacheºÍÓ¦ÓóÌÐò¼¶cache¶¼ÊÇ´æ·ÅÔÚ·þÎñÆ÷ÄÚ´ ......
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="Default" value="Default" />
</appSettings>
<connectionStrings>
<add name="Default" connectionString="Data Source=192.168.1.197;User ID ......
¸ÅÊö£º
ÅäÖà Web ͬ²½
url: http://technet.microsoft.com/zh-cn/library/ms151810(SQL.90).aspx
ÈôÒª¶Ô¸´ÖÆÊ¹Óà Web ͬ²½£¬ÇëÖ´ÐÐÏÂÁв½Ö裺
ÅäÖ÷¢²¼£¬ÒÔÔÊÐíʹÓà Web ͬ²½¡£
ÅäÖÃÔËÐÐ Microsoft Internet ÐÅÏ¢·þÎñ (IIS) µÄ¼ÆËã»úÒÔͬ²½¶©ÔÄ¡£Ö§³Ö IIS 5.0 ºÍ 6.0 °æ¡£
ÅäÖÃÒ»¸ö»ò¶à¸ö¶©ÔÄÒÔʹÓà Web ͬ²½¡£
......
ÈçºÎΪ Web ͬ²½ÅäÖà IIS
¸üÐÂÈÕÆÚ£º 2006 Äê 12 Ô 12 ÈÕ
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Öè£ ......
ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......