Êý¾Ý½»»»Ñ§Ï°¶þ£º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
Ïà¹ØÎĵµ£º
ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......
ÔÚWeb³ÌÐòÖУ¬ÎÒÃÇÖªµÀ£¬·þÎñÆ÷¶ËºÍIE¿Í»§¶Ë²»Êdz£Á¬µÄ£¬Ö»ÓзÃÎÊʱ²ÅÁ¬½Ó£¬Ò»µ©Ò³Ãæ¼ÓÔØÍêºó£¬Õâ¸öÁ¬½Ó¾Í»á¶Ï¿ª£¬Ò²¾ÍÊÇ˵£¬·ÃÎÊÒ³ÃæAºó£¬ÔÙ·ÃÎÊÒ³ÃæBʱ£¬·þÎñÆ÷¶ËÊDz»ÖªµÀÄãÒѾ·ÃÎʹýÒ³ÃæAÁË£¬ÉõÖÁ¶ÔÓÚͬһ¸öÒ³Ãæ£¬·þÎñÆ÷¶ËÒ²²»»áÈ¥¼Ç¼ÄãµÄ·ÃÎÊ£¬Ã¿´Î¶¼»áÖØÐÂʵÀý»°·ÃÎʵÄÒ³Ãæ¡£
Õâ¾Í´øÀ´Ò»¸öÎÊÌ⣬Èç¹ûʵÏÖÎÒ·ÃÎÊÁËLo ......
ASP.NET
MVCµÄTempDataÓÃÓÚ´«ÊäһЩÁÙʱµÄÊý¾Ý£¬ÀýÈçÔÚ¸÷¸ö¿ØÖÆÆ÷Action¼ä´«µÝÁÙʱµÄÊý¾Ý»òÕ߸øView´«µÝһЩÁÙʱµÄÊý¾Ý£¬ÏàÐÅ´ó¼Ò¶¼¿´¹ý“ÔÚ
ASP.NETÒ³Ãæ¼ä´«ÖµµÄ·½·¨ÓÐÄļ¸ÖÖ”Õâ¸öÃæÊÔÌ⣬ÔÚASP.NET
MVCÖÐTempDataµÄ¾ÍÊÇÆäÖеÄÒ»ÖÖ´«Öµ·½·¨¡£TempDataĬÈÏÊÇʹÓÃSessionÀ´´æ´¢ÁÙʱÊý¾ÝµÄ£¬TempDataÖдæ·ÅµÄ ......
ASP.NETÊÇÓÉ΢ÈíÔÚ.NET FrameworkÖÐËùÌṩµÄ£¬¿ª·¢WebÓ¦ÓóÌÐòµÄÀà¿â£¬·â×°ÔÚSystem.Web.dllÎļþÖУ¬ÏÔ¶³öSystem.WebÃüÃû¿Õ¼ä£¬²¢ÌṩASP.NETÍøÒ³´¦Àí¡¢À©³äÒÔ¼°HTTPͨµÀµÄÓ¦ÓóÌÐòÓëͨÐÅ´¦ÀíµÈ¹¤×÷£¬ÒÔ¼°Web
ServiceµÄ»ù´¡¼Ü¹¹¡£ASP.NETÊÇASP¼¼ÊõµÄºó¼ÌÕߣ¬µ«ËüµÄ·¢Õ¹ÐÔÒª±ÈASP¼¼ÊõҪǿ´óÐí¶à¡£
ASP.NET¿ÉÒÔÔËÐÐÔÚ°² ......