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 > Articles & Samples > SQL Server > Import & Export


Search:
What's New - What's Hot
Export data from SQL Server to Excel     
Total Hits: 213  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Exporting data from SQL Server to Excel seems like a reasonably simple request. I just need to write out a few reports for users on a regular basis, nothing too fancy, the same basic report with a few different parameters. What native SQL Server options are available to do so? Do I need to learn another tool or can I use some T-SQL commands? Does SQL Server 2005 offer any new options to enhance this process?...

Export Button Released     
Total Hits: 190  |  Today: 0Author: AzamSharp      Rating:  
Read Reviews | Write Review |  Your Rating: 

I know you loved my article about Exporting DataGrid to Excel and I am sure that you are going to love this even better. I spent the past 1 hour to develop a simple button control that can export Datagrid or TextBox into Excel format....

Extensive Study of GridView Export to Excel     
Total Hits: 360  |  Today: 0Author: AzamSharp      Rating:  
Read Reviews | Write Review |  Your Rating: 

Exporting GridView to Excel is a very common task which is performed in most of the web applications. There are various techniques of exporting the GridView to excel and it highly depends on the application scenario. In this article I will demonstrate some techniques that you will find useful....

Import Security event logs using Log parser and SQL Server     
Total Hits: 541  |  Today: 0Author: Muthusamy Anantha Kumar aka The MAK      Rating:  
Read Reviews | Write Review |  Your Rating: 

In order to satisfy the demands of General-Controls review by public auditors and regulatory agencies, companies should monitor the security events of every production system they have. This article illustrates how to use Microsoft Logparser 2.2, Job Scheduler and SQL Server database to monitor the event logs, and extract Monthly, Weekly Low security event reports from the SQL Server database....

Simple way to export SQL Server data to Text Files     
Total Hits: 247  |  Today: 0Author: Ken Simmons      Rating:  
Read Reviews | Write Review |  Your Rating: 

Since the transition from DTS to SSIS, I have found myself looking for alternative ways to do simple tasks such as exporting data from SQL Server into text files. SSIS is a far more powerful tool than DTS, but I generally try to stay away from it for simple operations. With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files....

Exporting GridView to Text Files     
Total Hits: 288  |  Today: 0Author: AzamSharp      Rating:  
Read Reviews | Write Review |  Your Rating: 

In one of my previous articles you saw how to export Datagrid to text files Datagrid Export to Excel, Text and Word Files. In this article we will see how we can export a GridView control to text files....

Peer Graph - Importing and Exporting a Database     
Total Hits: 186  |  Today: 0Author: Adrian_Moore.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft's Peer-to-Peer Graphing technology provides a stable, reliable, and robust infrastructure for Windows peer-to-peer applications to communicate. Peers use Peer Name Resolution Protocol (PNRP - a serverless DNS) to register and discover other peers within the graph. Graphs are the foundation for connecting peers, services, and resources within a peer network. A peer can be a user-interactive application, service, or resource. Graphing allows data to be passed between peers efficiently an...

Exporting a Dataset with multiple tables in separate sheets in an Excel file     
Total Hits: 466  |  Today: 0Author: jain.ashish21      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains how to export the contents of a Dataset with more than one table, to an excel workbook in separate sheets. The article also helps understand the basics behind the Excel application object and its usage for creating a Workbook and inserting Worksheets in it. The following code can however extend its functionalities by incorporating methods and procedures for formatting the written data like the cell background, font color, inserting formulas etc....

To Export data into Excel in more than one worksheets     
Total Hits: 621  |  Today: 0Author: SachinKumarK.      Rating:  
Read Reviews | Write Review |  Your Rating: 

One thing that all developers comes across is to put the DataGrid data into an Excel sheet.

In this article I will show you how you can export your DataGrid data to an Excel file....

Exporting data to a XML file in SQL Server 2005     
Total Hits: 574  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I'll demonstrate how we can combine the new CLR integration and FOR XML enhancements to easily generate xml files from our relational data. For an introduction to .NET Stored procedures have a look at Introducing CLR Stored Procedures in SQL Server 2005. This article will reference the Orders table in the Northwind database. You can download the demo databases (plus an abridged version of Books On Line and sample code) for SQL 2005...

