Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Êý¾Ý½»»»Ñ§Ï°¶þ£º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


Ïà¹ØÎĵµ£º

£¨×ª£©SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)2


ÈçºÎΪ Web ͬ²½ÅäÖà IIS
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Ö裺
SQL Server Management Studio: ......

SQLServer ×î³£ÓõÄË÷Òý×Ö¶Î(ͨÓÃË÷Òý×Ö¶Î)

Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
 
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×Ö¶Î :
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËØ¶¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ ......

ASP.Net ºÍ ASPÓÐÊ²Ã´Çø±ð£¿

Ê×ÏÈ£¬ËûÃǵÄÔËÐлúÖÆ²»Í¬¡£aspÊÇÊôÓÚÒ»ÖÖ½âÊÍÐ͵Ŀò¼Ü£¡ÊǽâÊÍÖ´Ðеģ¬Êǽű¾¡£asp.netÊDZàÒëÐ͵ģ¡×îÖÕ»á±à³Ì¶þ½øÖƵĻúÆ÷´úÂë¡£´ÓÕâÒ»µãÀ´Ëµ£¬asp.netÖ´ÐÐЧÂÊÉÏÒª±Èasp¸ß£¡
Æä´Î£¬aspÖ»ÔÊÐíʹÓÃjs»òÕßvbs¡£¶øasp.netÔò²»Ò»Ñù£¬Ö»Òª·ûºÏ¹«¹²ÓïÑÔÔËÐÐ¿â¹æ·¶µÄÓïÑÔ£¬¶¼¿ÉÒÔʹÓã¡´ÓÕâÒ»µãÉÏÀ´Ëµ£¬aspÔڵײã²Ù×÷ÉϽÏasp.ne ......

ASP.NET MVC ÈëÃÅ11¡¢Ê¹ÓÃAJAX

ÔÚASP.NET MVC beta·¢²¼Ö®Ç°£¬M$¾ÍÐû²¼Ö§³Ö¿ªÔ´µÄJS¿ò¼ÜjQuery£¬È»ºóASP.NET MVC
beta·¢²¼ºó£¬Ä㽨Á¢Ò»¸öASP.NET MVC betaµÄÏîÄ¿ºó£¬Äã¿ÉÒÔÔÚÏîÄ¿µÄscriptsĿ¼ÏÂÕÒµ½ASP.NET
AJAXºÍjQueryµÄJS¡£·´ÕýÎÒÊDZȽÏϲ»¶jQueryµÄ£¬ËùÒÔ¶ÔÓÚM$´Ë¾Ù»¹ÊÇͦÐÀοµÄ¡£
·Ï»°²»¶à˵£¬ÎÒÃÇʹÓÃAJAXÀ´ÊµÏÖ·¢±íÆÀÂ۵ŦÄܰɡ£ÏÈÀ´¿´¿´ÔõÑ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