Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > C-Sharp > Database
Search:
What's New - What's Hot
Listings for DataSet Object DataSet Object (51)
Listings for SQL Server SQL Server (21)


How to: Add Rows to a DataTable  Version: 0.00     Price: $0.00  
Total Hits: 119  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

To add new records into a dataset, a new data row must be created and added to the DataRow collection (Rows) of a DataTable in the dataset. The following procedures show how to create a new row and insert it into a DataTable. Examples are provided for both typed and untyped datasets....

How to manipulate hierarchical information in flat relational database tables (optionally industrial strength)     
Total Hits: 440  |  Today: 0Author: Akshay Srinivasan2.      Rating:  
Read Reviews | Write Review |  Your Rating: 

A simple table in a relational database is the employees table. This has an employee ID and a reports to ID which is an employee ID. The normal way to fill your tree with this hierarchical information is to query for the root nodes i.e. nodes with no parents in this case null in reports to. Then subsequently query the table for all children of the node i.e. reports to ID equals root employee id. Keep doing this until you come to leaf nodes with empty results. I will describe a better technique t...

HOW TO: Use Base Classes to Reduce Code Forking with Managed Providers in Visual C# .NET (Q313304)     
Total Hits: 437  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

Use this step-by-step guide to learn how to use base classes to reduce code forking with managed providers....

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and C++ (Q317044)     
Total Hits: 602  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table....

HOW TO: Use the ExecuteXmlReader Method of the SqlCommand Class in Visual C# .NET (Q316701)      
Total Hits: 576  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can use this method to run server-side for XML queries and to run queries that return well-formed XML data as text....

HOW TO: Update a SQL Server Database by Using the SqlDataAdapter Object in Visual C++ .NET (Q308510)      
Total Hits: 786  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides Visual C++ .NET code samples to demonstrate how the SqlDataAdapter object can be used to update a SQL Server database with data modifications executed on a DataSet object that is populated with data from a table in the database....

HOW TO: Use the ODBC .NET Managed Provider in Visual C# .NET and Connection Strings (Q310988)      
Total Hits: 598  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to use the ODBC .NET Managed Provider in Visual C# .NET. This article also includes samples connection strings that you can use to access your data....

HOW TO: Update Server Data Through a Web Service Using ADO .NET and Visual C# .NET (Q310143)      
Total Hits: 602  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the returned DataSet in a DataGrid control so that you can update that data and send the updates back to the server....

HOW TO: Execute SQL Parameterized Stored Procedures Using the ODBC .NET Provider and Visual C# .NET (Q310130)      
Total Hits: 517  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual C# .NET....

HOW TO: Update a SQL Server Database Using the SqlDataAdapter Object in Visual C# .NET (Q308507)      
Total Hits: 961  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article contains Microsoft Visual C# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database....

HOW TO: Add Static Items and Results from Data Binding to a DropDownList Control Using Visual C# .NET (Q312489)      
Total Hits: 541  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to add static items and data-bound items to a DropDownList control....

HOW TO: Insert Text String into SQL Table with Embedded Single Quotes By Using ASP.NET and Visual C# .NET (Q311021)      
Total Hits: 973  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server) and provides a Microsoft Access sample that uses the Microsoft OLE DB Provider and related data access classes....

HOW TO: Copy DataRows Between DataTables Using Visual C# .NET (Q308909)      
Total Hits: 481  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class....

HOW TO: Create a SQL Server Database Programmatically Using ADO.NET and Visual C# .NET (Q307283)      
Total Hits: 554  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article shows you how to create a Microsoft SQL Server database by using ADO.NET and Visual C# .NET because programmers often need to create Databases programmatically....

HOW TO: Create a SQL Server Database Programmatically Using ADO .NET and Visual C++ .NET (Q307402)      
Total Hits: 514  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual C++ .NET to programmatically create a Microsoft SQL Server database....

HOW TO: Execute SQL Parameterized Stored Procedures By Using the ODBC .NET Provider and Visual C++ .NET (Q310142)     
Total Hits: 302  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to call a parameterized Microsoft SQL Server stored procedure using the Open Database Connectivity (ODBC) .NET managed provider and Microsoft Visual C++ .NET....

HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual J# .NET     
Total Hits: 197  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual J# .NET to read and write binary large object (BLOB) fields....

HOW TO: Update Server Data Through a Web Service by Using ADO.NET and Visual J# .NET     
Total Hits: 449  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to use an Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the returned DataSet in a DataGrid control so that you can update that data and send the updates back to the server....

HOW TO: Update a SQL Server Database by Using the SqlDataAdapter Object in Visual J# .NET     
Total Hits: 279  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article contains Microsoft Visual J# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database....

HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual C# .NET (Q320897)     
Total Hits: 1234  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article explains how to retrieve the identity value when you add a record into a SQL Server table with an identity field....



Disclaimer - Privacy
© 2002-2017 DevASP.net