Monday, November 7, 2011

Auto start/stop timer when keyboard& Mouse idle mode

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.Threading;


namespace afp_Login
{
public partial class Form2 : Form
{
int Timecounter = 0;
Stopwatch stopwarch;
TimeSpan ts;

public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
timer1.Start();
timer2.Start();
stopwarch = new Stopwatch();
stopwarch.Start();

}
private void timer1_Tick(object sender, EventArgs e)
{
ts = stopwarch.Elapsed;
string Elapsedtime = string.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10);
lblTime.Text = Elapsedtime.ToString();

}

private void timer2_Tick(object sender, EventArgs e)
{
Timecounter++;
if (Timecounter > 30 && timer1.Enabled == true)
{
stopwarch.Stop();
timer1.Stop();
}
else if (Timecounter < 30 && timer1.Enabled == false)
{
stopwarch.Start();
timer1.Start();
}

}

private void Form2_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
Timecounter = 0;
}

private void Form2_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e)
{
Timecounter = 0;
}

}
}

Friday, July 29, 2011

Nth Highest salary

declare @empsal int
set @empsal=3
select * from [Employee-new] e1 where @empsal =( select count(distinct e2.empsal) from [Employee-new] e2 where e2.empsal >= e1.empsal)

Thursday, April 28, 2011

HTML WITH MS Access DB

html
head
script language="JavaScript"

function getSubmit()
{
var Firstn = names.value;
var LastName =surname.value;
var cn = new ActiveXObject("ADODB.Connection");
//here you must use forward slash to point strait
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
//var SQL = "INSERT INTO Customers(Fname, Lname) VALUES ( '"+ Firstn +"', '" + LastName +"')";
var SQL = "select Surname from Customers where Fname = '" + Firstn + "'";
cn.Open(strConn);
rs.Open(SQL, cn);
surname.value= rs(0);
//DOB.value = rs(1);
//alert(rs(0));
rs.Close();
cn.Close();
}
/script
/head
body
input type="text" name="names"
input type="text" name="surname"
input type="button" value="submit" onclick="getSubmit()"
/body
/html

Monday, April 11, 2011

Query for delete data from first table and copy into second table

Query for delete data from first table and copy into second table

Ans:

DELETE OldTableName
OUTPUT deleted.* INTO NewTableName