Search
-
Articles
Home
Dev Articles
Sample Chapters
Add a Listing
Contact
Dev Articles
ASP.NET (338)
C# (300)
SQL Server (53)
VB.NET (195)
Web Services (2)
Search Directory
ASP.Net AJAX
AJAX ToolKit
.NET Namespaces
Applications
Articles & Samples
Assembly & Controls
Community
Developer Sites
Downloads
Hosting Services
Introduction
Knowledge Base
Sample Chapters
WebCasts
ASP.NET
Applications
Articles & Samples
ASP.Net Sites
Assembly & Controls
Downloads
Errors & Bugs
Introduction
Knowledge Base
Sample Chapters
WebCasts
VB.Net
Articles & Samples
Downloads
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
WebCasts
C-Sharp
Applications
Articles & Samples
C-Sharp Sites
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
WebCasts
SQL Server
Applications
Articles & Samples
SQL Sites
Downloads
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
WebCasts
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase
Home
>
Search
>
Knowledge Base
>
C-Sharp
>
Database
>
SQL Server
Search:
What's New
-
What's Hot
HOW TO: Update Server Data Through a Web Service by Using ADO.NET and Visual J# .NET
Total Hits: 434 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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 manipulate hierarchical information in flat relational database tables (optionally industrial strength)
Total Hits: 429 | Today: 0
Author:
Akshay Srinivasan2.
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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...
Reading and Writing images from SQL Server
Total Hits: 1071 | Today: 0
Author:
ra00l
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst Rating
Today you will learn to write images to SQL Server and then read and display them. In order to follow this tutorial, you will need to have SQL Server, Visual Studio .NET and .NET Framework installed. Ensure that the SQL Server instance is running....
HOW TO: Update a SQL Server Database by Using the SqlDataAdapter Object in Visual C++ .NET (Q308510)
Total Hits: 773 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Execute SQL Parameterized Stored Procedures Using the ODBC .NET Provider and Visual C# .NET (Q310130)
Total Hits: 504 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Copy DataRows Between DataTables Using Visual C# .NET (Q308909)
Total Hits: 470 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual C# .NET (Q320897)
Total Hits: 1203 | Today: 0
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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....
Use BindingManagerBase's EndCurrentEdit() before saving data via an Sql/OleDataAdapter
Total Hits: 680 | Today: 0
Author:
Michael G.
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst Rating
When a user places a cursor on a DataGrid cell in order to edit its contents, the grid is placed into an Edit mode state. If the user later clicks on a save button to commit the changes to a database, the changes may not be saved. This occurs because the DataGrid is still in Edit mode. For this reason, I recommend to all developers that the form, on which the DataGrid resides, be used to end the Edit mode session of the DataGrid. You can do this by issuing it a BindingManagerBase.EndCurrentEdit(...
HOW TO: Use Base Classes to Reduce Code Forking with Managed Providers in Visual C# .NET (Q313304)
Total Hits: 422 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: 592 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: 566 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Use the ODBC .NET Managed Provider in Visual C# .NET and Connection Strings (Q310988)
Total Hits: 589 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: 593 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Update a SQL Server Database Using the SqlDataAdapter Object in Visual C# .NET (Q308507)
Total Hits: 949 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: 527 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst Rating
This article demonstrates how to add static items and data-bound items to a DropDownList control....
HOW TO: Create a SQL Server Database Programmatically Using ADO .NET and Visual C++ .NET (Q307402)
Total Hits: 501 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: 290 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Update a SQL Server Database by Using the SqlDataAdapter Object in Visual J# .NET
Total Hits: 264 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Insert Text String into SQL Table with Embedded Single Quotes By Using ASP.NET and Visual C# .NET (Q311021)
Total Hits: 962 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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: Create a SQL Server Database Programmatically Using ADO.NET and Visual C# .NET (Q307283)
Total Hits: 541 | Today: 0
Author:
MSDN
Rating:
Read Reviews
|
Write Review
|
Your Rating:
Select One
5 Stars - Best Rating
4 Stars
3 Stars
2 Stars
1 Star - Worst 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....
Disclaimer
-
Privacy
© 2002-2012 DevASP.net