偶滴程序如下:
<script laguage="VB" runat="server">
sub page_load(sender as Object,e as EventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim ds as DataSet
myConnection = New SqlConnection( "server=localhost;database=Pubs;uid=sa;pwd=''" )
myConnection.Open()
la1.text="Connection Opened!"
myCommand = New SqlCommand( "select * from employee",myConnection)
MyDataGrid.DataSource=myCommand.ExecuteReader()
MyDataGrid.DataBind()
end sub
</script>可执行到myConnection.Open就出错
[SqlException: SQL Server 不存在或访问被拒绝。]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
ASP.WebForm1_aspx.page_load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx:11
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()并且SQL连接模式为SQL Server And Windows
请问那里出错了?
<script laguage="VB" runat="server">
sub page_load(sender as Object,e as EventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim ds as DataSet
myConnection = New SqlConnection( "server=localhost;database=Pubs;uid=sa;pwd=''" )
myConnection.Open()
la1.text="Connection Opened!"
myCommand = New SqlCommand( "select * from employee",myConnection)
MyDataGrid.DataSource=myCommand.ExecuteReader()
MyDataGrid.DataBind()
end sub
</script>可执行到myConnection.Open就出错
[SqlException: SQL Server 不存在或访问被拒绝。]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
ASP.WebForm1_aspx.page_load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx:11
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()并且SQL连接模式为SQL Server And Windows
请问那里出错了?
解决方案 »
- 动态文本框的问题???
- JavaScript声名式函数 与 函数表达式
- 我问我的牛B同事,牛B同事丢了一句,字符转义,就不里我了,我还是不懂
- 无法在 Web 服务器上启动调试 ~~~~~
- 在线讨论:关于在global.asax.cs文件中放置数据库连接代码的问题
- asp.net中的datagrid问题集中营!!!!!!!!!!!!
- webHtmlEdit 如何获取上传的文件名字
- 给一个页面传递参数时,如何隐藏其中某个参数?**在线等**
- 求助~~~ASP.NET用户控件中GridView的问题
- 关于 web service
- 有网上有支持asp.net 2.0的虚拟服务器吗?
- 我快郁闷死了!求教各位大虾!在线等,高分!
2。你用command是取不出数据来的,用sqldataadapter
然后 fill(ds)
private void BindDataGrid()
{
SqlConnection myConnection = new SqlConnection("server=localhost;database=Test;uid=sa;pwd=123456");
SqlCommand myCommand = new SqlCommand("select * from person", myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
MyDataGrid.DataSource = dr;
MyDataGrid.DataBind();
myConnection.Close();
}
你可以用netstat -an 查看1433端口是否打开
你也可以打开开始-->程序--Microsoft Sql Server-->服务器网络实用工具
然后启用WinSock代理,代理地址为127.0.0.1,代理端口为1433,这样也可以打开1433端口
记住用netstat -an 查看1433端口的开启情况