| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BASIC SHORTCUT KEYS
The below basic shortcut keys are a listing of shortcut keys that will work with almost all IBM compatible computers and software programs. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.
MICROSOFT WindowsSHORTCUT KEYS
If you're looking for shortcut keys or information about how to navigate Microsoft Windows using your keyboard instead of the mouse see document CH000791.
WindowsKEYBOARD SHORTCUTS
Below is a listing of Windows keys that can be used on computers running a Microsoft Windows operating system and using a keyboard with a Windows key. In the below list of shortcuts, the Windows key is represented by "WINKEY". If you are looking for Windows shortcut keys, see the above Microsoft Windows shortcut key section.
EXCEL SHORTCUT KEYS
See our Microsoft Excel page for additional help and information.
WORD SHORTCUT KEYS
See our Microsoft Word page for additional help and information.
INTERNET EXPLORER SHORTCUT KEYS
See our Microsoft Internet Explorer page for additional help and information.
|
Tuesday, September 11, 2012
Shortcut keys
Menu binding from database in VB.NET
//DataBase Table Structure
categoryid parentid name
categoryid parentid name
| 1 | NULL | country Name |
| 2 | NULL | State Name |
| 3 | 1 | India |
| 4 | 1 | Sri Lanka |
| 5 | 1 | Pakistan |
| 6 | 1 | USA |
| 7 | 2 | Tamil Nadu |
| 8 | 2 | Karnataka |
| 9 | 2 | Andara |
| 10 | NULL | District Name |
| 11 | 10 | Vellore |
| 12 | 10 | Bangalore |
| 13 | 10 | chennai |
| NULL | NULL | NULL |
//coding part
Partial Class _Default
Inherits System.Web.UI.Page
Dim sqlcon As New SqlConnection
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
populatemenuitem()
End If
End Sub
Private Sub populatemenuitem()
Dim menudatatable As New DataTable
Dim menuadapter As New SqlDataAdapter
Dim menufill As New SqlCommand
menufill.CommandText = "select CategoryId,ParentId,Name from menu"
menufill.Connection = conn()
conopen()
Using _da As New SqlDataAdapter(menufill)
_da.Fill(menudatatable)
appendmenu(menudatatable)
End Using
connclose()
End Sub
Public Function conn()
sqlcon.ConnectionString = ConfigurationManager.
Return sqlcon
End Function
Public Sub conopen()
sqlcon.Open()
End Sub
Public Sub connclose()
sqlcon.Close()
End Sub
Private Sub appendmenu(ByVal menutable As DataTable)
Dim view As New DataView(menutable)
view.RowFilter = "ParentId is NULL"
For Each row As DataRowView In view
Dim newmenuitem As New MenuItem(row("Name").ToString(
Menu1.Items.Add(newmenuitem)
addchilditems(menutable, newmenuitem)
Next
End Sub
Private Sub addchilditems(ByVal menutable As DataTable, ByVal parentmenuitem As MenuItem)
Dim view As New DataView(menutable)
view.RowFilter = "ParentId=" + parentmenuitem.Value
For Each row As DataRowView In view
Dim newmenuitem As New MenuItem(row("Name").ToString(
parentmenuitem.ChildItems.Add(
addchilditems(menutable, newmenuitem)
Next
End Sub
End Class
Rank Generation in SQL
alter proc no1
@name varchar(50),
@mark1 numeric(18,0),
@mark2 numeric(18,0),
@mark3 numeric(18,0)
as
insert into rno(name,mark1,mark2,mark3) values (@name,@mark1,@mark2,@mark3)
declare @total numeric(18,0)
declare @temp numeric(18,0)
declare @id varchar(50)
set @temp = (select sno from rno where sno = ( select max(sno) from rno))
set @id = ( select 'VV'+ convert(varchar,substring(
update rno set id = @id , total =@mark1+@mark2+@mark3 where sno=@temp
declare @rank numeric(18,0)
declare @na numeric(18,0)
declare @abc cursor
set @abc = cursor for select total from rno order by total desc
set @rank = 1
open @abc
fetch next from @abc into @na
while @@fetch_status=0
begin
update rno set rank = @rank where total = @na
set @rank=@rank+1
fetch next from @abc into @na
end
close @abc
deallocate @abc
exec no1 'yuuyf',10,16,95
@name varchar(50),
@mark1 numeric(18,0),
@mark2 numeric(18,0),
@mark3 numeric(18,0)
as
insert into rno(name,mark1,mark2,mark3) values (@name,@mark1,@mark2,@mark3)
declare @total numeric(18,0)
declare @temp numeric(18,0)
declare @id varchar(50)
set @temp = (select sno from rno where sno = ( select max(sno) from rno))
set @id = ( select 'VV'+ convert(varchar,substring(
update rno set id = @id , total =@mark1+@mark2+@mark3 where sno=@temp
declare @rank numeric(18,0)
declare @na numeric(18,0)
declare @abc cursor
set @abc = cursor for select total from rno order by total desc
set @rank = 1
open @abc
fetch next from @abc into @na
while @@fetch_status=0
begin
update rno set rank = @rank where total = @na
set @rank=@rank+1
fetch next from @abc into @na
end
close @abc
deallocate @abc
exec no1 'yuuyf',10,16,95
Code for display Display Clock on your Webpage
<span id="digitalclock" class="styling"></span>
<script>
var alternate=0
var standardbrowser=!document.all&
if (standardbrowser)
document.write('<form name="tick"><input type="text" name="tock" size="6"></form>')
function show(){
if (!standardbrowser)
var clockobj=document.
var Digital=new Date()
var hours=Digital.getHours()
var minutes=Digital.getMinutes()
var dn="AM"
if (hours==12) dn="PM"
if (hours>12){
dn="PM"
hours=hours-12
}
if (hours==0) hours=12
if (hours.toString().length==1)
hours="0"+hours
if (minutes<=9)
minutes="0"+minutes
if (standardbrowser){
if (alternate==0)
document.tick.tock.value=
else
document.tick.tock.value=
}
else{
if (alternate==0)
clockobj.innerHTML=hours+"<
else
clockobj.innerHTML=hours+"<
}
alternate=(alternate==0)? 1 : 0
setTimeout("show()",1000)
}
window.onload=show
//-->
</script>
Subscribe to:
Posts (Atom)