473,220 Members | 2,217 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,220 software developers and data experts.

Can I use ASP WEB MATRIX to run Stored Procedures from SQL Server 2000

I am trying to run a stored procedure on SQL Server 2000
from ASP Web Matrix. When I insert the line at the top of
the code page, Imports Sql.Data.SqlClient I keep getting
the following message: "BC30465: 'Imports' statements
must precede any declarations." For the life of me, I
can't figure this out. Am I doing something wrong? Can
you run Sql 2000 stored procedures from ASP Web Matrix?
Please Help. Thanks................

Jul 21 '05 #1
2 2221
Jeff, I don't know if ASP Web Matrix can run stored procedures but I can
answer your immediate problem.

The answer lies within the error message:

"'Imports' statements must precede any declarations."

"Jeff Thur" wrote:
I am trying to run a stored procedure on SQL Server 2000
from ASP Web Matrix. When I insert the line at the top of
the code page, Imports Sql.Data.SqlClient I keep getting
the following message: "BC30465: 'Imports' statements
must precede any declarations." For the life of me, I
can't figure this out. Am I doing something wrong? Can
you run Sql 2000 stored procedures from ASP Web Matrix?
Please Help. Thanks................

Jul 21 '05 #2
Jeff,

This is the second message in this newsgoup about Web Matrix.

Can you explain to us what makes an application made with the Web Matrix so
special.
In my opinion is it just an aspx application made with that tool.

Did you see messages as "I use the NoteBook" to make an application or "I
use Visual.Studio Net" to make an application. I ask you this because I told
you this in a previous answer, where I gave you as well that answer where I
advised you to include an import, what from I see now that it helped with
your problem in this message.

What is your goal, showing something about the quality from the Web Matrix?

Cor
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: TJ Olaes | last post by:
Hello all, this is my second post to this newsgroup. It's a question about stored procedures and permissions and how these behave between databases. Here's the scenario. I have a database that...
1
by: Karl | last post by:
Hi, I am trying to put SQL Server Stored Procedures into Sourcesafe as per the Microsoft Knowledge Base article 818368, but have run into a problem. The web server is SQL Server 2000 running on...
11
by: jrefactors | last post by:
I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...
1
by: rdshultz | last post by:
Good morning everyone. Could someone tell me if there is a book out there which gives examples of both VB.net code and creating SQL Server 2000 stored procedures and how you get them to work...
2
by: mike | last post by:
H There are two ways to execute a stored procedure using ADO.NE - call "exec sp_myproc val1,val2" statement over SqlCommand myCommand = new SqlCommand(SQLQuery, mySqlConnection) - use...
45
by: John | last post by:
Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards
2
by: Jeff Thur | last post by:
I am trying to run a stored procedure on SQL Server 2000 from ASP Web Matrix. When I insert the line at the top of the code page, Imports Sql.Data.SqlClient I keep getting the following message:...
1
by: nickwilson.nick | last post by:
I have several stored procedures, created in a development environment, that I need to move to a 'QA' environment, and then in turn, to various production environments. When I move these stored...
0
by: Ryan | last post by:
PLEASE HELP!! I am trying to do what I think should be the simplest thing. In Visual Studio 2005, I set up a datagrid and then went ot configure a datasource for it. I made my connection to...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.