This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.
MSDN Magazine May 2008
View Complete Post
We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..
We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.
strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"
'get the new transaction_id out for just inserted alarm
strSqual = "select max(transaction_id) as transaction_id from trans"
set rst = getStaticRecordSet(strSqual)
I create table:
DataSet data=new DataSet();
DataTable myTable = new DataTable("NewTable");
DataColumn keys = new DataColumn; // create column keys = new DataColumn(); keys.DataType = System.Type.GetType("System.String"); keys.ColumnName = "PointID"; myTable.Columns.Add(keys); &nb
This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.
MSDN Magazine December 2009
In this month's column, Scott explores one-click database documentation, covers an API for pre- and post-conditions, takes a look at an interesting blog, and reviews the latest book about the ASP.NET MVC Framework.
MSDN Magazine November 2009
If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.
MSDN Magazine August 2009
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.
MSDN Magazine July 2009
In this installment we look at the Microsoft Chart Controls; Snippet Designer, a free, add-in for Visual Studio 2008 for creating and editing Code Snippets; refactoring SQL applications; and this month's favorite blog.
MSDN Magazine April 2009
This month: help writing SQL code, modeling your database with SubSonic, and a review of Visual Studio Team System: Better Software Development for Agile Teams.
MSDN Magazine Launch 2008
This month, more of the tools you need to get your job done.
MSDN Magazine December 2007
This month, find performance and memory bottlenecks, essential security reading, and more.
MSDN Magazine July 2007
MSDN Magazine May 2007
MSDN Magazine March 2007
This month obfuscating your code, persisting your data, and a good read on SQL Server 2005.
MSDN Magazine October 2006
Most data-driven Web sites are used as interfaces to collect, process, and summarize information. Reports that summarize the data can be presented to the user in a variety of formats-the most common way is to display the report directly in a Web page.
MSDN Magazine June 2006
From a developer's perspective, once a database's schema has been defined and the tables, stored procedures, and other database objects have been created, it can be forgotten, abstracted away into the data access layer of the application's architecture.
MSDN Magazine May 2006
Developers have a number of tools at their disposal, but which of these components do you really need to complete your project? Each month we'll analyze the latest software and books to see if they merit inclusion in your toolbox.
MSDN Magazine January 2006