imports and sqlclient

G

Guest

Hello,
I have this page however the sqlclient is not defined, i thought you just
had to put
Imports system
Imports System.Data
Imports System.Data.SqlClient

into the page but that just gives me syntax errors.

what am I missing to get sqlclient to work.

also how do i get SqlDbType command to work..

Tdar


Page as follows:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<%

Dim cnStr As String
cnStr =
ConfigurationManager.ConnectionStrings("SilverQueen_Main_SystemConnectionString1").ConnectionString
Dim SqlConnection1 As New Data.SqlClient.SqlConnection(cnStr)

Dim backUpDB As SqlClient.SqlCommand
backUpDB = New SqlClient.SqlCommand
backUpDB.CommandType = CommandType.StoredProcedure
backUpDB.CommandText = "BackUpDBSproc"
backUpDB.Connection = SqlConnection1
'not sure if this is how to add parameter need to figure this out
backUpDB.Parameter.Add("tranid", SqlDbType.Int).Value = intYear
SqlConnection1.Open()
backUpDB.ExecuteNonQuery()
'have to find out how to get a single response back from the sql sp...
SqlConnection1.Close()
%>
</body>
</html>
 
K

Kevin Yu [MSFT]

Hi Tdar,

Yes, you can import namespace into the page code like the following:

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient"%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<%
Dim cnStr As String
cnStr =
ConfigurationManager.ConnectionStrings("SilverQueen_Main_SystemConnectionStr
ing1").ConnectionString
Dim SqlConnection1 As New Data.SqlClient.SqlConnection(cnStr)

Dim backUpDB As SqlClient.SqlCommand
backUpDB = New SqlClient.SqlCommand
backUpDB.CommandType = CommandType.StoredProcedure
backUpDB.CommandText = "BackUpDBSproc"
backUpDB.Connection = SqlConnection1
'not sure if this is how to add parameter need to figure this out
backUpDB.Parameters.Add("tranid", SqlDbType.Int).Value = intYear
SqlConnection1.Open()
backUpDB.ExecuteNonQuery()
'have to find out how to get a single response back from the sql sp...
SqlConnection1.Close()
%>
</body>
</html>

For more information, please check the following link:

http://msdn2.microsoft.com/en-us/library/eb44kack.aspx

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
K

Kevin Yu [MSFT]

HiTdar,

Sorry, but No, it has to be done within every file.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

note getting returned data and asp.net 2 5
Style sheet question 2
Why is no viewState send to the Browser in this piece of aspx code 2
MS Access connection 1
newbie, trouble with doctype update 7
Is there any guideline in what section in aspx page where I should put my controls 1
Why is not the second control visible in design mode 9
css and master page problem 4

Top