Monday 15 October 2012

CAPTCHA Using Java Script

A CAPTCHA is a program that can generate and grade tests that humans can pass but current computer programs cannot. For example, humans can read distorted text as the one shown below, but current computer programs can't:The term CAPTCHA (for Completely Automated Public Turing Test To Tell Computers and Humans Apart) was coined in 2000 by Luis von Ahn, Manuel Blum, Nicholas Hopper and John Langford of Carnegie Mellon University. At the time, they developed the first CAPTCHA to be used by Yahoo.


Applications of CAPTCHAs

CAPTCHAs have several applications for practical security, including (but not limited to):
  • Preventing Comment Spam in Blogs. Most bloggers are familiar with programs that submit bogus comments, usually for the purpose of raising search engine ranks of some website (e.g., "buy penny stocks here"). This is called comment spam. By using a CAPTCHA, only humans can enter comments on a blog. There is no need to make users sign up before they enter a comment, and no legitimate comments are ever lost!

Monday 8 October 2012

Oracle SQL & PL/SQL Tutorial

making table in oracle  (With Primary Key and Not NULL)

create table stu(roll number(3) primary key,
                       name char(20) not null,
                       city char(20))

Create Table from an existing table


create table student as (select * from staff)

[This query will make a table named student with all row of staff table.Student table will take table structure as in staff table.You can make sure it by using desc student statement.You can also apple condition to get selected record from staff table]

Insert record from an existing table

       Syntax
              insert into <table_name> (select column_list from <table_name> [Condition]);
       Example 
              insert into Student (select * from stu);
      [ You can add condition for getting specific row from source table ]

ORDER BY

The ORDER BY keyword is used to sort the result-set by one or more columns.
The ORDER BY keyword sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword.
     Example
                  Select * from stu order by city
                  Select * from stu order by city desc
     [ Second query will show records in descending order ]

ALTER TABLE STATEMENT

Alter statement is used to alter a table i.e. to add/remove or modify a column
     Modify a column
         Syntax : 
                  alter table <table_Name
                  modify <column_name> <data_type>;
        Example :
                   alter table stu
                    modify name char(30);
       Add a column
         Syntax :
                  Alter table <table_name>
                   add column_name   Data_type
          Example :
                alter table student
                add sub varchar(20);
        Drop Column:
          Syntax:
               alter table <table_name>
               drop column <column_name>
          Example :
             alter table Student
             drop column sub;
         Rename a Column
            Syntax : 
               alter table <table_name>
              rename column Old_Name to New_Name
            Example :
                alter table ali
                rename column city to place
         Rename a Table
            Syntax:
                 alter table <table_name>
                  rename to new_name
            Example :
                alter table Stu
                rename to Student
Getting Last Row
 Oracle associate a column rowid with every record.This column put a unique number of a row in increasing order.We can apply min and max aggregate function on rowid.
you can see it by using following SQL Statement
       select rowid from student
 Last Row
      select * from t1 where rowid=(select max(rowid) from t1)
First Row 
     select * from t1 where rowid=(select min(rowid) from t1)
Delete two identical column.
    If any table has two identical row then rowid is useful to delete particular row row because rowid always has a unique value
Group and Having
Group- The Group by  clause is another section of the select statement . This option clause tells Oracle to group Rows based on distinct values that exist for specified column i.e. it create data set content several sets of records group together based on a condition
      Select sum(marks),class from the student
      group by class
  ( This query adds all the marks of related class )

 Having -The Having Clause can be used in conjunction with group by clause. Having imposes a condition on a group by clause which further filter the groups created by the group by clause
   Tips ! ( Use Rowid and find the unique rowid .Use this row id in delete statement)
SQL does not have not procedure capability that is SQL does not provide
the programming techniques of conditional checking looping and
branching that is vital for data testing before storage.
      Select sum(marks),class from the student
      group by class
      having sum(marks)>50
(This query will show all the class name which sum is greater than 50)
     Find the class marks which got highest marks
         select max(stumark) from (select max(marks) stumark from student group by class)
(This query will show the sum of highest marks form all classes )

Change Date format 
     select to_date(date_column,'YYYY-MM-DD') from table;
  • SQL statement are passed to the oracle engine one each time an SQL statement is executed
    a call is made to the engine resources.This adds to the traffic on the network there by deceasing,
    the speed of data processing, specially in a multi user environment.
  • While processing an SQL sentence if an error occurs the oracle engine displays its own Error messages. SQL has no facility for program handling of errors that arise during manipulation of data.
Steps for run PL/SQL
  • First type your PL /SQL code on oracle command prompt
  • Run code using /
  • If you want to edit your code use ed to open SQL Editor
Print Your name in PL/SQL

begin
     dbms_output.put_line('Hello PL/SQL');
end;
/

Sunday 7 October 2012

MSFlex Grid Operation in VB6.0

