Êý¾Ý½»»»Ñ§Ï°¶þ£º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
Ïà¹ØÎĵµ£º
StringWriter sw = new StringWriter();
sw.WriteLine("·ÃÎʹºÂòÂÊ");
&nbs ......
½ñÌìÔÚVS2005µ÷ÊÔÒ»¸öC# C/S³ÌÐò£¬µ±Í¨¹ýRFCÓëSAPÁ¬½Óʱ¼ä¹ý³¤Ê±£¬³öÏÖ´Ë´íÎó£¬ÔÚÍøÉÏÕÒµ½½â¾ö°ì·¨¡£
VS2008ÉϵÄÒ»¸ö³ÌÐò£¬Í¨¹ýOracle.DataAccess.dllÖ´ÐÐdrop user
cascade²Ù×÷£¬ÎÒÔÚsqlplusÖ´Ðд˲Ù×÷´óÔ¼ÐèÒªÒ»·ÖÖÓ×óÓÒʱ¼ä£¬µ±ÎÒÔÚVS2008ÖÐdebugÆô¶¯´Ë³ÌÐòʱ£¬Ò»Ö±½ÓÊÕµ½
“ContextSwitchDeadlock is detected& ......
viewÔÚMVCģʽÖÐÓëÓû§½øÐÐ×îÖ±½ÓµÄ½Ó´¥£¬Ëü¸ºÔðÊý¾ÝµÄ³ÊÏÖ¡£ÕâÀïҪעÒâÒ»µã¾ÍÊÇ£¬viewÖ»ÊǸºÔðÊý¾ÝµÄ³ÊÏÖ£¬ËùÒÔÎÒÃÇÓ¦¸ÃÒª¾¡Á¿ÈÃ
viewÖв»Éæ¼°ÒµÎñÂß¼µÄ´¦Àí¡£
ÎÒÃÇÀ´Ìí¼ÓÒ»¸öBlogÊ×Ò³µÄview¡£ÔÚ°²×°ÁËASP.NET MVCºó£¬ÎÒÃÇÔÚÌí¼ÓÐÂÏîÄ¿µÄʱºò¿ÉÒÔ¿´µ½ÓÐMVCµÄviewÄ£°å£º
×¢£ºÈç¹ûÄãµÄÊÇÖÐÎİæ
µÄVS£¬°²×°Íêºó¿ ......
ASP.NET
MVCµÄTempDataÓÃÓÚ´«ÊäһЩÁÙʱµÄÊý¾Ý£¬ÀýÈçÔÚ¸÷¸ö¿ØÖÆÆ÷Action¼ä´«µÝÁÙʱµÄÊý¾Ý»òÕ߸øView´«µÝһЩÁÙʱµÄÊý¾Ý£¬ÏàÐÅ´ó¼Ò¶¼¿´¹ý“ÔÚ
ASP.NETÒ³Ãæ¼ä´«ÖµµÄ·½·¨ÓÐÄļ¸ÖÖ”Õâ¸öÃæÊÔÌ⣬ÔÚASP.NET
MVCÖÐTempDataµÄ¾ÍÊÇÆäÖеÄÒ»ÖÖ´«Öµ·½·¨¡£TempDataĬÈÏÊÇʹÓÃSessionÀ´´æ´¢ÁÙʱÊý¾ÝµÄ£¬TempDataÖдæ·ÅµÄ ......
¶ÁÈ¡SAPÊý¾Ý, ´ÓÁ½·½ÃæÀ´×ö
1) ×öÒ»¸öC# app ÔÚ·þÎñÆ÷ÉÏ"ÈÎÎñ¼Æ»®"ÿÌì¶ÁÈ¡. ±ØÐëÔÚ·þÎñÆ÷ÉÏÖ´ÐÐ, ·ñÔò¿ÉÄÜ´ÓSAP¶ÁµÄºº×ÖÊÇÂÒÂë.
2) ¶ÔÓÚҪʵʱ¶ÁÈ¡µÄ, ×ö³ÉÒ³Ãæ»òweb Service·ÅOAÉÏ.
ÏÂÃæÊÇÒ³ÃæÊµÏֵIJ¿·Ö´úÂë.
using System.Data.SqlClient; //Á¬½ÓSQL SERVER
using System.Data.OleDb; &n ......