Êý¾Ý½»»»Ñ§Ï°¶þ£º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¶¼ÊÇ´æ·ÅÔÚ·þÎñÆ÷ÄÚ´ ......
ÔÚASPÖУ¬½«ÎļþÉÏ´«µ½·þÎñÆ÷ÊÇÒ»¼þ·Ç³£Âé·³µÄÊÂÇ飬ͨ³£ÐèÒªµÚÈý·½×é¼þµÄÖ§³Ö¡£
ÔÚASP.NET 1.x ÖУ¬ÒªÖ§³ÖÎļþÉÏ´«£¬Ö»ÐëʹÓÃHTMLµÄInput(File)¿Ø¼þ¡£°ÑËü×÷Ϊ·þÎñÆ÷¿Ø¼þÔËÐУ¨ÊÖ¶¯ÉèÖÃrunat="server"£© £¬ÒªÖ±½Ó²Ù×÷ HttpPostedFile¡£
ÔÚASP.NET 2.0ÖУ¬ÐÂÔöÁËFileUpLoad·þÎñÆ÷¿Ø¼þ£¬Ê¹µÃÉÏ´«¸ü¼Ó¼òµ¥¡£
°ü& ......
Ê×ÏÈ£¬ËûÃǵÄÔËÐлúÖÆ²»Í¬¡£aspÊÇÊôÓÚÒ»ÖÖ½âÊÍÐ͵Ŀò¼Ü£¡ÊǽâÊÍÖ´Ðеģ¬Êǽű¾¡£asp.netÊDZàÒëÐ͵ģ¡×îÖÕ»á±à³Ì¶þ½øÖƵĻúÆ÷´úÂë¡£´ÓÕâÒ»µãÀ´Ëµ£¬asp.netÖ´ÐÐЧÂÊÉÏÒª±Èasp¸ß£¡
Æä´Î£¬aspÖ»ÔÊÐíʹÓÃjs»òÕßvbs¡£¶øasp.netÔò²»Ò»Ñù£¬Ö»Òª·ûºÏ¹«¹²ÓïÑÔÔËÐÐ¿â¹æ·¶µÄÓïÑÔ£¬¶¼¿ÉÒÔʹÓã¡´ÓÕâÒ»µãÉÏÀ´Ëµ£¬aspÔڵײã²Ù×÷ÉϽÏasp.ne ......
Ê×ÏÈÐèÒªÔÚÏîÄ¿ÖÐÌí¼Ó(Microsoft XML, v3.0)µÄÒýÓÃ
using MSXML2;
private string VerifyNotifyURL(string URL)
{
MSXML2.XMLHTTPClass xmlhttp=new MSXML2.XMLHTTPClass();
try
{
&nbs ......
¶ÁÈ¡SAPÊý¾Ý, ´ÓÁ½·½ÃæÀ´×ö
1) ×öÒ»¸öC# app ÔÚ·þÎñÆ÷ÉÏ"ÈÎÎñ¼Æ»®"ÿÌì¶ÁÈ¡. ±ØÐëÔÚ·þÎñÆ÷ÉÏÖ´ÐÐ, ·ñÔò¿ÉÄÜ´ÓSAP¶ÁµÄºº×ÖÊÇÂÒÂë.
2) ¶ÔÓÚҪʵʱ¶ÁÈ¡µÄ, ×ö³ÉÒ³Ãæ»òweb Service·ÅOAÉÏ.
ÏÂÃæÊÇÒ³ÃæÊµÏֵIJ¿·Ö´úÂë.
using System.Data.SqlClient; //Á¬½ÓSQL SERVER
using System.Data.OleDb; &n ......