Pages

Thursday, 4 August 2011

Displaying Festival Names on Calendar control in ASP.Net

0 comments
 
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 find the code for Calender_DayRender event :

Source Code :

Default.aspx.cs :
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DotnetGuruConnectionString"].ConnectionString);
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
CalendarDay day = (CalendarDay)e.Day;
SqlCommand cmd = new SqlCommand("select HolidayName,HolidayDate from Holidays", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
if (day.Date.ToString() == dr["HolidayDate"].ToString())
{
TableCell cell = (TableCell)e.Cell;
string s1 = dr["HolidayName"].ToString();
if (s1 != null)
{
cell.BackColor = System.Drawing.Color.LightGray;
cell.Controls.Add(new LiteralControl("
" + s1));
}

}

}
con.Close();
}
}
Design View :

Default.aspx :


 















* Then finally Build(F6) your application & run the application by pressing(F5) button.

* Your out put will looks like as below :
Thank You...

Readmore...
Tuesday, 2 August 2011

Logical Operators in SQL Server.

0 comments
 
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 Class
WHERE ( Marks > 40 AND Marks < 100)


2) OR :

Performs a logical OR operation. The expression evaluates to TRUE if atleast one condition is TRUE.

Example :

SELECT * FROM Class
WHERE EmployeeName LIKE 'K%' OR Marks > 40


3) BETWEEN :

It returns TRUE if the operand is within a range otherwise FALSE.

Example :

Select * from Employee
WHERE EmpSalary BETWEEN 5000 AND 15000


4) IN :

This Operator returns TRUE if the operand is equal to one of a list of expressions Otherwise flase.

Example :

SELECT * FROM Students
WHERE StudentId IN(SELECT StudentId FROM CSEDEPT WHERE CSEDeptID=20)


5) EXISTS :

Specifies a subquery to test for the existence of rows.

Example :

SELECT * FROM Students WHERE EXISTS
(
SELECT * FROM Students WHERE CollegeCode='B2'
)


6) LIKE :

Determines whether a specific character string matches a specified pattern.

Example :

SELECT * FROM EnggColleges
WHERE CollegeName LIKE 'S%'

Here,it will return all the records which has 's' as first letter in CollegeName


7) ALL :

It Returns TRUE if all of a set of comparisons are TRUE other wise returns FALSE

Example :

SELECT * FROM Employee
WHERE EMPLOYEEID >= ALL (SELECT EMPLOYEEID from Salary WHERE Salary>5000 )


8) ANY :

ANY returns TRUE when the comparison specified is TRUE for ANY pair, otherwise, returns FALSE.

Example :

SELECT * FROM Colleges WHERE 20000 > ANY
(
SELECT CollegeFess FROM Colleges
)


9) Not :

NOT operator is used To find rows that do not match a value.

Example :

SELECT * FROM Colleges
WHERE CollegeCode NOT IN (50,100,150,200)


Thank You...
Readmore...
Monday, 1 August 2011

Difference between Varchar and NVarchar in SQL Server.

2 comments
 
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 Type

Varchar - Non-Unicode Data
NVarchar - Unicode Data

2 Character Size

Varchar - 1 byte
NVarchar - 2 bytes

3 Maximum Length

Varchar
- 8,000 bytes
NVarchar - 4,000 bytes

4 Storage Size

Varchar - Actual Length (in bytes)
NVarchar - 2 times Actual Length (in bytes)


* The abbreviation for Varchar is Variable Length character String.

* The abbreviation of NVarchar is uNicode Variable Length character String.



Thank You...
Readmore...
Sunday, 31 July 2011

String Functions in SQL Server.

1 comments
 
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) as Address from Employee


* REVERSE (string) - Returns the given string in reverse order.

For Example :

Select Reverse(Address) as Address from Employee


* UPPER (string) - Converts the given string into uppercase letters.

For Example :

Select UPPER(Address) as Address from Employee


* LOWER(string) - Converts the given string into lowercase letters.

For Example :

Select LOWER(Address) as Address from Employee


* SPACE (integer) - Returns the string with the specified number of space characters.

For Example :

Select SPACE(1) as Address from Employee



* LTRIM (string) - LTRIM function to return a character expression after removing leading spaces.

For Example :

Select LTRIM(Address) as Address from Employee


* RTRIM (string) - RTRIM function to return a character expression after removing trailing spaces.

For Example :

Select RTRIM(Address) as Address from Employee



* SUBSTRING (string, start, length) - Returns the specified number of characters from the string starting at the specified position.

For Example :

Select SUBSTRING (Address, 1, 4) as Address from Employee


Thank you...
Readmore...
Saturday, 30 July 2011

How to start and stop triggers in sql server?

1 comments
 
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.tablename


Thank You...
Readmore...

SQL Server Triggers.

1 comments
 
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 :

These triggers executes when data definition language events such as create,alter,drop occurs.

3) Logon Triggers :

These triggers fires for logon events.


Difference between Trigger & Stored Procedure :

1) Trigger is implicit execution where as Stored Procedure is explicit execution.

2) Triggers doesn't allow any parameters & doesn't return any values.Stored Procedure can allow parameters & return values.


Advantages :

* We can schedule tasks basing on events.

Disadvantage :

* It is burden because triggers run on database.
* It is difficult to track the changes done by triggers on database.


Thank you...


Readmore...