Wednesday 10 April 2013

Connect VB 6.0 with Oracle and SQL Server

Hi...
Database is the heart of any business application. When we make any software then most of the  things floats near of database. As we know oracle is the most popular database in the world connecting oracle to your VB application is very simple simple. take a look on following and please don't tell me thanks..

  • Import a class reference for Project > References
  • Add Microsoft ActiveX Data Objecs 2.8 Library from references
  • Make an object of ADODB.Connection
  • Open DB Connection Consider the connection string
  • Rest of the things are same as you do with access database

Dim con As New ADODB.Connection
    con.Open "Provider=MSDAORA.1;User id=scott;password='tiger';Persist Security Info=False"
    con.BeginTrans
    con.Execute "insert into vb values(110,'niraj','lanka')"
    con.CommitTrans
    MsgBox "Saved"

SQL Server

Table Name Stu(Roll number,Name varchar2(20),City varchar2(20)), Import Microsoft Active Data Objects 2.0 from Project>References

Save Button Code


 con.Open "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bsw"
con.BeginTrans
    con.Execute "insert into stu values(" & Text1.Text & ",'" & Text2.Text & "','" & Text3.Text & "')"
    con.CommitTrans

Friday 5 April 2013

Photo Shop Tutorial


Hi there....
I love photoshop because its provide wing to my imagination. I am taking lots of advantage of powerful tools of photoshop.You can enhance quality of your designing using this tutorial . I do not have any specific degree about photoshop I just make this tutorial which help you to make some type innovative graphics.Now Get start.....
Text Effect
  
Photoshop provide separate tool for text which create a separate layer when you write text.

Text Effect with hole
Develop By Raj Kumar
  • Type your text
  • Add a layer up side of text layer
  • Click on text layer and newly added layer border with alt key. It’ll merge text and normal layer. Now you can use brush tool for color (Because brush tool can not be apply directly on text layer)
  • Apply shadow  and other effect using Layer style by double click on text layer
  • Apply mask on text layer
  • Choose brush make high percentage of hardness and opacity
  • Move brush on text 

Tuesday 12 March 2013

How to stop mouse right click on a webpage

There are many cases when we don't allow users to see our source code.Enabling source code by right click provide option to users to load images of our site and see logic we you used to make your website.You can disable right click using java script paste the following code on your head section and see the magic
Paste this code on header section

<SCRIPT LANGUAGE="JavaScript">  
<!-- Disable  
function disableselect(e){  
return false  
}  

function reEnable(){  
return true  
}  

//if IE4+  
document.onselectstart=new Function ("return false")  
document.oncontextmenu=new Function ("return false")  
//if NS6  
if (window.sidebar){  
document.onmousedown=disableselect  
document.onclick=reEnable  
}  
//-->  
</script>

Monday 4 March 2013

How to use Google Translater on your web page

Google Translator provide a efficient way to translate your page in many language which make your webpage able to read person who wish to see your web page on his own language. Google provides some steps and translator will appear on your page follow the steps



  • Go to This address
    https://translate.google.com/manager/website/suggestions
  • Log in with your Google id

Wednesday 20 February 2013

How to show youtube video on your web page and How to Delete Youtube History

  • Log in YouTube
  • Upload your video
  •  Click on your profile name which is left side 






  • Now select your video which you want to show
  • Click share then embed
  • Copy the selected html code provide by you tube
  • Paste this html code where you want to show  your video











How to Delete Youtube Watch History

Monday 18 February 2013

How to get query string using java script

In the World Wide Web, a query string is the part of a uniform resource locator (URL) that contains data to be passed to web applications.Using query string user can pass the some data with URL that helps to take some action.I am representing an example which help you to find data with URL


Passing query string<a href="demo.htm?item1">Item </a>

Wednesday 16 January 2013

Make Vertical Line Using HTML

As we know <hr> tag is use to make horizontal line.But many time there is a need of make a vertical line we can not be possible  using hr ....But I Make with a trick that is table you can change a cell of a table in vertical line how?? take a look on following code..

<table cellspacing="5" border="0" cellpadding="1">
<tr valign="top" align="left">
<td width="300"><p>Put your page content</p></td>
<td width="1" bgcolor="#00FFEE"><br /></td>
<td width="100" valign="top" align="left">
<p>Enter Your Text</p>
<p>Girfa<br>Girfa<br>Girfa</p>
</td>
</tr>
</table>

Sunday 23 December 2012

SQL Tutorial

SQL stands for  Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
Originally based upon relational algebra and tuple relational calculus, its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
If one has knowledge of SQL then h/she can work any type of database package running in market becouse  SQL is supported by all DBMS software. So if you have knowledge of SQL then no need to worry what type of Database we have to use chilllll have a look.SQL statement are divide in three part
  • DML (Data Manipulation Language )
  • DDL ( Data Definition Language ) 
  • DCL (Data Control Language )

Tuesday 18 December 2012

News Ticker

News are a very import part of every organization. There are many types of news in any organization which need to be print in a impressive manner because It has to attract person to read news.In web development there are many way to print news but my idea is tricky.You can make your news ticker with the help of flat HTML tag no need to use any other specific software.I use MARQUEE ,DIV,TABLE to implement it take a look 


HTML Code

 <table>
        <tr>
            <td style="background-color:Aqua">News Ticker</td>
        </tr>
        <tr>
            <td style="border:solid aqua 1px">
                <div style="width:200px;height:200px">
                    <marquee direction="up" onmousemove="this.stop()" onmouseout="this.start()"  scrollamount="2">
                        <a href="#">Girfa Help</a> <br /><br />
                        <a href="#">Girfa Help</a> <br /><br />
                        <a href="#">News Three </a> <br /><br />
                        <a href="#"> Insert your news here </a><br />
                    </marquee>
                </div>
            </td>
        </tr>
    </table>

Tuesday 11 December 2012

Sorting

In computer science, a sorting algorithm is an algorithm that puts elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. Efficient sorting is important for optimizing the use of other algorithms (such as search and merge algorithms) that require sorted lists to work correctly; it is also often useful for canonicalizing data and for producing human-readable output. More formally, the output must satisfy two conditions:
  1. The output is in nondecreasing order (each element is no smaller than the previous element according to the desired total order);
  2. The output is a permutation (reordering) of the input.

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.

Sunday 30 September 2012

Change Browser Title & Get The Current page URL Using Java Script

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Girfa......</title>
    <script language=javascript>
        function tit()
        {

            top.document.title=document.forms[0].t1.value;       
        }
        function geturl()
        {
            alert(document.URL);          
        }
       
        function tmp()
        {
            alert();           
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
   
        Enter Title :
        <input type="text" id="t1" />
        <input type=button value="Change Title " onclick="tit()" />
        <br />
        <br />
         <input type=button value="Get URL " onclick="geturl()" />                   
    </form>
</body>
</html>

Picture Gallery Using Java Script With Fade Effect Change

Picture Gallery is use to show picture on a website.When there are
more than one picture has to be show then we use picture gallery
Which change pictures automatically.I'm here make a picture
gallery which change automatically with fade effect.I have save
my all picture on my current project and renamed them 1,2,3.....n
I want give credit of this gallery to http://www.cryer.co.uk

HTML Code...

<html >
<head >
    <title>Girfa Photo Gallery Demo</title>
    <script type="text/javascript">