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;
}

}
}

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)

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

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

multiple data store in table

for (int i=0; i < this.listBox1.SelectedItems.Count; i++)
{


SqlConnection con = new SqlConnection("server=INFO-PROJECT4\\SQLEXPRESS;database=nss;integrated security=true");
con.Open();
SqlCommand cmd = new SqlCommand("insert into sss(city) values(@city)",con);

cmd.Parameters.AddWithValue("@city", listBox1.SelectedItems[i].ToString());
cmd.ExecuteNonQuery();
MessageBox.Show("success");
con.Close();

}

ASP.NET Grid View Insert,Update,select,Edit

Design:
Step 1:In edit column add 1 boundfield(E.No),5 templatefield(name,address,gender,qualification),1 templatefield(Edit),1 Command Field(delete--in property select show deleteButton).
Step 2: In Edit Template
Name - add label in item template ,textbox in edit template and footer template
similarly(address,gender,qualification,,edit)

aspx.cs page

using System;
using System.Collections;
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 parthigrid : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=iNFO-PROJECT4\\SQLEXPRESS;database=register;integrated security=true");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
view();
}


}
void view()
{

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from grid1 order by serialno asc", con);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
}




protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("insert"))
{
TextBox tfname = (TextBox)GridView1.FooterRow.FindControl("txtfname");
TextBox tffaddress = (TextBox)GridView1.FooterRow.FindControl("txtfaddress");
RadioButtonList rbtnffgender = (RadioButtonList)GridView1.FooterRow.FindControl("rbtnlfgender");
DropDownList ddfquali = (DropDownList)GridView1.FooterRow.FindControl("ddlfquali");
con.Open();
SqlCommand cmd = new SqlCommand("insert into grid1(name,address,gender,quali) values(@na,@add,@gen,@qual) ", con);
cmd.Parameters.AddWithValue("@na", tfname.Text);

cmd.Parameters.AddWithValue("@add", tffaddress.Text);

cmd.Parameters.AddWithValue("@gen", rbtnffgender.SelectedValue);

cmd.Parameters.AddWithValue("@qual", ddfquali.SelectedValue);
cmd.ExecuteNonQuery();
con.Close();
view();

}
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
TextBox txname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
TextBox txaddress = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtaddress");
RadioButtonList rbtngender = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("rbtnlgender");
DropDownList ddquali = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlquali");
con.Open();
SqlCommand cmd = new SqlCommand("update grid1 set name=@na,address=@ad,gender=@gen,quali=@qual where serialno=@i", con);
cmd.Parameters.AddWithValue("@i", id);

cmd.Parameters.AddWithValue("@na", txname.Text);

cmd.Parameters.AddWithValue("@ad", txaddress.Text);

cmd.Parameters.AddWithValue("@gen", rbtngender.SelectedValue);

cmd.Parameters.AddWithValue("@qual", ddquali.SelectedValue);

// cmd.Parameters.AddWithValue("@Country", Country);

cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;

view();
}




protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
con.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM grid1 where serialno=@i", con);
cmd.Parameters.AddWithValue("@i", id);
cmd.ExecuteNonQuery();
view();

}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
view();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
view();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
view();
}
}

Asp.Net Client side Validation using Java Script

This simple program will guide how to do client side validation of Form in

In this just make a form as follows:

Name : <asp:TextBox ID="txtName" />

Email : <asp:TextBox ID="txtEmail" />

Web URL : <asp:TextBox ID="txtWebUrl" />

Zip : <asp:TextBox ID="txtZip" />

<asp:Button ID="btnSubmit" OnClientClick=" return validate()" runat="server" Text="Submit" />

Now on the sourcecode of this form in script tag write the following code:

<script language="javascript" type="text/javascript">
function validate()
{
if (document.getElementById("<%=txtName.ClientID%>").value=="")
{
alert("Name Feild can not be blank");
document.getElementById("<%=txtName.ClientID%>").focus();
return false;
}
if(document.getElementById("<%=txtEmail.ClientID %>").value=="")
{
alert("Email id can not be blank");
document.getElementById("<%=txtEmail.ClientID %>").focus();
return false;
}
var emailPat = /^(\".*\"|[A-Za-z]\w*)@(\[\d{1,3}(\.\d{1,3}){3}]|[A-Za-z]\w*(\.[A-Za-z]\w*)+)$/;
var emailid=document.getElementById("<%=txtEmail.ClientID %>").value;
var matchArray = emailid.match(emailPat);
if (matchArray == null)
{
alert("Your email seems incorrect. Please try again.");
document.getElementById("<%=txtEmail.ClientID %>").focus();
return false;
}
if(document.getElementById("<%=txtWebURL.ClientID %>").value=="")
{
alert("Web URL can not be blank");
document.getElementById("<%=txtWebURL.ClientID %>").value="http://"
document.getElementById("<%=txtWebURL.ClientID %>").focus();
return false;
}
var Url="^[A-Za-z]+://[A-Za-z0-9-_]+\\.[A-Za-z0-9-_%&\?\/.=]+$"
var tempURL=document.getElementById("<%=txtWebURL.ClientID%>").value;
var matchURL=tempURL.match(Url);
if(matchURL==null)
{
alert("Web URL does not look valid");
document.getElementById("<%=txtWebURL.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=txtZIP.ClientID%>").value=="")
{
alert("Zip Code is not valid");
document.getElementById("<%=txtZIP.ClientID%>").focus();
return false;
}
var digits="0123456789";
var temp;
for (var i=0;i"<%=txtZIP.ClientID %>").value.length;i++)
{
temp=document.getElementById("<%=txtZIP.ClientID%>").value.substring(i,i+1);
if (digits.indexOf(temp)==-1)
{
alert("Please enter correct zip code");
document.getElementById("<%=txtZIP.ClientID%>").focus();
return false;
}
}
return true;
}
script>

And in code behind file just write the below code.

protected void Page_Load(object sender, EventArgs e)
{
btnSubmit.Attributes.Add("onClick", " return validate()");


}