Importing the data from xml database to TALLY server     
Total Hits: 573  |  Today: 0Author: manivannan      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains.... HOW TO IMPORT DATA FROM XML DATABASE TO TALLY
actually the data present in the xml tags are tranferred to tally server cuncurrently.....

Sync Your Database to SharePoint Using SSIS     
Total Hits: 293  |  Today: 0Author: Lee Richardson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Custom SharePoint lists are like tables in a traditional database; in some ways they're even better. But as organizations adopt this new data store, they introduce additional complexities in integrating new list-based solutions with existing database applications. This article shows you how to solve the data mismatch problem by using the Extract Transform and Load (ETL) capabilities of Microsoft SQL Server Integration Services (SSIS) and Microsoft's new Collaborative Application Markup Language ...

Sync Your Database to SharePoint Using SSIS     
Total Hits: 212  |  Today: 0Author: Lee Richardson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Custom SharePoint lists are like tables in a traditional database; in some ways they're even better. But as organizations adopt this new data store, they introduce additional complexities in integrating new list-based solutions with existing database applications. This article shows you how to solve the data mismatch problem by using the Extract Transform and Load (ETL) capabilities of Microsoft SQL Server Integration Services (SSIS) and Microsoft's new Collaborative Application Markup Language ...

Exporting SSE Database Data to a Remote SQL Server     
Total Hits: 187  |  Today: 0Author: Desiree Harris      Rating:  
Read Reviews | Write Review |  Your Rating: 

When ASP.Net v2.0, Visual Studio 2005, and Visual Web Developer were released to manufacturing, ORCS Web began supporting those technologies making them immediately available to our clients. Visual Web Developer 2005 has a very cool feature that will allow you to dynamically create a SQL Server Express database for use when developing web applications, which is great for developers....

Exporting your data to CSV format     
Total Hits: 924  |  Today: 0Author: Bipin Joshi      Rating:  
Read Reviews | Write Review |  Your Rating: 

On-line web applications providing some business functionality often need to exchange data between other applications. For example, data displayed in a DataGrid might be needed by an Excel spreadsheet or data might be needed to be put inside Outlook address book. In such cases Comma Separated Values (CSV) format is the most widely used data interchange format. In this article we will see how to write a generic routine so that your entire DataTable can be exported to CSV format. CSV is the most w...

Attaching and Detaching a database in MS-SQL Server     
Total Hits: 435  |  Today: 0Author: Phani R C Chowdary Koganti      Rating:  
Read Reviews | Write Review |  Your Rating: 

This time lets know something about the MS-SQL Server’s stored procedures. These stored-procedures help us automate the hard-to-call tasks in an easy-to-use way. Apart from the programmers / database administrators, building their own customized or User-Defined stored-procedures, there are quite a lot System-Built-in stored-procedures. Lets focus on Attaching and Detaching a database using these stored-procedures....

Retrieve SQL Server Schema Information     
Total Hits: 491  |  Today: 0Author: Raghu Vangala      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we will see how to get the schema information like database names, table names, table structure, views etc from Sql server database .From Sql server 7.0 and above the schema metadata is stored in INFORMATION_SCHEMA views. The INFORMATION_SCHEMA is part of the SQL-92 standard. In SQL Server, these views exist in each database. However, they are not under the "dbo" user. Instead they are under the ownership of INFORMATION_SCHEMA. Each of the views in this collection exposes a diffe...

Bulk Loading XML Data Using MSXML      
Total Hits: 1699  |  Today: 0Author: John Paul Cook      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft XML Core Services (MSXML) offers several programmatic extensions for writing XML applications. The Bulk Load 3.0 COM object that comes with MSXML 3.0 provides a high performance option for bulk loading XML data into a relational database....

HOW TO: Import XML into SQL Server with the XML Bulk Load Component     
Total Hits: 6054  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database....

Simple data export     
Total Hits: 102  |  Today: 0Author: digital man      Rating:  
Read Reviews | Write Review |  Your Rating: 

BImport is a trivial console application that exports data from a set of tables in database 'a' to an identical set of tables in database 'b'. Once again my laziness got the better of me. I've been working on an application where it is useful to have live data to work with without actually using the live database. This program allows me to update my development database with the current data housed in live without needing to fire up SQL Server: I just double-click on the EXE in explorer and, bam...



Disclaimer - Privacy
© 2002-2017 DevASP.net