Subscribe in a reader
When working with a web application that contains data items that do not change too often, it improves the performance of the application to store data items in the server cache and retrieve those items from the cache instead of making an extra trip to the database. Also clearing the cache when a item does change is important for your application.
There are a number of really good content management systems available today from Dot Net Nuke to Joomla to Wordpress and creating web sites with them is fast and somewhat easy allowing you to focus more on design and content. But when you need to dig into the database to remove old ads or quickly delete spam comments, knowing the tables available with a single SQL statement is very helpful. I came across a great SQL statement that shows not only the tables but record counts within those tables. And after finding the table containing the information to be changed, getting a list of the Top 10 records with all the columns available makes creating the needed delete or update statement a snap.
I am in the process of enhancing the functionality of an ASP.Net application that I inherited and today I needed to display a grid of related data below an entry form on a page. Some of the functionality was present on a different page following the style the original programmer implemented. A database function to return a Datasource did not exist within the data class so that was my first step. I found this great code below showing the basic syntax of binding a dataset to a datagrid in ASP.Net which was helpful.
Back in the days when I was working with Sybase there was a function I found and used often to search for keywords in database code areas called sp_grep. You could pass a keyword to the stored procedure and it would return all objects that contained code with the keyword present.
This week I had the need to run Grep on a SQL Server database that we have taken over the maintenance of. I found this very useful stored procedure called sp_search_code by Narayana Vyas Kondreddi that performed the needed search.
I had the need to add hyperlinks to an asp.net server bulletlist today and found some very good examples online including the following example. This example defines a datasetdatasource as an xml file and them loads the values of the xml file into the bulletlist with hyperlinks included. Easy implementation and clear separation of the control and the data to be displayed by the control.