Avoiding The Database Deployment Nightmare(blog.reamped.net)

submitted by kayos(890) 2 years, 11 months ago

So, I have written before about how to put your database into version control using database projects in Visual Studio. Even while having the scripts in the solution, there can be times when you can't exactly remember what you changed and needs to go out with your project deployment to the production database. Deploying files is easy because of tools like WinMerge, however deploying things to a database can get quite complicated. You could script both schemas and use WinMerge to see the differences between the development database and the production database. But even doing that, you will still have to write a custom script to get the production database schema up to date. read more...

add a comment |category: Database |Views: 15

tags: SQLServer software Database SQL another

How To: Clean Up ASP.NET JavaScript Tags(blog.reamped.net)

submitted by kayos(890) 3 years ago

In April of '08, I wrote a post about cleaning up the ASP.NET head tag using control adapters. I've got some great feedback from it, and I'm glad that I'm not the only one that is horrified when looking at the source of an ASP.NET rendered web page. From the comments of that article I was recently asked how to clean up JavaScript tags. read more...

add a comment |category: ASP.NET |Views: 21

tags: JavaScript ASP.NET another

The HttpWebRequest and Using Client Certificates(blog.reamped.net)

submitted by kayos(890) 3 years ago

So you may have found yourself in a similar situation, needing to make a TCP/IP request to a 3rd party API possibly using SSL. Well, that is a quite simple task. It can however, be complicated if this 3rd party requires the use of certificates for communication to its API server. read more...

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

tags: csharp ASP.NET C# another

Finding Text in SQL Server Stored Procedures(blog.reamped.net)

submitted by kayos(890) 3 years, 1 month ago

So, I'm sure you have been met with a similar scenario during development. You know the one that you have to rename a column or even drop a column in the database. This can be quite annoying if you are doing stored procedure based data access for your application. read more...

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

tags: SQLServer TipsAndTricks SQL Database Tips another

SQL Server Side Paging With A Validated Dynamic Order By(blog.reamped.net)

submitted by kayos(890) 3 years, 5 months ago

So this is what it has come to anymore. Everyone is all about server side paging via SQL Server. As well they should be! It is so much faster and more efficient than having ADO or ADO.NET bring back a ton of records and then chop it to page it. However, there has always been some problems when trying to accomplish this task, especially using a SQL database that is pre 2005. read more...

add a comment |category: Database |Views: 55

tags: SQLServer SQL Database another

InfoPanel v1.0 - The site wide messaging system control(blog.reamped.net)

submitted by kayos(890) 3 years, 5 months ago

If you have read any of my previous posts on site wide user notification patterns and controls, then you may know where this is going. I have compiled a server control to bring this functionality to the fingertips of my fellow ASP.NET developers! read more...

add a comment |category: ASP.NET |Views: 31

tags: jQuery ASP.NET AJAX another

The Dummy Provider: Testing membership and roles(jeffgaroutte.com)

submitted by kayos(890) 3 years, 6 months ago

Asp.net has a wonderful system built in for handling user accounts and roles. The administration interface is encapsulated in a separate web site that can be accessed from within Visual Studio but it is difficult to integrate into the site. This often leads to building a new user administration area in each site. The problem I have with this is going into the data store and deleting the incomplete test data and not having "known good" data for testing. read more...

add a comment |category: ASP.NET |Views: 35

tags: Membership providers C# ASP.NET another

The private access modifier can do that?(blog.reamped.net)

submitted by kayos(890) 3 years, 7 months ago

If you look up accessibility levels on the MSDN web site, it will tell you that the accessibility of the private access modifier is limited to the containing type. I ran into an instance that showed me the direct meaning of this statement. read more...

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

tags: Tips C# another

ASP.NET Ajax, JQuery(blog.reamped.net)

submitted by kayos(890) 3 years, 8 months ago

A little while back I came across a great post on how to use JQuery to do more efficient client side paging by Dave Ward. The sample shows you how to use JQuery to do Ajax callbacks for client side paging using a grid template. After downloading the demo and parsing through it all, I found a lot of things I really liked and even came across a little gotchya with the way ASP.NET serializes dates in JSON. read more...

add a comment |category: AJAX |Views: 56

tags: JSON jQuery AJAX ASP.NET another

Updating Only Changed Rows in the GridView Control(gridviewguy.com)

submitted by kayos(890) 3 years, 8 months ago

Matt Berseth wrote a very interesting article on “Bulk Inserting Data Using the ListView Control". The idea is to give the user an Excel like interface where they can edit the rows with custom data and finally click the update button to persist the data in the database. Matt’s solution was great but lacks a very important detail. There was no way to know what rows were changed by the user. Matt took the road to update all the rows whether they were changed or not. In this article we are going to take a look at an alternative method of updating only the changed rows. read more...

add a comment |category: AJAX |Views: 96

tags: GridView ASP.NET AJAX another

LINQ Distinct, a DataTable and the IEqualityComparer<T>(blog.reamped.net)

submitted by kayos(890) 3 years, 8 months ago

In a recent situation I was trying to pull some aggregates out of a DataTable using LINQ. I needed to get the rows of the DataTable with a Distinct clause, but my aggregates would be on other columns of the row. read more...

add a comment |category: Linq |Views: 263

tags: LINQ C# another

Strongly Typed Dynamic User Controls(blog.reamped.net)

submitted by kayos(890) 3 years, 11 months ago

A short way to display and consume strongly typed user controls. read more...

add a comment |category: ASP.NET |Views: 35

tags: AJAX ASP.NET Controls C# Tips another

Using Database Projects for Visual Studio(blog.reamped.net)

submitted by kayos(890) 4 years ago

Do you use database projects in Visual Studio? If not, then now is a good time to start. It is the best way I have found to source control my databases without actually sticking the database file itself in the repository. read more...

add a comment |category: Database |Views: 34

tags: VisualStudio SQL Database another

Why VisualSVN 1.4 Is So Great(blog.reamped.net)

submitted by kayos(890) 4 years, 1 month ago

So after the installation of VisualSVN 1.4, I don't think I'll ever look back. Finally a version of Visual Studio source control integration to make me leave the realms of Visual Source Safe forever. read more...

add a comment |category: Visual Studio |Views: 14

tags: VisualStudio another

Using The Event Model: Throwing and Handling Custom Events(blog.reamped.net)

submitted by kayos(890) 4 years, 1 month ago

If you haven't tried using the event model in .NET you don't know what you're missing. If this is the case, then I'm glad you're here. Events are a very nice way to add flexibility to your projects. read more...

add a comment |category: ASP.NET |Views: 7

tags: ASP.NET another

Clean Up ASP.NETs Head Tag With ControlAdapters(blog.reamped.net)

submitted by kayos(890) 4 years, 1 month ago

Ok, if you're anything like me you absolutely gag when you see the rendered content of the ASP.NET head tag. read more...

add a comment |category: ASP.NET |Views: 16

tags: ASP.NET another