Not able to declare variables in custom user controls

[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!

 

[David Wier]

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 )

 

[bruce barker]

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)

 

[Guest]

stevong,

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

You can import custom namespaces the same way