Implementing Skew Transformation in WPF

Filed in ASP.NET, WPFTags: , , ,

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 AppTags: , , , , ,

Previously 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 [...]

SQL Server Database Backup and Restore Database

Filed in ASP.NET, SQLTags: , , , , , ,

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 [...]

Fetching Records from Multiple Tables in SQL Database

Filed in ASP.NET, SQLTags: , , , , , , , ,

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 [...]

TreeView Navigation Control in ASP.NET

Filed in ASP.NET, Web AppTags: , , ,

Previously we have discussed about Navigation controls in ASP.NET. Also we saw that how to use the SiteMapPath control for navigation between pages. Today we are going to use another Navigation control. The control is TreeView control. TreeView control is also used to navigate from one page to other page in an ASP.NET web application. [...]

How to Attach Database File with Window Application Project

Filed in ASP.NET, Desktop AppTags: , , , , ,

Attaching 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 [...]

Constraints and Types of Constraints in SQL

Filed in ASP.NET, SQLTags: , , ,

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 [...]

Implementing If-Else Statements in T-SQL(MS SQL Server)

Filed in ASP.NET, SQLTags: , , , , ,

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, SQLTags: , , , , ,

Stored 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 [...]

How to use RadioButton Controls as RadioButtonList Control in ASP.NET WinForm

Filed in ASP.NET, Web AppTags: , , , , ,

ASP.NET provide some list controls to select single as well as multiple values from a specific group. The RadioButton control is one of them. Previously we have learned how to work with CheckBox Control and CheckBoxList Control. The Radio Button List is also used to get a value from the list. But the main diference [...]