In this article we are going to perform the one of the basic Transformation technique that is Skew Transform. The term Transformation means perform rotation with the object. The rotation can be performed on the x-axis or may be on y-axis. he term Skew means to turn or place something at an angle or on [...]
Binding Combobox Control With Multiple Columns of Database Table
Filed in ASP.NET, Desktop AppPreviously we have discussed that how to bind Combo box control with Database Table’s column in WinForm. Today I will tell you that how to bind a Combo box control with multiple columns of a particular table. The way of binding is very simple. We are not writing extra code or not writing any complicated code to [...]
While working with database we need to store our information time to time. and for that purpose we take the backup for that database. Backing up a database provide many solutions for us. The main thing is if we lost our database from SQL Server then we can restore our database from our computer. Also [...]
When we are working with Tables in Database we need to perform some basic operation with Tables. These operations may be inserting records, updating records etc. The most important operation we need to know about the table is fetching records from the Table, also we can say retrieving records from tables. Sometime we need to [...]
How to Attach Database File with Window Application Project
Filed in ASP.NET, Desktop AppAttaching Database file inside your ASP.NET Window Application Project is not necessary but sometimes it is very useful for us. There are two ways to use database with your project. The first one is create a database in SQL server and write code in your front end to make a connection and the other one [...]
Hello guys, I hope you are enjoy reading article. Today we are going to discuss the Constraints that we need to use in SQL while programming. Some time we need to put some type of restriction on the column of the table. These restriction are called constraints. Also we are going to discuss the types [...]
Control-of-flow statements are very must for any programming language. A complete project can not be completed without any condition. And when we talk about the condition there are various types of control statements in T-SQL. Today we will discuss first If statement then If-Else statements in T-SQL. If-Else statements do the same task as for [...]
Creating, Altering, Dropping and Executing Sproc or Stored Procedure in MS SQL Server
Filed in ASP.NET, SQLStored Procedure also known as Sproc or SP is used to perform some operation like a Function works. The main difference between Stored Procedure and Function is that in a Function always returns a value but a Stored Procedure doesn’t return value always. We prefer the Stored Procedure than Function in while programming in MS [...]
Development of software is only a single phase of overall system development. Coding is an important step on system development but maintaining the quality of software is also an important part and a challenging job. Proper testing is important for the good quality assurance. At present, there are different tools available for testing products. The tools like