using …

Pure C#

Archive for January, 2009

How to save data from a DataSet into a T-SQL table

Posted by esersahin on 30/01/2009


http://www.codeproject.com/KB/database/Load_DataSet_In_SQL_Table.aspx

Posted in DataReader, DataSet, DataTable, XML | Leave a Comment »

Convert DataReader to Dataset (C#)

Posted by esersahin on 30/01/2009


http://netindonesia.net/blogs/rahmat.faisal/pages/10093.aspx

Posted in DataReader, DataSet, DataTable | Leave a Comment »

DataTable Relational Operators in C# – DIFFERENCE Method

Posted by esersahin on 30/01/2009


http://weblogs.sqlteam.com/davidm/archive/2004/01/19/739.aspx

Posted in DataTable | Leave a Comment »

Highlight the active textbox in ASP.NET Web forms

Posted by esersahin on 22/01/2009


http://www.dotnet2themax.com/showcontent.aspx?id=00fa0fd6-4970-4ddf-aa6b-335c3d1259be

Posted in Asp.Net, Css, TextBox, Web Forms | Leave a Comment »

Common Solutions for T-SQL Problems

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples

Posted in Transact-SQL | Leave a Comment »

Find the TOP n Longest Running Procedures (or Queries), Ordered by Total Impact on Server

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=LongRunningProcs&referringTitle=Home

Posted in Stored Procedure, Transact-SQL | Leave a Comment »

How to Find Rows of Data Between Two Dates

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=FindDataBetweenDates&referringTitle=Home

Posted in Between, Date, Transact-SQL | Leave a Comment »

Find and/or Delete Duplicate Rows

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DuplicateRows&referringTitle=Home

Posted in SQL, Sql Server, Transact-SQL | Leave a Comment »

Exploring Recursive Common Table Expressions (CTE)

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=RecursiveCTE&referringTitle=Home

Posted in Common Table Expressions, Recursive | Leave a Comment »

Lock a Stored Procedure for Single Use Only

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=GetAppLock&referringTitle=Home

Posted in Lock, Stored Procedure, Transact-SQL | Leave a Comment »