3 Techniques 1. Simple Fixed ‘N’ SELECT TOP 10 NewsURL, ArticleTitle, ArticleAuthor FROM NewsStoriesTable ORDER BY PublicationDate DESC 2. Dynamic ‘N’ Records CREATE PROCEDURE getRecentArticles ( @ResultCount int ) AS Declare @sSQL Set @sSQL = “Select TOP ” + @ResultCount + ” NewsURL, ArticleTitle, ArticleAuthor FROM NewsStoriesTable ORDER BY PublicationDate DESC” sp_executesql @sSQL 3. Dynamic… (0 comment)

Ex: [sourcecode language=’vb’] ‘ Add values to Hashtable Dim aHash As New Hashtable aHash.Add(“id”, Trim(txtID.Text)) aHash.Add(“name”, Trim(txtName.Text)) ‘ Read Values from Hashtable Dim en As IDictionaryEnumerator en = aHash.GetEnumerator While en.MoveNext Response.write (“Key : ” & en.Key & ” / Value : ” & en.Value) End While [/sourcecode]… (0 comment)