Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Example of Image Upload
- Here we are uploading images in File System and storing path in the database. http://www.hanusoftware.comCode (ImageUpload.aspx.cs) :-private void Button1_Click(object sender, System.EventArgs e) { // Here I am uploading images in Images folder of C drive.int intResult=0;string strPath = @"c:Images"+Path.GetFileName(File1.PostedFile.FileName);SqlConnection con = new SqlConnection("server=.;uid=sa;database=pubs;pwd=");SqlCommand com = new SqlCommand("Insert into Category(name,imagepath) values(@name,@imagepath)",con); com.Parameters.Add("@name",TextBox1.Text); com.Parameters.Add("@imagepath",strPath); con.Open; intResult = Convert.ToInt32(com.ExecuteNonQuery); if(intResult...
- Tags: hanuseo@..., strPath, SqlConnection, SqlCommand
- Discussion threads 2007-09-20
- Ensure object cleanup in your .NET applications
- Recognizing the need to call and use the dispose method is essential to developing applications that perform properly. This article outlines the steps you should follow to ensure appropriate object cleanup in a .NET application. Garbage collection in the Microsoft .NET common language runtime CLR environment absolves...
- Tags: Microsoft .NET, Databases, Middleware, Tony Patton, .NET, Programming languages, SqlCommand, SqlConnection, SqlDataReader, .NET Newsletter, Method, TechRepublic Inc., Database, Connection, Object, Storage, Application Servers, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-20
- Storing database connection settings in .NET
- .NET database providers make it necessary to specify database connection information, but it's the developer's discretion to decide where to store this information. Tony Patton explores the various factors that may influence your decision. One of the best aspects of the .NET...
- Tags: Microsoft .NET, XML, Storage, Databases, Tony Patton, .NET, Programming languages, sConn, SqlConnection, database, .NET Newsletter, Registry, TechRepublic Inc., Problem, Server, Microsoft.Win32, regKey, ToString, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-13
- 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
- Which dataset should you choose?
- The choice between untyped and typed datasets rests in the hands of the developer. Examine the differences between the two. I've recently noticed some confusion among coworkers and clients regarding dataset options. This confusion stems from the fact that a dataset may or may not...
- Tags: Tony Patton, .NET, Programming languages, cntString, strSQL, dataset, Console.WriteLine, SqlConnection, Nothing, developer, .NET Newsletter, Microsoft Visual Studio, TechRepublic Inc., Database, Microsoft Visual Studio.Net, XML Schema, Class, Column, Dataset1, Microsoft Development Tools, XML, Development Tools, Software Development, Software/Web Development, Web Development
- Technical articles 2005-06-28
- Ensure object cleanup in your .NET applications
- Garbage collection in the Microsoft .NETcommon language runtime CLR environment absolves developers fromtracking memory usage and knowing when to free memory. However,developers still need to stay abreast of an object's lifetime, thusbeing aware of when the object is no longer used. This articleoutlines the steps you should follow to ensure...
- Tags: Microsoft .NET, SqlCommand, SqlConnection, SqlDataReader, Tony Patton
- Technical articles 2005-07-20
- Storing database connection settings in .NET
- One of the best aspects of the .NET Frameworkis ADO.NET and data providers that negate the need for ODBCconnections. Data providers offer a liaison between your code andthe database. They also provide better performance, as well aseasier setup no one misses the process of installing andconfiguring an ODBC driver. ...
- Tags: database, Dim sConn, Microsoft .NET, sConn, SqlConnection, Tony Patton
- Technical articles 2005-07-13
- Which dataset should you choose?
- I've recently noticed some confusion amongcoworkers and clients regarding dataset options. This confusionstems from the fact that a dataset may or may not be typed. Thedeveloper makes the choice, which affects how the dataset isutilized in the code. In this article, I examine dataset types tofurther clarify their differences. ...
- Tags: Dim cntString, dataset, cntString, strSQL, Tony Patton, Nothing, developer, SqlConnection
- Technical articles 2005-06-28
- Get IT Done: How connection pooling can boost ADO.NET performance
- I recently looked at an ASP.NET application where performance was acceptable up to a certain point, but then decreased rapidly. After a few hundred users, the application hit the wall and performance dropped, despite plenty of network bandwidth and server processing power. To get past this bottleneck, I tuned the...
- Tags: Get IT Done, Lark Group, Inc., Microsoft ADO.NET, performance, SqlConnection
- Technical articles 2003-02-19
Additional Resources
- student
- I want to know how to connect Visual Basic 2005 Express Edition with mySqlI got it working with thishttp://dev.mysql.com/downloads/connector/net/5.0.htmlOnly had a basic look but it appeared to be okay.esssentially instead of using sqlconnection you use mysqlconnection...
- Tags: geofarr@...
- Discussion threads 2007-09-07
- 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
- Protect database resources with clean .NET code
- In a previous article, I wrote about the importance of observing certain rules for object cleanup in .NET code. One of theworst examples I've experienced is with database interaction. I once fixed an application whoseperformance slowly degraded after a restart as databaseconnections were consumed. The problem lay in the fact...
- Tags: database, database connection, Microsoft .NET, Tony Patton
- Technical articles 2005-07-21
- Protect database resources with clean .NET code
- Developers are keen to open and utilize a database connection, but it is common to overlook the process of closing and returning the resources utilized to the system. Tony Patton examines how this can be accomplished. In a previous article, I wrote about the importance of observing...
- Tags: Microsoft .NET Framework, Microsoft .NET, Storage, Databases, Tony Patton, .NET, Middleware, database connection, database, garbage collector, .NET Newsletter, Method, TechRepublic Inc., Data, Resource, Object, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-21
- 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
- Secure your database interaction with SSL
- The details of securing the communications between a client and Web application are often covered, but what about the communication between the application and database server? Here's a look at securing the database interaction with Secure Sockets Layer SSL. The beginning of 2005 started on a bad note, as...
- Tags: Microsoft SQL Server, SSL, Authentication/Encryption, Databases, Tony Patton, SSL/TLS, Network security, SECURITY, Enterprise software, database, InstantSSL, Microsoft SQL Server 2000, .NET Newsletter, TechRepublic Inc., Microsoft Windows 2000, Communication, Server, Networking, Software, Data Management
- Technical articles 2005-07-21
- Implementing SQL Server transactions with ADO.NET
- A transaction is a group of operations combined into a logical unit of work. Learn how to use transactions within the .NET Framework. ADO.NET provides everything you need to work with back-end data, which can be as simple as reading a set of...
- Tags: Microsoft ADO.NET, Databases, Tony Patton, .NET, System.Data.SqlClient namespace, banking, IsolationLevel property, SQL, server, .NET Newsletter, TechRepublic Inc., Transaction, Microsoft SQL Server, IsolationLevel, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-06-30
- VISTA and ,NET problems
- Urgent help requested -- VISTA and ,NET problems.I am having trouble getting applications to run on Vista Business that run fine on XP Pro. Vista comes up with one successive error after another. I support a group of Insurance Agents that like to buy the latest and greatest, then come...
- Tags: Microsoft Windows Vista (Longhorn), LuckyLeatherneck, Microsoft Windows Vista
- Discussion threads 2007-05-16
- 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
- ADO.NET database access made easy
- ADO.NET and ADO are quite different in many areas, such as connection classes, commands, and data readers. But don't get them confused. This introduction to ADO.NET should help set you off on the right foot.Although ADO.NET and ADO share some common concepts, they are different enough in many areas to...
- Tags: .NET, Databases, System.Data, Lamont Adams, Microsoft .NET Framework, System.Data.SqlTypes, System.Data.OleDb, System.Data.SqlClient, Microsoft ADO.NET, connection class, Microsoft SQL Server, OLE-DB data source, SqlClient, OLEDB, database
- Technical articles 2002-12-16
- Implementing SQL Server transactions with ADO.NET
- ADO.NET provides everything you need to workwith back-end data, which can be as simple as reading a set of datafrom one table to performing a transaction. A transaction allowsyou to group database operations to ensure that all the operationsare performed because, if one operation fails, the wholetransaction fails. Let's take...
- Tags: banking, Microsoft ADO.NET, server, SQL, Tony Patton
- Technical articles 2005-06-30
- << Previous
- page 1 of 1
- Next >>
