Not able to declare variables in custom user controls

  • Thread starter Thread starter stevong
  • Start date Start date
S

stevong

Hi,

I've a custom user control:

'user1.ascx

<script language="VB" runat="server">
Public str1 as string
Dim conn as System.Data.SqlClient ' But this line hits and error.
What should I do?
</script>
Hello World

I will hit compilation error. What should be the next step? Also, how
do I use custom namespaces in a custom control?

Please advise! Thanks!
 
This statement:
Dim conn as System.Data.SqlClient
is not a full statement - I'm assuming you're wanting to instantiate a
Connection - - which would be more like:

Dim connAs New
SqlConnection(ConfigurationManager.ConnectionStrings("YourconnString").ConnectionString)

Import your namespace (System.Data.SqlClient )
 
only methods are allowed in a server script block. to declare var use

<%
Public str1 as string
Dim conn as System.Data.SqlClient ' But this line hits and error.
%>

but method def are not allowed here.

-- bruce (sqlwork.com)
 
stevong,

You need to import the correct namespace:
<%@ Import Namespace="System.Data.SqlClient" %>

You can import custom namespaces the same way
 
Back
Top