Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Friday, May 09, 2008

Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
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 > SQL Server
Search:
What's New - What's Hot
Listings for Administration Administration (7)
Listings for Articles Articles (53)
More Categories for Bugs and Fixes Bugs and Fixes (101)
Listings for Data Provider Data Provider (6)
Listings for Encryption Encryption (1)
Listings for Errors Errors (28)
Listings for Import & Export Import & Export (3)
Listings for Information Information (41)
Listings for Installation Installation (3)
Listings for Security & Login Security & Login (3)
Listings for SQL Mail SQL Mail (2)
Listings for SQL Server 2005 SQL Server 2005 (8)
Listings for SQLXML SQLXML (6)
Listings for Stored Procedure Stored Procedure (6)
Listings for Virtual Instance Virtual Instance (0)
Listings for Windows XP Windows XP (2)

How To Use SQL Server Reporting Services        
Total Hits: 1  |  Today: 0 Author: Bean Software       Rating:  
Read Reviews | Write Review |              Your Rating: 

Business development often requires analysis and data mining. Determining trends with which Customers and other stake holders deal with a business are of sole importance to the business. In fact, helping a businessman to grow his business has contributed a lot in rapid growth of IT industry. Microsoft SQL Server Reporting services provide a solution to those tasked in finding business trends. Briefly speaking:
1. Reporting services lets you create rich reports and format them based on your...

How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET        
Total Hits: 40  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored procedure that you will create exists in the database. If the stored procedure does not exist, the code creates a stored procedure that takes one parameter to search the Authors table based on the last name and returns the matching rows and numb...

HOW TO: Configure a .NET-Connected Application and SQL Server to Use an Alternate Port Number for Network Communications        
Total Hits: 20  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |              Your Rating: 

This step-by-step article describes how to configure a .NET-connected application and a computer running Microsoft SQL Server to use an alternate port for network communications.

Many recent security breeches have used applications and databases that were configured to use their default port numbers. For example, a worm that searches for vulnerable database servers on the Internet might examine only TCP Port 1433. By default, SQL Server uses this port number....

How to specify fully qualified element names in XPath queries by using Visual C++ .NET or Visual C++ 2005        
Total Hits: 13  |  Today: 1 Author: Microsoft       Rating:  
Read Reviews | Write Review |              Your Rating: 

The step-by-step article describes how to specify fully-qualified element names in the NamespacePrefix:ElementName format to select nodes in an XmlDocument object....

How to use SQL Sitemap provider        
Total Hits: 34  |  Today: 0 Author: toral.gohil       Rating:  
Read Reviews | Write Review |              Your Rating: 

This is the sample of how to use the sql sitemap provider. This will give overview of security navigation framework....

How to use SQL Sitemap provider        
Total Hits: 46  |  Today: 1 Author: toral.gohil       Rating:  
Read Reviews | Write Review |              Your Rating: 

This is the sample of how to use the sql sitemap provider. This will give overview of security navigation framework....

HOW TO: Configure SQL Server to Store ASP.NET Session State        
Total Hits: 33  |  Today: 1 Author: Microsoft       Rating:  
Read Reviews | Write Review |              Your Rating: 

This step-by-step article demonstrates how to configure Microsoft SQL Server for ASP.NET SQL Server mode session state management....

Building Multi-Tier Web Application in .NET 3.5 Framework Using LINQ to SQL        
Total Hits: 101  |  Today: 0 Author: John Prabhu       Rating:  
Read Reviews | Write Review |              Your Rating: 

In the new version (.NET framework 3.5), Microsoft have provided a way to define the queries in the programming language (C# 3.0, VB.NET 9.0) using LINQ which is called Language-Integrated query. It's basically a programming concept to query the data against the following :

* database (LINQ to SQL),
* dataset (LINQ to Dataset),
* xml (LINQ to XML) and
* objects (LINK to Entities)....

Storing Images in MySQL using ASP.NET        
Total Hits: 114  |  Today: 2 Author: Fahad Azeem       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article describes how to upload images to a web server using ASP.NET. All the data is stored in a MySQL database. This article is targeted towards a little more intermediate programmer who has some understanding of ASP.NET with C#, SQL and relational databases. First section describes how to set up the database and second part describes how to code uploading the files and how to view them back as a gallery. Code has been tested with JPEG and GIF files....

ASP.NET 2.0 Custom SQL Server ResourceProvider        
Total Hits: 44  |  Today: 0 Author: Jeff Modzel       Rating:  
Read Reviews | Write Review |              Your Rating: 

I was working on a medium-sized ASP.NET 2.0 web application that had a requirement for internationalization/globalization. The default method for internationalization in ASP.NET 2.0 uses XML .resx resource files to store language specific resources. Generally speaking, there is a one-to-many relationship between .aspx files and .resx files. Every new .aspx file will require one or more .resx files. The development and maintenance of the .resx files will become an issue as a web application grows...

Copying bulk data into SQL Server        
Total Hits: 237  |  Today: 0 Author: Bipin Joshi       Rating:  
Read Reviews | Write Review |              Your Rating: 

Few weeks ago I (Bipin Joshi) released BinaryIntellect Bulk Copy Tool. Many visitors asked me how the tool is developed and hence I decided to write this article. Though the tool uses many other aspects of ADO.NET 2.0 the core thing is the new bulk copy class. Some applications require inserting huge data to SQL server databases. In such case executing independent INSERT queries is not an efficient way. SQL Server data provider allows you to perform such inserts using SqlBulkCopy class. This art...

Q10275 - INFO: SQL Injection        
Total Hits: 92  |  Today: 0 Author: kb.webecs.com       Rating:  
Read Reviews | Write Review |              Your Rating: 

SQL injection is a technique used to take advantage of non-validated input vulnerabilities to pass SQL commands through a Web application for execution by a backend database. Attackers take advantage of the fact that programmers often chain together SQL commands with user-provided parameters, and can therefore embed SQL commands inside these parameters. The result is that the attacker can execute arbitrary SQL queries and/or commands on the backend database server through the Web application....



DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net