Displaying Festival Names on Calendar control in ASP.Net

Tags : Festival Names,Calendar Control,Importance of the day,Asp.Net,C#.Net,SQL Server. Hi Friends,In this article i would like to explain how to display Festival Names on Calender control in ASP.Net.* For this i took 1 Calendar control on to the page.* I created a table with name(Holidays) in SQL Server 2005 & fields are HolidayName,HolidayDate. * Please find the below table once :* Then...

Readmore...

Logical Operators in SQL Server.

Tags : Logical Operators,Sql Server 2005,Sql Server 2008,Sql Server Operators.Hi Friends,In this article i would like to explain Logical Operators in SQL Server.* Logical operators, like comparison operators, return a Boolean data type with a value of TRUE, FALSE, or UNKNOWN.* Available Logical Operators :1) AND: Performs a logical AND operation. The expression evaluates to TRUE if all conditions are TRUE.Example :SELECT * FROM ClassWHERE ( Marks > 40 AND Marks < 100)2) OR :Performs a logical OR operation. The expression evaluates to TRUE...

Readmore...

Difference between Varchar and NVarchar in SQL Server.

Tags : Varchar ,NVarchar ,Varchar(n),NVarchar(n),SQL Server,String,Length,Difference.Hi Friends,in this post i would like to explain difference between Varchar & NVarchar in SQL Server.* The data type Varchar and NVarchar are the sql server data types, both will used to store the string values.Differences :1 Character Data TypeVarchar - Non-Unicode Data NVarchar - Unicode Data2 Character Size Varchar - 1 byteNVarchar - 2 bytes3 Maximum Length Varchar - 8,000 bytesNVarchar - 4,000 bytes4 Storage Size...

Readmore...

String Functions in SQL Server.

Tags : String Functions,Sql Server 2005,Sql Server 2008.Hi Friends,in this article i would like to explain String Functions in SQL Server.* LEN (string) - Returns the length of the given string.For Example :select len(Address) as Address from Employee* LEFT (string, length) - Returns the specified number of characters from the beginning of the string.For Example :Select LEFT(Address,1) as Address from Employee* RIGTH (string, length) - Returns the specified number of characters from the end of the string.For Example :Select RIGHT(Address,2)...

Readmore...

How to start and stop triggers in sql server?

Tags : Enable Trigger,Disable Trigger,SQL Server 2005,SQL Server 2008,Triggers,Start,Stop.Hi Friends,in this post i would like to explain enabling and disabling triggers in SQL Server.* By writing Commands we can Start/Stop triggers in SQL Server.Enabling/Starting Trigger :Enable Trigger TriggerName ON database.dbo.tablename Disabling/Stopping Trigger :Disable Trigger TriggerName ON database.dbo.tablenameThank You...

Readmore...

SQL Server Triggers.

Tags : SQL Server 2005,SQL Server 2008,Triggers,DML Triggers,DDL Triggers,Logon Triggers.Hi Friends,in this post i would like to explain Triggers in SQL Server.* It is one kind of stored procedure, but triggers neither accept nor return any values.* Trigger is an action which can be execute automatically.* It is defined to execute automatically when the specified event is occurred.Types of Triggers :1) DML Triggers :These triggers executes automatically when data manipulation language event occurs. DML events are insert,update,delete.2) DDL Triggers...

Readmore...

How to insert data into XML file?

Tags : Insert,Data,XML File,Asp.Net,C#.NetHi Friends,in this post i would like to explain how to insert data into XML file.* Here in my example i am stored Name,Location,Email & Gender fields into XML file.For this i took 3 TextBoxes,DropDownList for Gender,Button & a label for displaying message.* Added XML file with name(InsertData)For this Go To SolutionExplorer-->Right Click on ApplicationName-->AddNewItem-->Select...

Readmore...

Example on Windows Service

