Update Field Value in DataTable using Linq in C#
Update Field Value in DataTable using Linq in C#
Posted inC#.Net
Unzip compressed folder in C# using 4.0 framework
Use System.IO.Compression.FileSystem.dll which exist in C:\Windows\Microsoft.NET\assembly\GAC_MSIL\System.IO.Compression.FileSystem\v4.0_4.0.0.0__b77a5c561934e089
Namespace Name :- using System.IO.Compression.FileSystem
Read Multiple Files from folder and Download using FTP location in Console Application using C#
Today I’m going to tell you to read multiple files from folder using FTP Location.Please follow below steps to fetch
Step 1 :- Place code in Class file
string ftpDownloadResult = string.Empty;
try
{
WebRequest request = WebRequest.Create(ConfigurationManager.AppSettings["FTPPath"]);
request.Method = WebRequestMethods.Ftp.ListDirectory;
request.Credentials = newNetworkCredential(ConfigurationManager.AppSettings["FTPUserName"],
ConfigurationManager.AppSettings["FTPPassword"]);
Posted inC#.Net
Read File from FTP location in Console Application using C#
Today I'm going to tell you to read text from FTP Location.Plz follow below steps to fetch
Step 1 :- Place code in Class file
WebRequest request = WebRequest.Create(ConfigurationManager.AppSettings["FTPPath"]);
request.Method = WebRequestMethods.Ftp.DownloadFile;
request.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["FTPUserName"],
ConfigurationManager.AppSettings["FTPPassword"]);
Posted inSQL
Generate Random Password In SQL
Today i'll explain how to generate random password in SQL by using a template.
Template work as like as format that every new password will generate as same format.
Posted inSQL
Convert Rows to Columns in SQL Server Without Using Pivot
Convert Rows to Columns in SQL Server Without Using Pivot DECLARE @UserData TABLE (UserName VARCHAR(50),Mobile VARCHAR(50)) INSERT INTO @UserData VALUES ('Abdul',23243434) INSERT INTO @UserData VALUES ('Abdul',345435345) INSERT INTO @UserData VALUES ('Abdul',23423)…
Posted inSQL
Get List of All Stored Procedures,Tables,Triggers from Database in SQL Server
Get List of Stored procedure,Tables,Triggers names in database
To get list of procedures in SQL Server we need to write the query like as shown below
USE TempDB
SELECT * FROM SYS.PROCEDURES
Get List of table names in database
Posted inSQL
Change Identity Column Value in SQL Server
I will explain to change identity column seed value in SQL server or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server.
DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)
Table_Name is name of your identity column table
Posted inSQL
Drop index from Table
To remove index from table we use drop index statement in sql server.
To create index on column in sql server that syntax will be like as shown below
Syntax to Create Index
CREATE INDEX indexname ON Tablename(columnname)
Posted inSQL
Difference between Cursor and While Loop with Example
Here I will explain difference between cursor and while loop in sql server with example or explain cursor vs while loop with example in sql server. Cursors in sql server allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. While loop also same as cursor to fetch set of data and process each row in sql server.
