public static class AccessHelper
{
//数据库连接字符串
//WebForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//WinForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
//public static readonly string conn_str = System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString + ";Persist Security Info= ......
public static class AccessHelper
{
//数据库连接字符串
//WebForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//WinForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
//public static readonly string conn_str = System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString + ";Persist Security Info= ......
<?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=diamond;Password=88888888;Initial Catalog=EmailAnalyse" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace OfficeOutlook
{
/// <summary>
///DataBase 的摘要说明
/// </summary>
public class DataBase
{
protected SqlConnection BaseSqlConnection = new SqlConnection();//连接对象
&n ......
<?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=diamond;Password=88888888;Initial Catalog=EmailAnalyse" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace OfficeOutlook
{
/// <summary>
///DataBase 的摘要说明
/// </summary>
public class DataBase
{
protected SqlConnection BaseSqlConnection = new SqlConnection();//连接对象
&n ......
<?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=diamond;Password=88888888;Initial Catalog=EmailAnalyse" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace OfficeOutlook
{
/// <summary>
///DataBase 的摘要说明
/// </summary>
public class DataBase
{
protected SqlConnection BaseSqlConnection = new SqlConnection();//连接对象
&n ......
今天在VS2005调试一个C# C/S程序，当通过RFC与SAP连接时间过长时，出现此错误，在网上找到解决办法。
VS2008上的一个程序，通过Oracle.DataAccess.dll执行drop user
cascade操作，我在sqlplus执行此操作大约需要一分钟左右时间，当我在VS2008中debug启动此程序时，一直接收到
“ContextSwitchDeadlock is detected”消息，操作无法进行下去。
MSDN的解释一如即往地专业并且令人费解：
“如果在试图进行COM上下文转换期间检测到一个死锁，则将激活ContextSwitchDeadlock托管调试助手 (MDA)。 ”
“原因很可能是单线程单元(STA)线程不发送消息。STA线程或者等待而且不发送消息，或者执行一个长时间的操作而且不允许发送消息队列。”
我没看出这程序跟COM有什么关系。看了半天，只看到“长时间的操作”貌似还沾点边，解决的方法倒是简
单，Debug->Exceptions->Managed Debugging
Assistants->ContextSwitchDeadlock,钩除“Thrown”项的复选框。
BTW，
1）COM，Component Object Model，它实际是一类软件开发方式。而COM组件顾名思义是按这种方式开发出来的软件/模块，看看Project->References->Add ......
今天在VS2005调试一个C# C/S程序，当通过RFC与SAP连接时间过长时，出现此错误，在网上找到解决办法。
VS2008上的一个程序，通过Oracle.DataAccess.dll执行drop user
cascade操作，我在sqlplus执行此操作大约需要一分钟左右时间，当我在VS2008中debug启动此程序时，一直接收到
“ContextSwitchDeadlock is detected”消息，操作无法进行下去。
MSDN的解释一如即往地专业并且令人费解：
“如果在试图进行COM上下文转换期间检测到一个死锁，则将激活ContextSwitchDeadlock托管调试助手 (MDA)。 ”
“原因很可能是单线程单元(STA)线程不发送消息。STA线程或者等待而且不发送消息，或者执行一个长时间的操作而且不允许发送消息队列。”
我没看出这程序跟COM有什么关系。看了半天，只看到“长时间的操作”貌似还沾点边，解决的方法倒是简
单，Debug->Exceptions->Managed Debugging
Assistants->ContextSwitchDeadlock,钩除“Thrown”项的复选框。
BTW，
1）COM，Component Object Model，它实际是一类软件开发方式。而COM组件顾名思义是按这种方式开发出来的软件/模块，看看Project->References->Add ......
首先需要在项目中添加(Microsoft XML, v3.0)的引用
using MSXML2;
private string VerifyNotifyURL(string URL)
{
MSXML2.XMLHTTPClass xmlhttp=new MSXML2.XMLHTTPClass();
try
{
xmlhttp.open("GET",URL,false,null,null);
xmlhttp.setRequestHeader("CONTENT-TYPE","text/xml;charset=gb2312");
xmlhttp.send(null);
return System.Text.Encoding.GetEncoding("gb2312").GetString((byte[])xmlhttp.responseBody);
}
catch
{
return "";
} ......
首先需要在项目中添加(Microsoft XML, v3.0)的引用
using MSXML2;
private string VerifyNotifyURL(string URL)
{
MSXML2.XMLHTTPClass xmlhttp=new MSXML2.XMLHTTPClass();
try
{
xmlhttp.open("GET",URL,false,null,null);
xmlhttp.setRequestHeader("CONTENT-TYPE","text/xml;charset=gb2312");
xmlhttp.send(null);
return System.Text.Encoding.GetEncoding("gb2312").GetString((byte[])xmlhttp.responseBody);
}
catch
{
return "";
} ......
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
&nbs ......
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
&nbs ......
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
&nbs ......
---------------------------------------
Asp.Net,C#,SQL,JS,WCF,AJAX,工作流,WPF,MVC,LINQ,设计模式(架构)等技术讨论
“ASP.NET(C#)Fans” QQ群：96877690
---------------------------------------
不管是J2SE、J2EE还是J2ME敬请加入！Eclipse、NetBeans
Java交流QQ高级群扩招：96878255 ......
---------------------------------------
Asp.Net,C#,SQL,JS,WCF,AJAX,工作流,WPF,MVC,LINQ,设计模式(架构)等技术讨论
“ASP.NET(C#)Fans” QQ群：96877690
---------------------------------------
不管是J2SE、J2EE还是J2ME敬请加入！Eclipse、NetBeans
Java交流QQ高级群扩招：96878255 ......
最新文章 : c#