Aspdotnet.Sunil Kumar

Sunday, June 01, 2014

JavaScript setTimeout Function Example

Introduction:

Here I will explain how to use JavaScript setTimeout function with example.JavaScript setTimeout()function is used to execute functions at regular intervals of time. Suppose if we want to execute oneJavaScript function for every 10 seconds or for a specific time we can use JavaScript setTimeout function to achieve this functionalit.

----------------For complete example check below code--------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>JavaScript display current time on webpage</title>

function ShowCurrentTime() {

var dt = new Date();

document.getElementById("lblTime").innerHTML = dt.toLocaleTimeString();

setTimeout("ShowCurrentTime()", 1000); // Here 1000(milliseconds) means one 1 Sec

}

</script>

</head>

<div>

JavaScript Display current time second by second:

</div>

</body>

</html>

Registration Form Validation in JavaScript Source Code Using Asp.net

Introduction

Here I will explain how to validate user registration form in JavaScript with source code or JavaScript user registration form validation.

To implement this we need to write the code as shown below

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Registration Form Validation in JavaScript Source Code</title>

function validate() {

var summary = "";

summary += isvaliduser();

summary += isvalidFirstname();

summary += isvalidLocation();

if (summary != "") {

alert(summary);

return false;

}

else {

return true;

}

function isvaliduser() {

var uid;

var temp = document.getElementById("<%=txtuser.ClientID %>");

uid = temp.value;

if (uid == "") {

return ("Please Enter UserName" + "\n");

}

else {

return "";

}

function isvalidFirstname() {

var uid;

var temp = document.getElementById("<%=txtfname.ClientID %>");

uid = temp.value;

if (uid == "") {

return ("Please enter firstname" + "\n");

}

else {

return "";

}

function isvalidLocation() {

var uid;

var temp = document.getElementById("<%=txtlocation.ClientID %>");

uid = temp.value;

if (uid == "") {

return ("Please enter Location" + "\n");

}

else {

return "";

}

</script>

</head>

<body>

<tr>

<td>UserName</td>

</tr>

<tr>

<td>First Name</td>

</tr>

<tr>

<td>Location</td>

</tr>

<tr>

<td>

<asp:Button ID="btnsubmit" runat="server" Text="Save"

OnClientClick ="javascript:validate()" />

</td>

</tr>

</table>

</form>

</body>

</html>

Saturday, May 31, 2014

Sql Query (Date,Distinct,Constraint,When,Group By,Having Clause)

How to get Date from sql Sever in different way………………………………………………….

v print getdate() Aug 4 2014 11:31PM

v select sysdatetime() 2014-08-03 23:31:11.6113785

v Select Cast(Sysdatetime() as Date) 2014-08-04,

v Select convert(date,Sysdatetime()) 2014-08-04,

v Select Datepart("yy",getdate()) 2014

v Select Datepart("mm",getdate()) 8

v Select Datepart("dd",getdate()) 4

v Select Datepart("yyyy",getdate()) 2014

******************************************************************************

Use Group By in Sql Server.....................................

Create Database SqlDatabe

Create Database Sqldatabase

Create table student using Database Sqldatabase

use Sqldatabase

create table student (Id int ,item int)

insert item in student table

insert into student values(2,49)

insert into student values(1,55),(3,44),(4,45)

select * from student

select id ,Sum(item) as ToalItem from student group by id

Note: where clause is not support for filtering data from table with aggregate function, it provides by Having clause in sql server

select id ,sum(item) as totalitem from student group by id having sum(item)>=45

How to get difference dob with current date…………….with using

Create table Stu_Dob using Database SqlDatabase

use SqlDatabase

create table Stu_Dob (Id int,Name nvarchar(50) ,dob date)

Insert data into table Stu_Dob

insert into Stu_Dob values(1,'sunil kumar','08/10/1990'),(2,'Naveen kumar','07/1/1985'),(3,'mohit singh','11/2/1996'),(4,'rohit kumar','5/10/1990')

Select data from table Stu_Dob

How to calculate age with help date of birth current with using datediff(),getdate() function

select id,Name,Age=datediff("yy",dob,getdate()) from Stu_Dob

select id,Name from Stu_Dob where month(dob)=8

select id,Name from Stu_Dob where year(dob)=1990

select id,Name from Stu_Dob where day(dob)=1

Problem : suppose we have a table of Emp where three field are labled as follows

a. Id

b. Gender

c. Age

v If the age is above 40 it will be replaced by ‘Old’ otherwise ‘New’

v If the gender is ‘Male’ the query will replace it by ‘Femail’

v When we executed this query reputation of age is remove by distinct keyword

First we create a table Emp inside database test apply CONSTRAINT key word on Gender you can only insert 'Male','Female' after applying constraint

use test

create table Emp(Id int IDENTITY(1,1) ,Gender nvarchar(10)CONSTRAINT Gender_CONSTRAINT CHECK (Gender IN ('Male','Female')),Age int)

insert record in table Emp

insert into Emp values('Male',65)

select record from table Emp

Select * from Emp

Case:1Select Id,Age_Type=case when Age>40 then 'Old' else 'New' end from Emp

Case:2update Emp set Gender=case when Gender='Male' then 'Female' else 'Male' end

Case:3

Reputation will be removed by distinct keyword in Sql Server

Select distinct age from Emp

Aspdotnet.Sunil Kumar

Share Blog

Sunday, June 01, 2014

JavaScript setTimeout Function Example

Registration Form Validation in JavaScript Source Code Using Asp.net

Saturday, May 31, 2014

Sql Query (Date,Distinct,Constraint,When,Group By,Having Clause)

BLOG ARCHIVE