Hi Friends,in this post i would like to explain windows service for displaying message box for every 3 seconds.Step 1:* Open windows service project with projectName WinService1* Goto ToolBox-->General-->Right Click-->Select choose items-->Select Timer(Systems.Timers)* Project-->AddReference-->System.Windows.Forms(Message Box is a part of above reference).* Place a Timer(System.Timers) with interval-3000 & enabled-false.Code:{//timer1_Elapsed event.System.Windows.Forms.MessageBox.Show("This message from Windows Service.");}Code...

Readmore...

Introduction to Windows Services.

Hi friends,in this post i would like to explain some basic things to know about windows services.* A service which is under control of windows OS is called windows service.* Windows services are used to develop automated background processes.* Windows services contains only application logic but not GUI(Graphical User Interface).* The controls which are not visible at runtime,can be placed in windows service projects. For example:Timer Control,Event log control,File system watcher control. * To develop windows services .Net provided:File-->NewProject-->VisualC#-->Windows-->WindowsServiceTemplate.*...

Readmore...

Saving images to our application.

Hi Friends,in this post i would like to explain how to save images from our PC to application.* For this i took one FileUpLoad control, Button control and a Label control for displaying message.Add the following name space:using System.IO;Code for button click event():protected void Button1_Click(object sender, EventArgs e){try{string filePath = FileUpload1.PostedFile.FileName;string filename = Path.GetFileName(filePath);FileUpload1.PostedFile.SaveAs(@"F:\\Asp.Net\FileUpload\Images\" + filename);Label1.Text = "Image uploaded successfully.";}catch{Label1.Text...

Readmore...

Unique Key on 2 columns in SQL Server.

Hi friends,in this post i would like to explain how to create Unique Key on 2 columns in SQL Server.For Example:Here i am created Unique Key for 2 columns(Name,SurName) on College table.CREATE TABLE [dbo].[College] ADD CONSTRAINT [UK_College] UNIQUE NONCLUSTERED([Name] ,[SurName])WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]Thank you...

Readmore...

Set Operators in SQL Server.

Hi Friends,in this post i would like to explain Set Operators in SQL Server.*Set Operators are used to combined the data from multiple tables.Set Operators:1)UNION2)UNION ALL3)INTERSECT4)EXCEPTSyntax:Select query1Select query2Select query3..................1)UNION*UNION can select only distinct/unique rows & rows can be arranged in ascending order.2)UNION ALL*UNION ALL is used to combine all rows from the given select queries.3)INTERSECT* UNION ALL is used to select only common rows from the given set of select queries.4)EXCEPT* EXCEPT is equalent...

Readmore...

Constraints in SQL Server.

Hi Friends, in this post I would like to explain Constraints in SQL Server. * Constraint is a mechanism which can be activated automatically when the specified event is occurred. * Constraint is a role it can be defined on the selected columns in order to prevent invalid data. * It is one of the data integrity concepts to enforce integrity explicitly. Different types of constraints: 1) Not Null: It does not allow null values in the specified column. 2) Check: It is used to validating user conditions. 3) Unique: It doesn’t allow duplicate...

Readmore...

Java Script function for Printing Div content.

Hi Friends, in this post I would like to explain Java Script function for Printing Div content. Here I took one Button control for printing the content. JavaScript Function: <script type ="text/javascript" language ="javascript"> function Print(elementId) { var printContent = document.getElementById(elementId); var windowUrl = 'about:blank'; var uniqueName = new Date(); var windowName = 'Print' + uniqueName.getTime(); var printWindow = window.open(windowUrl, windowName,...

Readmore...

Java Script function for entering only Integers values in Textbox.

Hi Friends, in this post I would like to explain Java Script function for entering only Integers values in Textbox. JavaScript Function: <script type="text/javascript" language="javascript"> function isNumberKey() { if(!(((event.keyCode>=48&&event.keyCode<=57) || (event.keyCode>=96&&event.keyCode<=105))||(event.keyCode==8) || (event.keyCode==9) || (event.keyCode==37) || (event.keyCode==39) || (event.keyCode==46) || (event.keyCode==190))) event.returnValue=false; } !--script> Calling...

Readmore...

Windows application for converting Text into Speech.

Hi Friends, in this post I would like to explain how to convert Text into Speech.· Open windows application.· Place a TextBox & a Button control on to the form.· Goto ProjectMenu---> Add Reference---> COM---> MicrosoftSpeechObjectLibrary (Add this reference).· Add the following namespace: using SpeechLib;Please go through the code under button click event:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using...

Readmore...

Deleting files from the system in ASP.Net.

Hi Friends, in this post I would like to explain how to delete the file existing on the system.For this I took 1 FileUpload, 1 Button & 1 label control on to the page.Please find the source code below:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Untitled Page</title>...

Readmore...