1 Resources for

executenonquery

Subscribe to this listing via:
RSS
Email

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

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
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
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

Efficient Data Retrieval: Take a look at how to optimize using Stored Procedures for efficient and secure data retrieval in the middle tier of your Web, Windows, mobile and Web services applications. Learn how to do crosstab queries for reporting that take seconds to execute instead of hours, exploiting sub-queries and taking advantage...; Tags: Microsoft ADO.NET, .Net, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Webcasts
ASP.NET (c#): My name is vatsal from baroda, gujarat,india.I have problem in ASP.Net , when i insert record in MSAccess through ASP.net , it display an error : you must use updateable queryI have pentiumIV pc & loading operating system is XP professionalcode is :private void insert_click{oledbconnection connection=("provider=");oledbCommand cmd= new oledbCommand("insert into...; Tags: Microsoft ASP.NET, studynsunil@..., programming, C#; Q&A 2006-04-18
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
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
Upload .xls file to SQL Server table w ASP.NET app: Here's what I have to do: 1. Allow user to locate a .xls file on their machine 2. Upload this .xls data into an existing table on a remote SQL Server I can pull the file from my local machine to another directory on the local machien, but...; Tags: chip@..., database, Dim strSQL, Label2.Text, local machine, Microsoft ASP.NET, Microsoft SQL Server, programming, server, software; Discussion threads 2005-08-09
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
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
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
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
Extend the reach of SQL Server with SQLXML classes in .NET: The term SQLXML is used to denote the XML features supported in SQL Server 2000 in .NET. These new XML features extend the reach of SQL Server, and their effects on the database developer are minimal. The classes in the Microsoft.Data.SqlXml namespace are referred to as the SQLXML-managed classes, and...; Tags: XML, Databases, .NET, server, SqlXmlParameter class, SqlXmlCommand class, Microsoft .NET, Microsoft SQL Server, S. Vikram, SqlXmlCommand, SqlXmlParameter, Stream ExecuteStream; Technical articles 2003-01-02
Application development with Microsoft .NET application blocks: Microsoft offers application blocks for the .NET Framework. Application blocks encapsulate certain key areas by adding a layer over the .NET Framework, and they aid in faster application development and promote certain best practices. Here, I will discuss two examples of application blocks: the Data Access application block and the...; Tags: .NET, Microsoft Corp., Microsoft .NET, S. Vikram, application development, application block, data access, Microsoft .NET Framework, Data Access Application Block, SqlHelper class; Technical articles 2003-01-16
sql server connection problem: i am using asp/vbscript to access an sql databaseresiding on another server. i get the following error :-------------------------------------Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect).]SQL Server does not exist or access denied. /checkid_index.asp, line 25 -----------------------------------given below is the code for checkid_index.asp----------------------------------dim conn,rs,strsqlSet conn=Server.CreateObject("ADODB.Connection") ...; Tags: fatsmm@..., IUSR_MACHINE, Microsoft IIS Server, Microsoft SQL Server, programming, server, SQL; Q&A 2005-03-10
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
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

<< Previous
page 1 of 1
Next >>

TechRepublic's VPN Policy: Your users need to access your network from another location. To help, you've set up a VPN to allow remote access. Here's a policy you can put in plac ...; Buy Now

Microsoft Outlook: Intermediate Skills: The Microsoft Outlook - Intermediate Skills presentation provides a preformatted presentation for training staff to use several timesaving and product ...; Buy Now