MS Flex Grid is a data grid which is use to retrieve records from database.It is very
Flexible, It Accept data run time from vb coding.It is useful for users who
interact database with coding . Coding is more powerful and flexible
than database controls (Data,ADODC).With the help of coding you can
run SQL statement in its original from as we use at command prompt
in oracle.Because Flex grid doesn't configure with database controls .You have
to configure it manually with the help of coding.There is not any row or columns
are predefine its programmer responsibility to make it. take a look on following
example.


 Controls
  •  MSFlexGrid1
Adding  Module
  • Click Project menu and Add a module

How to make setup in C# and VB.Net

Setup enable us to make our project run on real environment.
  • Open Visual studio click create project
  • Highlight Other project type tree and select Setup and Deployment
  • Select location provide name click ok
  • Now there are three option
    1. Application folder which comprise files when your software will install make a folder where your software will install
    2. User's Desktop comprise files which take place of user desktop after installation
    3. user's program menu comprise files which goes into start menu after installation
     
  • Now right click on folder where you want to put your files, Add > Files
  • Browse project folder find the exe file which is mostly reside in debug folder
  • Now Press F6
  • Now your setup is ready

Saturday 6 October 2012

CSS Tutorial

CSS stands for cascading style sheet. Which is used today to develop web
pages.CSS is useful to make style rule because HTML provides a limited
option for formatting CSS provide a rich amount of formatting
option.. you can implement CSS rule in many way...
  • Call by class
  • Call by id
  • Inline style
  • By HTML Tag
Call by class
In this type of CSS implementation we make a function type description like
C language. The name of rule start . in this type of rule. You can call
these rule more one time or any valid HTML tag using CLASS keywords
<style type="text/css">
        .border1
        {
            border:outset 5px red;
        }
    </style>
 <input type="button" value="Click me" class="border1" />
        <input type="text" class="border1" />
Call by ID
In this type of CSS rule we call CSS Using id of a HTML control because rule
name start with # symbol which is a ID of a HTML tag's id. This Rule call automatically when browser load
a page.

Wednesday 3 October 2012

Store Procedure for SQL Server Using C# and VB.Net

Store Procedure
Stored procedures can make managing your database and displaying information about that database much easier. Stored procedures are a recompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit. Stored procedures are stored within a database, can be executed with one call from an application, and allow user-declared variables, conditional execution, and other powerful programming features.
Stored procedures can contain program flow, logic, and queries against the database. They can accept parameters, output parameters, return single or multiple result sets, and return values.
You can use stored procedures for any purpose for which you would use SQL statements, with these advantages:
You can execute a series of SQL statements in a single stored procedure.
You can reference other stored procedures from within your stored procedure, which can simplify a series of complex statements.
The stored procedure is compiled on the server when it is created, so it executes faster than individual SQL statements.
The functionality of a stored procedure is dependent on the features offered by your database. For more details about what a stored procedure can accomplish for you, see your database documentation.

Monday 1 October 2012

Random number Application in Java Script

Random number are number which make
a random sequence of numbers.In many appliaction we need random number
sequence,for example creating roll number between 1 to 10, in java script you can get random number using Math.random()
which return a floating point number less than zero.
You can get number within a range by multiplying. If you want
integer number then use can use parseInt function..

Create Random Number Between 1 to 10
         function ranNumber()
        {
                    alert(parseInt(Math.random()*10));
        }
HTML..
   <body>
       <input type="button" value="Get Random Number" onclick="ranNumber()" />
  </body>

Change Text Color Randomly ..
         function ChangeTextColor()
        {
            var ob=document.getElementById('s3');
            ob.style.color='#'+parseInt(Math.random()*10)+''+parseInt(Math.random()*10)+''+parseInt(Math.random()*10)+''+parseInt(Math.random()*10)+''+parseInt(Math.random()*10)+''+parseInt(Math.random()*10);
            setTimeout("fun2()",1000);
        }

HTML...
<body onload= "ChangeTextColor()">
            <span id="s1"></span>
</body>

ASP.NET Cookies Management


A cookie is a small bit of text that accompanies requests and pages as they go between the Web server and browser. The cookie contains information the Web application can read whenever the user visits the site.
This topic contains:
  • Scenarios
  • Background
  • Code Examples
  • Class Reference
  • Additional Resources

Scenarios

Cookies provide a means in Web applications to store user-specific information. For example, when a user visits your site, you can use cookies to store user preferences or other information. When the user visits your Web site another time, the application can retrieve the information it stored earlier.

Background

A cookie is a small bit of text that accompanies requests and pages as they go between the Web server and browser. The cookie contains information the Web application can read whenever the user visits the site.
For example, if a user requests a page from your site and your application sends not just a page, but also a cookie containing the date and time, when the user's browser gets the page, the browser also gets the cookie, which it stores in a folder on the user's hard disk.