数据网格的asp.net和sql连接 [英] asp.net and sql connection for data grid

问题描述

myConnection = new _ SqlConnection("server=localhost;uid=sa;pwd=;" _ & "database=Pension Database")
myCommand = new SqlDataAdapter("SELECT * FROM Departments", _ myConnection)

系统产生如下错误
编译器错误消息:BC30203:预期的标识符.

源错误:

The system generates error as follows
Compiler Error Message: BC30203: Identifier expected.

Source Error:

Line 8:   Dim myCommand As SqlDataAdapter
Line 9:  
Line 10:  myConnection = new _ SqlConnection("server=localhost;uid=sa;pwd=;" _ & "database=Pension Database")
Line 11:  myCommand = new SqlDataAdapter("SELECT * FROM Departments", _ myConnection)
Line 12:

[edit]代码块，标签-OriginalGriff [/edit]

[edit]Code blocks, tags - OriginalGriff[/edit]

推荐答案

要么删除"_"字符，要么换行以使它们成为最后一个字符线.

Either remove the "_" characters, or break the lines so that they are the last character on the lines.

myConnection = new _ SqlConnection("server=localhost;uid=sa;pwd=;" & "database=Pension Database")
myCommand = new SqlDataAdapter("SELECT * FROM Departments", myConnection)

myConnection = new _ SqlConnection("server=localhost;uid=sa;pwd=;" _
 & "database=Pension Database")
myCommand = new SqlDataAdapter("SELECT * FROM Departments", _
 myConnection)

转到服务器浏览器右击连接

单击添加连接

SQL Server的写用户名和密码

选择您的服务器名称，数据库并单击测试连接，如果没有提示，请单击

您可以在SERVER EXPLORER中查看新的数据库连接

正确单击数据库连接并选择属性和副本

您代码中的数据和粘贴

< pre lang ="midl"> myConnection = new _ SqlConnection(COPY AND PASTE)</pre>

注意在代码中编辑密码并再次写入

GO TO SERVER EXPLORER RIGHT CLICK ON CONNECTIONS

CLICK ADD CONNECTIONS

WRITE USERID AND PASSWORD OF SQL SERVER

CHOOSE YOUR SERVERNAME ,DATABASE AND CLICK TEST CONNECTION AND IF IT IS SUCSSES CLIK OK

yOU CAN SEE YOUR NEW DATABASE CONNECTION IN SERVER EXPLORER

RIGHT CLICK ON YOUR DATABASE CONNECTION AND CHOOSE PROPERTIES AND COPY

THE DATASORCE AND PASTE IN YOUR CODE

<pre lang="midl">myConnection = new _ SqlConnection(COPY AND PASTE)</pre>

NOTE EDIT THE PASSWORD IN THE CODE AND WRITE AGAIN

这篇关于数据网格的asp.net和sql连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！