Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Applied reflection: Write 80 percent less access code when interacting with a database
- Databaseinteraction is old hat to enterprise application developers. If you are a .NET developer,chances are you have used the SqlParameter, SqlCommand, and SqlConnection classes. There is also a high probability thatyou have noticed how monotonous and time consuming it is to use these classesto implement data access. Microsoft solved some...
- Tags: Â Â Â Â Â Â Â, data access, Data Access Block, database, Database interaction, SqlParameter, Zach Smith
- Technical articles 2006-09-26
- C# checkbox INSERT record into SQL
- Would like a simple example of a webform in C# containing checkbox inserting Y/N into a SQL table.To make this short, let's assume you have the webform designed and laid out. Given this, we have a CheckBox control with an ID of chkYN and a SQL Table tblTest that...
- Tags: C#, programming, ptrTest, SQL, SqlParameter, vhansen86
- Q&A 2005-04-06
Additional Resources
- Utilize ADO.NET and C# to work with BLOB data
- Storing and retrieving data with MicrosoftSQL Server is a common task associated with most applications. On apast project, I was presented with a new twist on thisinteraction: large data types or BLOBs. The project entailedstoring and retrieving Microsoft Word documents and image files.This article covers the backend aspect of the...
- Tags: BLOB, Reading BLOB, Tony Patton, Reading BLOB data, FileStream, Microsoft ADO.NET, Microsoft SQL Server, C#, SqlDataReader
- Technical articles 2005-07-01
- Utilize ADO.NET and C# to work with BLOB data
- While working on a project that involved storing and retrieving data with SQL Server, Tony Patton encountered a new twist: dealing with BLOBs. Find out how he used ADO.NET to access and store BLOBs. Storing and retrieving data with Microsoft SQL Server is a common task associated with...
- Tags: Tony Patton, .NET Newsletter, FileStream, TechRepublic Inc., Database, Microsoft ADO.NET, Microsoft SQL Server, Data, Server, C#, BLOB, SqlDataReader, sConn, SqlConnection, SqlCommand, Databases, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-07-01
- Database Stored Procedures in .NET
- I am having a problem using .NET to implement a stored procedure for inserting a row into a database. FYI, I am using C# and SQL Server. None of the code examples in MSDN show the specific table that is being accessed. What parameter of what object do I set...
- Tags: .net, database, Microsoft .NET, M_a_r_k, programming, stored procedure
- Discussion threads 2005-11-15
- An introduction to ADO.NET concurrency
- ADO.NET is Microsoft’s new technology for working with data. One of the most trumpeted features of ADO.NET is the DataSet object, which is an object that stores data in an in-memory schema, complete with DataTable and DataRelation objects. The ability to store an entire schema in memory allows the DataSet...
- Tags: .NET, Databases, Microsoft development tools, Craig Utley, Dataset, concurrency, concurrency violation, optimistic concurrency, Microsoft ADO.NET
- Technical articles 2003-01-17
- Access SQL-based data with C# and ADO.NET
- ADO.NET is a framework of classes that allow you to accessdata and provide you with a direct way to get the necessary information foryour .NET applications. In this article, I discuss how you can access SQLServer-based data using C# and ADO.NET. I will use a simple C# application asan example.ConnectionsConnections...
- Tags: C#, CommandText, database, Irina Medvinskaya, Microsoft Access, Microsoft ADO.NET, Microsoft SQL Server, SQL, SqlCommand
- Technical articles 2006-07-18
- Manage application images with SQL Server
- Images are an integral aspect of every Web site; however, it can be headache to manage a site's images. Discover how you can improve this process by using a database such as SQL Server as a storage vehicle. Image files are a standard part of every ASP.NET application....
- Tags: Microsoft SQL Server, Databases, Tony Patton, .NET, Programming languages, System.IO namespace, server, image, database, .NET Newsletter, TechRepublic Inc., Identity Column, Storage, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-19
- Manage application images with SQL Server
- Image files are a standard part of every ASP.NETapplication. While most sites use Web server directories to store image files,another option is utilizing a database. The database provides a better approachto managing application image files. In this article, we examine using SQLServer 2000 to manage image files with ASP.NET via...
- Tags: database, image, Microsoft SQL Server, server, Tony Patton
- Technical articles 2005-07-19
- Shorten development time by using parameterized queries in ADO.NET
- Forsome time now stored procedures have been the preferred method of data accessfor enterprise application development. Stored procedures offer bettersecurity, better encapsulation, and can implement complex logic withoutcluttering up application code. However, they also come with disadvantages:Developershave a tendency to put business logic inside stored proceduresYoumust change development environments to...
- Tags: data access, Microsoft ADO.NET, Zach Smith
- Technical articles 2006-07-12
- Clean up your ADO.NET mess to ensure good application performance
- While much has been written about how easy ADO.NET makes it to access data from a variety of data sources, there are things to which you must pay attention to maintain good application performance. One of these is the proper termination and cleanup of ADO.NET objects to be certain that...
- Tags: .NET, Databases, Microsoft .NET Framework, Baseline Inc., Microsoft ADO.NET, garbage collection, database connection, database, Microsoft SQL Server
- Technical articles 2003-04-14
- << Previous
- page 1 of 1
- Next >>
