Command Line
Download a file via a FTP URL (see FTP URL's for more information).
From the command line type:
drive:\(coreftp path)\coreftp.exe -d ftp://ftp.yoursite.com/directory/yourfile.dat
or
drive:\(coreftp path)\coreftp.exe ftp://ftp.yoursite.com/directory/yourfile.dat
This will download the file into the default download directory...
Showing posts with label Janak Goti. Show all posts
Showing posts with label Janak Goti. Show all posts
Friday, June 1, 2018
Friday, March 30, 2018
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...
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...
Wednesday, November 1, 2017
SSIS FOR BEGINNERS
Hi friend's, today we are going to understand about SSIS. i collect many information about SSIS blob and try to understand how to use SSIS. i hope it is useful for you.
Now first try to understand about SSIS.
What IS SSIS?
Why SSIS?
SSIS Variable.
SSIS Connection Manager.
SSIS ToolBox.
Data Flow Task.
1....
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
...
Thursday, September 21, 2017
Improve SQL Query Performance
Hi friend's, today we are going to understand step to improve t-sql query perfomance step by step mention below.
Use EXISTS instead of IN to check existence of data.
Avoid * in SELECT statement. Give the name of columns which you require.
Choose appropriate Data Type. E.g. To store strings use varchar in place of...
