Exporting data from SQL Server to CSV file in ASP.Net using C#
Namespaces
You will need to import the following namespaces.
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
Code For Export DataTable to CSV
protected void ExportCSV(object sender, EventArgs e)
{
string constr...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, March 30, 2018
Saturday, November 18, 2017
Hi friends, today I will explain how to create and configure a linked server to retrieve data from an Azure SQL database.
Few points are describe in this article for configure link server with SSMS
How to configure link server step by step in SSMS
Solve some common Problem/Issue when create link server
Using the Query/Script base to create...
Friday, October 6, 2017
Data Table to XML Genrate
///
/// Write out XML to a DataTable to a file in a controlled manner.
/// Use a XmlWriterSettings to control the output formatting.
///
public static string DataTableToXML(DataTable table)
{
...
Tuesday, September 26, 2017
XML Helper for convert class object/List to xml and xml to class object/List conversion
Hi friend's, today we are going to understand ubout XMl Helper for convert class object/List to xml and xml to class object/List convertion.
let's start with example,
Create class for EmployeeDetail
public class EmployeeDetails
...
