Friday

asp.net dropdownlist selectedvalue


<script language='javascript'>
function getDropdownSelectedValue()
{
var e = document.getElementById("<%=MyDropDown.ClientID%>");
var chain= e.options[e.selectedIndex].value;

return chain;
}
</script>

more...

sql today

to get today's records from table :

select * from mytable where
CONVERT(varchar(8), mydatefield, 112)=CONVERT(varchar(8), GETDATE(), 112)

more...

Monday

outlook keyboard shortcuts







































Switch to Inbox. CTRL+SHIFT+I
Switch to Outbox. CTRL+SHIFT+O
Choose the account from which to send a message. CTRL+TAB (with focus on the To box) and then TAB to the Accounts button
Check names. CTRL+K
Send. ALT+S
Reply to a message. CTRL+R
Reply all to a message. CTRL+SHIFT+R
Forward a message. CTRL+F
Mark a message as not junk. CTRL+ ALT+J
Display blocked external content (in a message). CTRL+SHIFT+I
Post to a folder. CTRL+ SHIFT+S
Apply Normal style. CTRL+SHIFT+N
Check for new messages. CTRL+M or F9
Go to the previous message. UP ARROW
Go to the next message. DOWN ARROW
Create a new message (when in Mail). CTRL+N
Create a new message (from any Outlook view). CTRL+SHIFT+M
Open a received message. CTRL+O
Open the Address Book. CTRL+SHIFT+B
Convert an HTML or RTF message to plain text. CTRL+SHIFT+O
Add a Quick Flag to an unopened message. INSERT
Display the Flag for Follow Up dialog box. CTRL+SHIFT+G
Mark as read. CTRL+Q
Mark as unread. CTRL+U
Show the menu to download pictures, change automatic download settings, or add a sender to the Safe Senders List. CTRL+SHIFT+W
Find or replace. F4
Find next. SHIFT+F4
Send. CTRL+ENTER
Print. CTRL+P
Forward. CTRL+F
Forward as attachment. CTRL+ALT+F
Show the properties for the selected item. ALT+ENTER
Mark for Download. CTRL+ALT+M
Clear Mark for Download. CTRL+ALT+U
Display Send/Receive progress. CTRL+B (when a Send/Receive is in progress)

Tuesday

sql connection string port

If you want to connect to specific instance sometimes you have to specify port on which this instance running.
Port is specifying by comma in connection string like this(1362):


<add key="ConnectionString" value="server=sql-server1\qa,1362;database=db1;user id=u1;password=MyPassword;Trusted_Connection=no"/>

imagemagic add text to image

rem different types of text annotations on existing images rem cyan yellow orange gold rem -gravity SouthWest rem draw text and anno...