Gateway Of Information Technology: July 2013

Tuesday, July 30, 2013

Database Commands

Student

    regno
    name
    emailid
    mobile

insert into student (regno,name,emailid,mobile)values('1001','jatinder','jatinder@yahoo.com','98989898')

delete a data from a table
string selectstr="

select * from tablename where

columnname='"+variablename+"'"

delete student
string delstr="delete student where regno='"+variablename+"'";

update data into the table

string selectstr="select * from tablename where columnname='"+variablename+"'"

string strregno=regno(columns from database)
string strname=name(columns from database)
string stremailid=emailid(columns from database)
string strmobile=mobile(columns from database)

txtregno.Text= strregno;
txtname.Text= strname;
txtemailid.Text= stremailid;
txtmobile.Text= strmobile;

Update

string updatestr="update student set name='"+variablename+"',emailid='"+variablename+"',mobile='"+variablename+"'
where regno='"+variablename+"'"

displaying data in a form

    all records
        Reports

    specific records

        command

    one record
        command

string selectstr="select * from tablename"

string selectstr="select * from tablename where columnname='"+variablename+"'"

string selectstr="select * from tablename where columnname='"+variablename+"' and columnname='"+variablename+"'"

insert into student(regno,name,emailid,mobile)values('1006','jatin','jatin@yahoo.com','981409999')
insert into student(regno,name,emailid,mobile)values('1002','inder','inder@yahoo.com','981409999')
insert into student(regno,name,emailid,mobile)values('1003','tinder','tinder@yahoo.com','981409999')
insert into student(regno,name,emailid,mobile)values('1004','jati','jati@yahoo.com','981409999')
insert into student(regno,name,emailid,mobile)values('1005','der','der@yahoo.com','981409999')

update student
set mobile='9814902980',name='satinder'
where regno='1002'

select * from student

select * from student where name='jatinder' and mobile='9814902957'

delete student where name='jatinder'

Saturday, July 27, 2013

First HTML Page

<html>
<head>
<title>
My First Page
</title>
</head>

<body bgcolor=ff6666>
<h2>About Me</h2>
<table border =1>
<tr><td><b>Name:</b></td><td> <i>Jatinder      Singh
Randhawa</i><br></td></tr>
<tr><td><b>Office Address:</b></td><td> NIIT Mall road<br></td></tr>
<tr><td><b>Phone:</b></td><td> 01832562301<br></td></tr>
<tr><td></td><td><img src="pic1.jpg" height=100 width=100/></td></tr>
</table>
<font face="Monotype Corsiva" size=10 color=red>Jatinder Randhawa</font>
<marquee behavior="alternate"><font face="Monotype Corsiva" size=10 color=red>Jatinder
Randhawa</font></marquee>

<marquee behavior="scroll" scrollamount="1" direction="up">Your upward scrolling text goes
here</marquee>

<marquee behavior="scroll" direction="left" onmouseover="this.stop();"
onmouseout="this.start();">Go on... hover over me!</marquee>

http://www.tutorialehtml.com/en/extras/marquee.php

</body>
</html>