ASP.NET - MS SQL - Stored Procedure - Output table

Yas

Hello,

I would like to create an ASP webpage that has an input box which
takes a string value of <= 20 chars. Then it connects to an MS SQL
server and calls a Stored Procedure passing it the input value and
outputs the results to the webpage in a table.

Could someone please point me in the right direction on where to get
started with this? i'm of course new to ASP.NET :-)

Many thanks in advance for any help or advise.

Yas

Sep 6 '07 #1

Subscribe Reply

1874

Mark Rae [MVP]

"Yas" <ya****@gmail.comwrote in message
news:11**********************@o80g2000hse.googlegr oups.com...

I would like to create an ASP webpage that has an input box which
takes a string value of <= 20 chars. Then it connects to an MS SQL
server and calls a Stored Procedure passing it the input value and
outputs the results to the webpage in a table.

Could someone please point me in the right direction on where to get
started with this? i'm of course new to ASP.NET :-)

This really is absolutely fundamental to virtually every ASP.NET
application. I appreciate that you're new to ASP.NET, and there's nothing
wrong with that - everyone was a newbie on their first day...

However, without a basic understanding of the fundamentals of how ASP.NET
works, you're going to find it very hard going indeed. The .NET Framework is
absolutely huge, and you cannot expect to pick it up by accident.

I strongly suggest you get a copy of this:
http://www.amazon.com/ASP-NET-Everyd...9073130&sr=8-3

and work your way through it...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Sep 6 '07 #2

Alexey Smirnov

On Sep 6, 11:42 am, Yas <yas...@gmail.comwrote:

Hello,

I would like to create an ASP webpage that has an input box which
takes a string value of <= 20 chars. Then it connects to an MS SQL
server and calls a Stored Procedure passing it the input value and
outputs the results to the webpage in a table.

Could someone please point me in the right direction on where to get
started with this? i'm of course new to ASP.NET :-)

Many thanks in advance for any help or advise.

Yas

http://support.microsoft.com/kb/306574
http://www.google.com/search?hl=en&q...d+Procedure%22

Sep 6 '07 #3

Similar topics

8995

ASP / Stored Procedure SQL Insert Help

by: Bill Kellaway | last post by:

Hi there - this should be fairly simple for someone. Basically I can't figure out how to pass the parameters from ASP to a Stored Procedure on SQL. Here's my code: I just need to help in...

ASP / Active Server Pages

28245

Loop thru a SQL Table in stored proc?

by: Eric Martin | last post by:

Hello, Does anyone know of a way to loop thru a SQL table using code in a stored procedure? I need to go thru each record in a small table and build a string using values from the fields...

Microsoft SQL Server

6562

Stored Procedures

by: Jarrod Morrison | last post by:

Hi all Im relatively new to using stored procedures and im not sure if it is possible to do what I am trying to do so any help here is greatly appreciated. I am using the variable @MachineName...

Microsoft SQL Server

7144

Hide subquery results in stored procedure

by: John | last post by:

Hi everyone, I have a stored procedure which I use to query a table. The first part of the stored procedure uses a cursor to update a temp table whilst the second part of the query actually...

Microsoft SQL Server

5101

Concurrency Handling In Stored Procedures

by: xAvailx | last post by:

I have a requirement that requires detection of rows deleted/updated by other processes. My business objects call stored procedures to create, read, update, delete data in a SQL Server 2000 data...

Microsoft SQL Server

16543

Returning multiple rows from a stored procedure

by: Wael | last post by:

Hi, I have the following stored procedure that does some processing and puts the result in a temporary table. I tried several things that procedure to display output that I can access with...

Microsoft SQL Server

2896

C# and SQL-Server Stored Procedures

by: J. S. EDV | last post by:

Hello, I have got a little problem with stored procedures and C#. I have got a stored procedure which should only insert something in a table. For example: ALTER PROCEDURE DBO.PROC1 AS...

C# / C Sharp

2289

Catching values returned by a java program by a DB2 function/stored procedure

by: satish mullapudi | last post by:

Hi, I am using DB2 v8.2 & jdk 1.4. 1. I have a java program which returns an array which contains 1 to 5 numbers. The code: public class ArrayTest { public static final int ARRAY_SIZE = 5;...

DB2 Database

4125

Stored Procedure and SQLCommand

by: fniles | last post by:

I am using VB.NET 2003 and SQL2000 database. I have a stored procedure called "INSERT_INTO_MYTABLE" that accepts 1 parameter (varchar(10)) and returns the identity column value from that table....

Visual Basic .NET

4078

stored procedure in sqlexpress

by: jed | last post by:

I have created this example in sqlexpress ALTER PROCEDURE . @annualtax FLOAT AS BEGIN SELECT begin1,end1,deductedamount,pecentageextra FROM tax

C# / C Sharp

7004

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7167

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7379

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5464

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4915

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3085

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1423

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

657

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

292

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General