Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Simplify .NET SQL queries with the Data Access Application Block
- Although Microsoft's .NET Application Block is well documented, the practical tips and tricks that make it more usable on a day-to-day basis are harder to find. This article gathers some code that will make the Data Access Application Block easier to use in everyday .NET/SQL Server projects.Getting startedYou can download...
- Tags: .NET, Microsoft development tools, Databases, William Sempf MCP, CIBS, IWA, ExecuteNonQuery, ExecuteScalar method, ExecuteDataset, Data Access Application Block, ExecuteReader, SqlDataReader, SQL-query, DataSet dataSet, data access, ExecuteScalar, connString
- Technical articles 2003-07-15
Additional Resources
- Databind in Text box ASP.Net
- Dear all,I used the below code for databind for dropdown list:It is working fine.if(!IsPostBack) { ConnStr="Provider=msdaora;Data Source=inchndb;User Id=inchnasset;Password=inchn;"; Conn=new OleDbConnectionConnStr; cmd=new OleDbCommand("select primary_approver,Project from tbl_prj_mgr",Conn); Conn.Open; ddl_prj_mgr.DataSource=cmd.ExecuteReader; ddl_prj_mgr.DataTextField="primary_approver"; ddl_prj_mgr.DataValueField="project"; ddl_prj_mgr.DataBind; Conn.Close; }But now I want to get a string from database and to display in textbox.I used the below code it is not working.if(!IsPostBack) { ConnStr="Provider=msdaora;Data Source=inchndb;User Id=inchnasset;Password=inchn;"; Conn=new OleDbConnectionConnStr; cmd=new OleDbCommand("select empname from employee...
- Tags: ConnStr
- Q&A 2006-07-27
- 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
- MSDN Webcast: ADO.NET: Database Programming in .NET (Level 200)
- This webcast introduces database programming using ADO.NET, beginning with an overview of the ADO.NET architecture. The webcast explains about essential techniques such as executing stored procedures, server-side access using ExecuteReader and ExecuteScalar, client-side access using DataSet, and modifying a database with ExecuteNonquery and DataSets.
- Tags: Microsoft Developer Network, Webcast, Microsoft ADO.NET, .Net, Databases, Digital Media, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Consumer Electronics, Personal Technology
- Webcasts
- MSDN Webcast: Architecting .NET Solutions With C (Part 07 of 15): ADO.NET: Database Programming in .NET (Level 200)
- This session introduces database programming using ADO.NET, beginning with an overview of the ADO.NET architecture. Attendee of the webcast will learn about essential techniques such as executing stored procedures, server-side access using ExecuteReader and ExecuteScalar, client-side access using DataSet, and modifying a database with ExecuteNonquery and DataSets.
- Tags: Microsoft Developer Network, Webcast, Microsoft ADO.NET, C, .Net, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Webcasts
- how do i use rs!field in vb.net
- is there anyway i can use rs!field (ex: rs!customer_id) in vb.net.when i code it in VB.netdim str as stringset rs = new adodb.recordsetdim x as singlestr = "select customer_id from person"rs.open str, dbconn, 3,2x = rs!customer_id ''' this is error it says to many arguments..how do i solve it in...
- Tags: Console.Write, DataReader, Dataset, Dim strConn, Dim strSQL, Microsoft ADO.NET, OLEDBCommand, OleDbConnection, plr007, programming, ToString
- Q&A 2005-05-04
- Adding items to the subitems in a listview in VB 2005
- Hi thereBelow is some of my code in VB6 that use to add items to a listviewwith subitems:The listview is called lstvCustomers that gets data from a Access DBI know how to access data from access and I know how to add the datain the 1st columnmy problem is adding...
- Tags: Microsoft development tools, Programming languages, rieda@..., SubItems, listview, Dim strSQL, VB 2005, Microsoft Visual Basic
- Discussion threads 2007-05-10
- c# connection to odbc driver no output
- I'm using Visual Web Developer to develop an online system that can read from my db2 database. This code is in C# and after eliminating all the errors, there's no output.Could anybody tell me why? And how do I get it to display the output in my html website?Thank you...
- Tags: Programming languages, .NET, Databases, garfield_blossom@..., ODBC, connectionString, System.Data, C#
- Discussion threads 2007-03-26
- 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
- Using ODBC within a .NET application
- Tony Patton explains how you can set up and work with Open DataBase Connectivity ODBC technology in your .NET applications. He also highlights the ODBC .NET Data Provider, which provides ODBC access within .NET applications through the Microsoft.Data.Odbc namespace. One of the .NET Framework features often highlighted is...
- Tags: Tony Patton, .NET Newsletter, TechRepublic Inc., Application, ODBC, Microsoft .NET, Driver, Connection, .NET Data Provider, Driver Manager, SQL Statement, ToString, Databases, Enterprise Software, Software, Data Management
- Technical articles 2005-07-20
- Using ODBC within a .NET application
- One of the .NET Framework features oftenhighlighted is its new data access model, ADO.NET. Some of itsimprovements over its predecessors include scalability, speed, andits disconnected nature features. A .NET data provider is used toaccess a database system; a good example is the Oracle Data Provider for .NET. One problem is...
- Tags: Microsoft .NET, ODBC, Tony Patton
- Technical articles 2005-07-20
- 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
- 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
- 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
- ASP.Net Databind in DropDownList
- I tried to display the values from oracle table into a dropdownlist which is in asp.net.I used the below code to bind the data.When I debug,the page loads completely.But it doesn't show anything in the dropdownlist.How can I get the Oracle table values in asp.net dropdownlist.I used the below code:private...
- Tags: bsmgopal1984@..., ConnStr, database, DropDownList, Microsoft ASP.NET, programming, tblPay, tblTest, TBLTEST *It
- Q&A 2006-07-25
- 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
- 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
- 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
- << Previous
- page 1 of 1
- Next >>
