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
- 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
- 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
- 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
- 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
Additional Resources
- Vb.net
- What is the use of sqldataAdapter, sqlCommand,Dataset,DataView in vb.net?SQLDAtaAdapter allows you to create sql select, insert, update and delete command strings using a simple Wizard and can be called from VB code.A SQLCommand can be used to send ad hoc sql commands to a server to do other select, insert...
- Tags: a.jaya@..., programming, Microsoft Visual Basic.Net, SqlDataAdapter
- Q&A 2006-03-09
- Which dataset should you choose?
- DataReader is not DataSetThere is NO DataSet instance created in your first listing. Instead, SqlCommand.ExecuteReader returns an equivalent of forward-only, read-only server-side cursor which allows the client to quickly and efficiently process query results ONE ROW AT A TIME. This is fundamentally different from the purpose and characteristics of disconnected...
- Tags: DataReader, Dataset, pequod, programming
- Discussion threads 2005-06-28
- 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
- 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
- How to update many records in an Microsoft Access file?
- I have a huge table with many fields or columns and with more than 50,000 rows of data. But I have to insert data in one column-location with respect to another column-access randomly. By using action query I can update only one record at a time. Another solution I think...
- Tags: Databases, vamshna@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-03-29
- 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
- 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
- An introductory look at accessing data with ADO.NET DataSets
- One of the more startling moments that an ADO developer experiences when learning about ADO.NET comes when you realize that there’s no Recordset in the latter’s object hierarchy. Instead, ADO.NET makes use of a new and significantly more powerful component to provide the functionality provided by ADO’s Recordset: the DataSet....
- Tags: .NET, Databases, Microsoft ADO.NET, DataAdapter class, Lamont Adams, Dataset
- Technical articles 2003-01-23
- 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
- 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
- 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
- Handle errors in the data tier with SQL Server
- Handling exceptions in your .NET application code is a simple and straightforward process with try/catch code blocks, but you can monitor exceptions on the database tier as well. We examine error handling in your database code with SQL Server and T-SQL. Developers work hard to graciously handle exceptions so...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Databases, Tony Patton, .NET, server, RAISERROR statement, database, .NET Newsletter, Parameter, Microsoft .NET, Severity, Error, SQL Server Online Help, ROLLBACK TRANSACTION Statement, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2006-06-06
- update,delete,cancel buttons in datagrid using vb.net....
- can anybody plz tell m -whats the error in the code for update button in datagrid-where table name is "table1"its has fields "ID","Name","Age","Sex","Area"..in the code its giving error has::----------------------c:inetpubwwwrootsampleprj1WebForm1.aspx.vb(151): 'Textbox' is ambiguous, imported from the namespaces or types 'System.Web.UI.WebControls, System.Windows.Forms'.------------------------------The code is as followsProtected Sub datagrid1_UpdateCommand(ByVal source As Object, ByVal...
- Tags: preethams_venkatesh4@..., TextBox, CType
- Discussion threads 2007-06-06
- Secure your database interaction with SSL
- The beginning of 2005 started on a bad note, as I had to dealwith a stolen credit card. The issue led me to consider security inthe world of online transactions and data access. The details of securing the communicationsbetween a client and Web application are often covered,...
- Tags: Microsoft SQL Server, SSL, Tony Patton, database, InstantSSL, Microsoft SQL Server 2000
- Technical articles 2005-07-21
- << Previous
- page 1 of 1
- Next >>
