Quick Tip: Order By 1 Desc(mattberseth.com)

submitted by mberseth(1385) 4 years, 11 months ago

Did you know that instead of specifying the name or column alias in a SQL Server Order By expression you can optionally use an integer representing the position of the column name or alias within the select list you want to sort by ... read more...

add a comment |category: Tips & Tricks |Views: 42

tags: SQL mattberseth Database Tips another

7 simple steps to ajax-enable your ASP GridView(mattberseth.com)

submitted by mberseth(1385) 4 years, 11 months ago

I recently used the AJAX.NET framework in a project and I was impressed with how easy it was to implement and how much it improved the usability of our pages. Our project had quite a few advanced search pages where users can enter in a number of different filters and then hit the search button (usually iteratively - filter/search; filter/search; etc...). Before the Ajax framework and Ajax Control Toolkit were applied to the pages, each time the user would tweak a filter or request a different column sort, the complete page would refresh. After adding Ajax to the pages, just the GridView is re-rendered giving the user the much nicer web 2.0 user experience. Anyway, here are the steps I followed for adding these features to our project ... read more...

add a comment |category: AJAX |Views: 401

tags: GridView mattberseth AJAX ASP.NET another

Deploying config files to multiple environments - dev, stage, prod(mattberseth.com)

submitted by mberseth(1385) 5 years ago

A common problem most application developers face at one time or another is managing the deployment of the environment specific configuration elements their application depends on. Most often these elements include items like connection strings, file paths or other settings the application requires access to during runtime. I recently tackled this problem and came up with a solution that seems to work pretty well (we have been using it for the past 4 months without any issues) and fits in great with our automated build enviornment. read more...

add a comment |category: Other |Views: 56

tags: mattberseth MSBuild another

Ajax.Net Example: Using an UpdatePanelAnimationExtender to animate ...(mattberseth.com)

submitted by mberseth(1385) 5 years ago

I recently was working on an Asp.Net project that contained quite a few search pages. These pages all followed a similar structured pattern where the user had a set of fields they could filter on by typing in values and pressing the search button. The results were displayed in a GridView where the user could sort by clicking on column headers, export the results to excel, etc... To help improve user experience, we placed each of the GridViews in an asp UpdatePanel so while the user refined the search (sorting, adding or removing additional filters), only the GridView would be refreshed and not the entire page. Additionally, we wanted to add a few standard UI cues (disabling the Search button, fading out the GridView, and placing a progress indicator over the GridView) letting the user know an operation was currently in progress. read more...

add a comment |category: AJAX |Views: 3376

tags: UpdatePanelAnimationExtender mattberseth AJAX GridView another

Part II: Simple example of shading zip-code boundaries using Virtual E(mattberseth.com)

submitted by mberseth(1385) 5 years ago

In the original article, I showed an example of plotting zip-code boundaries using Microsoft Virtual Earth and Ajax.Net. I received some feedback from John (SoulSolutions) suggesting that the transmission of latitude and longitude points could be optimized by using googles compression algorithm (described here) which exploits that fact that lat/lons can benefit from compression when there is little difference between adjacent lat/longs within a given sequence. I thought this was an interesting suggestion so I updated the example to include this compression algorithm. read more...

add a comment |category: AJAX |Views: 41

tags: mattberseth AJAX ASP.NET another

Simple .Net Reflection Utility Class(mattberseth.com)

submitted by mberseth(1385) 5 years ago

I find that at least once in a project, I am digging into the System.Reflection msdn help page trying to identify what method calls and BindingFlags I need to make to lookup a field, property or method on an object and invoke it. The last time I did this; I took the code and moved it into a class. read more...

add a comment |category: C# |Views: 50

tags: another

Export GridView to Excel(mattberseth.com)

submitted by mberseth(1385) 5 years ago

I thought this sounded like a pretty standard requirement so I figured there would be a nice snippet on msdn or in an msdn publication describing the official Microsoft solution. I couldn’t find that, or any other approach that I was happy with. I ran across a few sites that looked promising, but didn’t quite meet my requirements – I had to either override a page level method and do nothing or else turn off event validation. It also generally appeared that the people using these solutions were also running into a variety of issues with grids that allow sorting and paging - all of the grids I am working with allow both. read more...

3 comments |category: ASP.NET |Views: 1223

tags: mattberseth GridView another

Plotting Zip-Code Boundaries using Ajax.Net and Microsoft Virtual Eart(mattberseth.com)

submitted by mberseth(1385) 5 years ago

During a recent project, I had the opportunity to play around with the Virtual Earth Map Control from Microsoft (http://dev.live.com/virtualearth/sdk/). The goal of the project was to display zip codes by outlining its boundary. In the end we decided to go a different route, but I thought I would share the prototype (~200 lines of code including markup). read more...

add a comment |category: AJAX |Views: 102

tags: mattberseth AJAX another