asp.net key event

protected void Page_Load(object sender, EventArgs e)
{
txtDepartmentQuery.Attributes.Add("onKeyUp", "GetKeyUp(event)");
}

key press code

Key Pressed	Javascript Key Code
backspace	8
tab	9
enter	13
shift	16
ctrl	17
alt	18
pause/break	19
caps lock	20
escape	27
page up	33
page down	34
end	35
home	36
left arrow	37
up arrow	38
right arrow	39
down arrow	40
insert	45
delete	46
0	48
1	49
2	50
3	51
4	52
5	53
6	54
7	55
8	56
9	57
a	65
b	66
c	67
d	68
e	69
f	70
g	71
h	72
i	73
j	74
k	75
l	76
m	77
n	78
o	79
p	80
q	81
r	82
s	83
t	84
u	85
v	86
w	87
x	88
y	89
z	90
left window key	91
right window key	92
select key	93
numpad 0	96
numpad 1	97
numpad 2	98
numpad 3	99
numpad 4	100
numpad 5	101
numpad 6	102
numpad 7	103
numpad 8	104
numpad 9	105
multiply	106
add	107
subtract	109
decimal point	110
divide	111
f1	112
f2	113
f3	114
f4	115
f5	116
f6	117
f7	118
f8	119
f9	120
f10	121
f11	122
f12	123
num lock	144
scroll lock	145
semi-colon	186
equal sign	187
comma	188
dash	189
period	190
forward slash	191
grave accent	192
open bracket	219
back slash	220
close braket	221
single quote	222

source: http://www.cambiaresearch.com/c4/702b8cd1-e5b0-42e6-83ac-25f0306e3e25/Javascript-Char-Codes-Key-Codes.aspx

Reset Table Identity column to 0

Source: http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

=====
This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find this helpful.

Every so often (just this morning!) I find myself resetting an identity column value back to 0 after I've deleted all the existing records so the table gets a fresh start at primary key 1. Yes, I know all about primary keys not changing and how the value in the primary key doesn't matter and so on. Sometimes I just like the primary keys starting at 1.

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

DBCC CHECKIDENT('Customer', RESEED, 0)

Have a day. :-|

Friday, November 30, 2007 9:18 AM

===

"Cannot insert explicit value for identity column"

asp.net | 3.5 | c# | linq

I had an error "Cannot insert explicit value for identity column."

I had my primary column set to be an identity column. I didn't know how to trace my error because everything was correct. But, sometimes when table definition changed and may have created diagram before the column was designated to be the identity column an error occurs. In this case, you delete the table and readd the table on to your dbml/diagram [Linq to SQL Classes].

Linq Distinct

Lets' say I have two tables. Here, you have SectionTable and SectionName.

SectionTable TableID SectionID 1 1 2 1 3 2

SectionName TableID SectionName 1 Blue 2 Red 3 Pink

On SectionTable you have duplicate value of of SectionID.
On SectionName, you have no duplicate values.

"from st in db.SectionTable select st" you will get the Grid Data of SectionTable
"from sn in db.SectionName select sn" you will get the Grid Data of SectionName.

How do you marry these two tables to get a Distinctive Values?

(from st in db.SectionTable
from sn in db.SectionName
where st.SectionID == sn.TableID
select new
{
SectionID = sn.TableID
SectionName = sn.SectionName
}).Distinct();

If you wrap ().Distinct() around your query, you get Distict value of the both!
Hope that Helps...