嘿我连接到我的SQL数据库时遇到问题。我第一次启动我的网站 [英] Hey I have problem with connecting to my SQL database. First time I launch my website
问题描述
我第一次启动我的网站时收到此错误
System.ComponentModel.Win32Exception未找到网络路径
但是当我刷新我的网站时没有问题。
我正在使用和C#编写的db数据访问文件,当我调试它显示错误是在第22行。但我不明白为什么,因为我正在打开并且每次关闭。
我的dbdataAccess文件
public class dbDataAccess
{
readonly string _strDB = ConfigurationManager.ConnectionStrings [ connect ] .ConnectionString;
public DataTable GetData(SqlCommand cmd)
{
DataSet objDS = new DataSet();
SqlConnection objConnect = new SqlConnection(_strDB);
cmd.Connection = objConnect;
SqlDataAdapter objDa = new SqlDataAdapter();
objDa.SelectCommand = cmd;
objDa.Fill(objDS); // 这是失败的地方
objConnect.Close();
return objDS.Tables [ 0 ];
}
public void ModifyData(SqlCommand cmd)
{
SqlConnection objConnect = new SqlConnection(_strDB);
cmd.Connection = objConnect;
objConnect.Open();
cmd.ExecuteNonQuery();
objConnect.Close();
}
public int intModifyData(SqlCommand CMD)
{
SqlConnection objConn = new SqlConnection(_strDB);
int antalrk;
尝试
{
CMD.Connection = objConn;
objConn.Open();
antalrk = CMD.ExecuteNonQuery();
}
catch
{
throw ;
}
最后
{
objConn.Close();
}
return antalrk;
}
}
我在web配置中的连接字符串
< 添加 名称 = connect connectionString = 数据源= **********;初始目录= ********;用户ID = ********;密码= ******** providerName = System.Data.SqlClient / >
和第一种方法我呼叫。
public DataTable GetAll()
{
string strSQL = ********;
SqlCommand CMD = new SqlCommand(strSQL);
return objCMD.GetData(CMD);
}
我的尝试:
调试和搜索google并尝试不同的解决方案和连接字符串
可能有一些原因:
1)服务中的SQL Server未运行。
2)分布式事务处理协调器服务未运行。
请检查这两项服务并检查连接字符串。
First time i launch my website i get this error
System.ComponentModel.Win32Exception network path was not found
but when i refresh my site there is no problem.
I am using and db data access file written in C#, when i debug it shows there error is in line 22. But i dont understand why, because i am opening and closing everytime.
my dbdataAccess file
public class dbDataAccess
{
readonly string _strDB = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
public DataTable GetData(SqlCommand cmd)
{
DataSet objDS = new DataSet();
SqlConnection objConnect = new SqlConnection(_strDB);
cmd.Connection = objConnect;
SqlDataAdapter objDa = new SqlDataAdapter();
objDa.SelectCommand = cmd;
objDa.Fill(objDS);//this is where it fails
objConnect.Close();
return objDS.Tables[0];
}
public void ModifyData(SqlCommand cmd)
{
SqlConnection objConnect = new SqlConnection(_strDB);
cmd.Connection = objConnect;
objConnect.Open();
cmd.ExecuteNonQuery();
objConnect.Close();
}
public int intModifyData(SqlCommand CMD)
{
SqlConnection objConn = new SqlConnection(_strDB);
int antalrk;
try
{
CMD.Connection = objConn;
objConn.Open();
antalrk = CMD.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
objConn.Close();
}
return antalrk;
}
}
And my connection string in web config
<add name="connect" connectionString="Data Source=**********;Initial Catalog=********;User ID=********;Password=********" providerName="System.Data.SqlClient"/>
and the first method i call.
public DataTable GetAll()
{
string strSQL = "********";
SqlCommand CMD = new SqlCommand(strSQL);
return objCMD.GetData(CMD);
}
What I have tried:
debugging and search in google and tryede different solutions and connection strings
There may be some reasons :
1) SQL Server in services is not running.
2) Distributed Transaction Coordinator service is not running.
Please check these two services and check connection string also.
这篇关于嘿我连接到我的SQL数据库时遇到问题。我第一次启动我的网站的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!