Create Connection Strings easily

The connection string may include attributes such as the name of the driver, server and database, as well as security information such as user name and password. UDL file can be used to generate connection strings easily. To create UDL file first create new text file and rename it from "filename.txt" to "filename.udl" that's it. Now run filename.udl by double clicking it. Data Link Properties window will open, select Provider Tab and select the provider you need and click next. Now provide the details as required and click on test connection. If you get success message, you are done. Now open udl file as text file, connection string will be there in the last line. Reference: Muthukumar (http://nadarmuthukumar.blogspot.in/), CodeProject&nb...

Read More

The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly

Visual Studio 2010 and SQL Server Express have an uneasy alliance, at best.  When you install Visual Studio 2010 it installs SQL Server Express 2008 for you, but only the database engine, not SQL Server Management Studio.  If you mess with SQL Server Express in order to install the management tools, or upgrade to 2008 R2, or install the Advanced Services version, things break and you can no longer reliably use the Visual Studio database projects. In particular, if you remove SQL Server Express 2008 and install SQL Server Express 2008 R2, you’ll probably run into an issue where if you try to open a schema object in a Visual Studio database project you’ll get an error that says:"‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly" The...

Read More

Meaning of decimal(18,2) Ms Sql Server

The actual syntax of the datatype is decimal(p,s). So here, p is the precision and s is the scale. The datatype Decimal(18,2)is used to represent numbers.The length of numbers should be totally 18. The length of numbers after the Decimal point should be 2 only and not more than that. 1234567898822222.88 The numbers to the left of decimal point should not be greater than 16. The numbers to the right of decimal point should not be greater than 2. (.) is excluded here in the length. So,the overall length of the number cannot exceed the length 18. Reference: Muthukumar (http://nadarmuthukumar.blogspot....

Read More

Convert dd mm yyyy string to datetime

Create a function as shown below. Your can use any one of the method give below inside the function, rest you can comment it out. private DateTime FormatDate(string _Date) { DateTime Dt; //Method 1 System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo(); dateInfo.ShortDatePattern = "dd/MM/yyyy"; Dt = Convert.ToDateTime(_Date, dateInfo); //Method 2 IFormatProvider mFomatter = new System.Globalization.CultureInfo("en-US"); Dt = DateTime.ParseExact(_Date, "dd/MM/yyyy", mFomatter); //Method 3 Dt = DateTime.ParseExact(_Date, "dd/MM/yyyy", null); return Dt; } To call the function use below code string UrDate = "27/08/2008"; DateTime _obj...

Read More

What is an application domain (appdomain)

What is an application domain (appdomain) Before .NET framework 2.0 technology, the only way used to isolate applications running on the same machine is by the means of process boundaries. Each application run within a process, and each process has its own boundaries and memory addresses relative to it and this is how isolation from other processes was performed. .NET framework 2.0 introduces a new boundary called the Application Domains. Application domain is nothing but a boundary within which an application runs. process can contain multiple application domains. Application domains provide an isolated environment to applications. An application...

Read More

Get last inserted ID in sql server

SELECT IDENT_CURRENT(‘tablename’)It returns the last IDENTITY value produced in a table,  IDENT_CURRENT is limited to a specified table. IDENT_CURRENT returns the identity value generated for a specific table. Reference: Muthukumar (http://nadarmuthukumar.blogspot.in/), SqlAuthor...

Read More