Matching end delimiter error

sthmpsn1 · Jun 24, 2002

I am working with my first ASP.NET program. This is actually a tutorial on dotnetjunkies. I am getting a Matching end delimiter " not found in connection option value. I am not sure what this means. What am I missing? I have indicated which line below

<%@ import Namespace="System.Data.sqlClient" %>
<%@ import Namespace="System.Data" %>
<%@ Page Language="vb" Debug="true" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Lets give it a try</title>
<script runat="server">
Public Sub Page_Load(Source as Object, E As EventArgs)
if Not Page.IsPostBack Then
BindData()
End If
End Sub

Public Sub BindData()
Dim myDataSet as New DataSet
Dim mySqlDataAdapter as SqlDataAdapter
mySqlDataAdapter = New SqlDataAdapter( _ 'Error message in this line.
"SELECT * FROM Person", _
"server=AM1ST_FS1;database=HRINFO;uid=sa;&quot

mySqlDataAdapter.Fill(myDataSet, "Person&quot

PersonInfo.DataSource = myDataSet.Tables("Person&quot

PersonInfo.DataBind()
End Sub
</script>

</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<h3>Editing Records in The DataGrid</h3>
<asp

ataGrid id="personInfo" Runat="server" />
</form>
</body>
</HTML>

link9 · Jun 24, 2002

Not sure for all the wrapping there. Try this and see if it works... just cleaning it up a bit, leaving less room for errors:

dim sql as new string("SELECT * FROM Person&quot

dim strCon as new string("server=AM1ST_FS1;database=HRINFO;uid=sa;&quot

dim mySqlDataAdapter as new sqlDataAdapter(sql,strCon)

hth

paul

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Matching end delimiter error

sthmpsn1

MIS

link9

Programmer

Similar threads

Part and Inventory Search

Sponsor