imports and sqlclient

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TdarTdar - 05 Jan 2006 01:28 GMT

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>

Reply to this Message

Kevin Yu [MSFT] - 05 Jan 2006 06:52 GMT

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