Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

c# ²Ù×÷mssqlÊý¾Ý¿â º¬Óдø²ÎÊýsqlÓï¾äÔËÐÐ

<?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 ......

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


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

SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)3


ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......

C# C/S³ÌÐò³ö´í£ºContextSwitchDeadlock is detected

½ñÌìÔÚVS2005µ÷ÊÔÒ»¸öC# C/S³ÌÐò£¬µ±Í¨¹ýRFCÓëSAPÁ¬½Óʱ¼ä¹ý³¤Ê±£¬³öÏÖ´Ë´íÎó£¬ÔÚÍøÉÏÕÒµ½½â¾ö°ì·¨¡£
VS2008ÉϵÄÒ»¸ö³ÌÐò£¬Í¨¹ýOracle.DataAccess.dllÖ´ÐÐdrop user
cascade²Ù×÷£¬ÎÒÔÚsqlplusÖ´Ðд˲Ù×÷´óÔ¼ÐèÒªÒ»·ÖÖÓ×óÓÒʱ¼ä£¬µ±ÎÒÔÚVS2008ÖÐdebugÆô¶¯´Ë³ÌÐòʱ£¬Ò»Ö±½ÓÊÕµ½
“ContextSwitchDeadlock is detected& ......

ASP.NetÓû§ÑéÖ¤µÄʵÏÖ

ÔÚWeb³ÌÐòÖУ¬ÎÒÃÇÖªµÀ£¬·þÎñÆ÷¶ËºÍIE¿Í»§¶Ë²»Êdz£Á¬µÄ£¬Ö»ÓзÃÎÊʱ²ÅÁ¬½Ó£¬Ò»µ©Ò³Ãæ¼ÓÔØÍêºó£¬Õâ¸öÁ¬½Ó¾Í»á¶Ï¿ª£¬Ò²¾ÍÊÇ˵£¬·ÃÎÊÒ³ÃæAºó£¬ÔÙ·ÃÎÊÒ³ÃæBʱ£¬·þÎñÆ÷¶ËÊDz»ÖªµÀÄãÒѾ­·ÃÎʹýÒ³ÃæAÁË£¬ÉõÖÁ¶ÔÓÚͬһ¸öÒ³Ãæ£¬·þÎñÆ÷¶ËÒ²²»»áÈ¥¼Ç¼ÄãµÄ·ÃÎÊ£¬Ã¿´Î¶¼»áÖØÐÂʵÀý»°·ÃÎʵÄÒ³Ãæ¡£
Õâ¾Í´øÀ´Ò»¸öÎÊÌ⣬Èç¹ûʵÏÖÎÒ·ÃÎÊÁËLo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