Pradeep SVS
Move Window border less form c#
We can move windows border less form in 2 ways. bool flag = false; private void...
Author: Pradeep SVS Date: 12/05/2014
Difference between a stored procedure and function
Benefits of Stored Procedures Precompiled execution: SQL Server compiles each Stored Procedure once...
Author: Pradeep SVS Date: 10/08/2014
Cannot connect to WMI provider. You dont have permission to server or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0*8004100e]
When I was trying to open Sql Server Configuration Manager 2012, I am receiving below error. I...
Author: Pradeep SVS Date: 09/18/2014
One or more types required to compile a dynamic expression cannot be found
Solution -Add Reference -> .NET -> add Microsoft.CSharp. Two things are important. Check the...
Author: Pradeep SVS Date: 09/16/2014
Read SSIS package programatically C#
static void Main(string[] args) { Console.WriteLine(); Application app = new Application(); Package...
Author: Pradeep SVS Date: 01/04/2014
file extension regular expression in c# in windows
Regular Expression :...
Author: Pradeep SVS Date: 11/27/2013
Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>) asp.net
Issue: Server Error in 'ASP.Net' Application. The Controls collection cannot be modified because the...
Author: Pradeep SVS Date: 11/14/2013
Create Database Backup using T-SQL and Delete Older Backup's.
USE MASTER go DECLARE @DBNAME NVARCHAR(100), @DBFILENAME NVARCHAR(100), @BACKUPPATH NVARCHAR(255),...
Author: Pradeep SVS Date: 11/12/2013
Create SQL Table Schema based on data from flat files
Hello All, Today we ll see how to create a SQL table schema based on flat files(excel, csv, txt...
Author: Pradeep SVS Date: 10/31/2013