Hi,
This post will show you how to save/load images to/from a database. This approach lets you do it without having to save the image on to disk. On a real hosting computer, you probably will not have write permissions. Therefore, it is sometimes vital to do image saving/loading on the fly.
In this post we will [...]
Archive for the ‘SQL SERVER’ Category
Reading and writing images from/to database
Posted in ADO.NET, ASP.NET, C#, SQL SERVER, tagged ASP.NET, bind, Byte, C#, database, DataReader, DB, express, FILE, from, image, ImageUrl, Load, picture, read, Save, SQL, SQL SERVER, stream, System.Drawing, System.Web, System.Web.UI, System.Web.UI.WebControls, to, url, write on October 17, 2008 | 6 Comments »
Speed up Linq to Sql with compiled queries
Posted in C#, SQL SERVER, tagged C#, Compile, Compiled Query, Linq, Linq to sql, Performance, Query, SQL on August 15, 2008 | 2 Comments »
There is no doubt that tehre are some drawbacks to Linq to Sql. One of them is that the Sql statement is built dynamically so it is needed to be parsed and compiled each time you run it. Fortunately .Net 3.5 has a solution for this problem. System.Data.Linq namespace includes a class named CompiledQuery which [...]
Implementing a 3-Tier architecture with C# – Part 3
Posted in ADO.NET, ASP.NET, Architecture, C#, SQL SERVER, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, FirstReturnedRecord, IDENTITY, N-TIER, NTier, PAGING, ROW_NUMBER, SCOPE_IDENTITY, SQL SERVER, SQL SERVER 2005, StoredProcedure, TIER, UpdateRowSource on July 15, 2008 | Leave a Comment »
The Fill method we have developed so far, executes the Select command on the underlaying server and picks up RowCount records from startRowIndex position. For example, if Select * from Person returnS 20 rows, and startRowIndex is 0, only the first RowCount records will be fetched. This means that the complete result set will be [...]
