For completeness, here is the part for getting the count of records in a table,
csp_MakeListAll 'Details', 'C#'
produced
CREATE PROCEDURE dbo.usp_details_ListAll AS
-- Purpose:
-- Select list of all on details table
-- History:
-- 08Mar2008 ACERXP\Clive Original coding
SET NOCOUNT ON
SELECT
id,
Title,
Name,
Email,
teamemtable_id
FROM details
ORDER BY
id
RETURN
----------------- this is the end --------------
GO
asp_dbPermissions
GO
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: filling the textbox,dropdownlist from the database??
Mar 08, 2008 02:51 PM|LINK
For completeness, here is the part for getting the count of records in a table,
csp_MakeListAll 'Details', 'C#'
produced
CREATE PROCEDURE dbo.usp_details_ListAll AS
-- Purpose:
-- Select list of all on details table
-- History:
-- 08Mar2008 ACERXP\Clive Original coding
SET NOCOUNT ON
SELECT
id,
Title,
Name,
Email,
teamemtable_id
FROM details
ORDER BY
id
RETURN
----------------- this is the end --------------
GO
asp_dbPermissions
GO
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239