HOW TO ADD/SUB GOOGLE SPREADSHEET COLUMN

0 comments

HOW TO RESTORE GOOGLE SPREADSHEET INTO OLDER DATE

First take a look in the revisions (File->Revision history...) of the open document. You may be able to revert to the revision that contains your recent work.
0 comments

Joining Multiple Tables with SQL Inner Join Statements

SELECT * FROM drivers, vehicles, locations
WHERE drivers.location = vehicles.location
AND vehicles.location = locations.location
0 comments

How to pair Sony ericsson Bluetooth Headset with a phone?

Topair the headset in automatic pairing mode (this only works the very first time you turn on the headset):
1. To switch on the headset, press and hold the Call handling button for 5 seconds, until you hear a beep. The Call handling button is located on the front of the headset.
2. The indicator light will now flash red and green, which indicates that the headset is "Pairing mode".
3. In the phone, you now have to add the headset to the phone's list of Bluetooth devices. For detailed instructions, click on Product Information/Getting Started in the left hand navigation menu, or use the phone's user guide.
4. You have to enter a Bluetooth passkey in the phone. The default passkey is 0000.

To pair the headset in manually pairing mode:

1. Press both VOLUME BUTTONS, (+) and (-), at the same time for 5 seconds until your hear a beep.
2. The indicator light will now flash red and green, which indicates that the headset is in “Pairing mode”.
3. In the phone, you now have to add the headset to the phone's list of Bluetooth devices. For detailed instructions, click on Product Information/Getting Started in the left hand navigation menu, or use the phone's user guide.
4. You have to enter a Bluetooth passkey in the phone. The default passkey is 0000.
0 comments

How to give hyperlink to a label

FIRST ON CLICK EVENT WRITE Process.Start("http://www.icelabsolutions.com/")
Private Sub Label3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label3.Click
Process.Start("http://www.icelabsolutions.com/")
End Sub
SECOND STEP ON MOVES MOVE CHANGE CURSOR IMAGE
Private Sub Label3_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label3.MouseMove
Label3.Cursor = System.Windows.Forms.Cursors.Hand
End Sub
0 comments

How to change cursor icons in vb.net

Private Sub Label3_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label3.MouseMove

Label3.Cursor = System.Windows.Forms.Cursors.Hand

End Sub
0 comments

Mysql query for select last x rows

QUERY = "SELECT * FROM USER ORDER BY USERID LIMIT X
0 comments

HOW TO TAKE CURRENT DATE AND TIME FROM MYSQL DATABASE

For date
query= "SELECT CURDATE() "
For date and time
query = "SELECT now() "
ForTIME
query = "SELECT Curtime()"
0 comments

QUERY FOR CURRENT DATE AND TIME INSERT IN MYSQL DATABASE

For date
query_ = "INSERT INTO TABLE(dp_name, dp_date)VALUE ('anuraj)', CURDATE() )"
For date and time
query = "INSERT INTO TABLE (dp_name, dp_date_time)VALUE ('anuraj)', now() )"
ForTIME
query_ = "INSERT INTO TABLE (dp_name, dp_time)VALUE ('anuraj)',curtime() )"
0 comments

How to Type Prefix characters in Microsoft Word?

1. Select the text you want to make a superscript.
2. Press CTRL/SHIFT/=

DDDDDDTTT
0 comments

How to Type Suffix characters in Microsoft Word?

1. Select the text you want to make a superscript.
2. Press CTRL/=


ADDDDDDD
0 comments

Arithmetic Operators in php

OperatorDescriptionExampleResult
+Additionx=2
x+2		4
-Subtractionx=2
5-x		3
*Multiplicationx=4
x*5		20
/Division15/5
5/2		3
2.5
%Modulus (division remainder)5%2
10%8
10%2		1
2
0
++Incrementx=5
x++		x=6
--Decrementx=5
x--		x=4
0 comments

MESSAGE BOX YES/NO CONDITION IN ASP.NET (VB CODE)

Dim A As MsgBoxResult
A = MsgBox("DO YOU LOVE ME", MsgBoxStyle.YesNo, "143")

If A = MsgBoxResult.Yes Then
MsgBox("I LOVE YOU")
ElseIf A = MsgBoxResult.No Then
MsgBox("I HATE YOU")

End If
0 comments

Else if in php



<?php


if($a > $b):

echo $a." is greater than ".$b;

elseif($a == $b):

echo $a." equals ".$b;

else:

echo $a." is neither greater than or equal to ".$b;

endif;


?>

0 comments

How to remove borders Around Image Links

<A HREF="http://icelabsolutions.com/"><IMG SRC="web.gif"BORDER=0 HEIGHT=33 WIDTH=82 ALT="Idocs Guide to HTML"></A>
0 comments

How to remove underlines from links

Methodes for removeing underlines from links


1)add this in stylesheet style="text-decoration:none"


2) <a href="http://www.icelabsolutions.com" style="text-decoration:none">The Web Design </a>

0 comments

Read data from acess in vb.net

Imports System.Data

Public Class Form1
Dim DB As New DB_PROCESSOR

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click



Try
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\a.xls';Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [anu$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
Dim dt1 As DataTable = DtSet.Tables(0)
Dim i, j As Integer
j = dt1.Rows.Count

DataGridView1.DataSource = DtSet.Tables(0)
MyConnection.Close()
Catch ex As Exception
'MsgBox(ex.ToString)
End Try
End Sub
End Class
0 comments

Registration form in php


<html>

<head>


<title>test</title>

</head>

<body>

<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" >

<table width="400" border="1">

<tr>

<td>name</td>

<td><input type="text" name="user"/> </td>

</tr>

<tr>

<td>address</td>

<td><input type="text" name="address" /></td>

</tr>

<tr>

<td>pi</td>

<td><input type="text" name="pin" /></td>

</tr>

<tr>

<td>&nbsp;</td>

<td> <input type="submit" name="11"/> </td>

</tr>

</table>

</form>


<?php


if (isset($_POST['11']))

{


mysql_connect("localhost","root","");

mysql_select_db("test1");

$query="INSERT INTO `tablename` (`field1`, `field2`, `field3`) VALUES ('".$_POST['user']."', '".$_POST['address']."', '".$_POST['pin']."')";

mysql_query($query);

echo "Data inserted";

}

else

{


}

?>

</body>

</html>

1 comments

Read function in php

<?php

mysql_connect("localhost","root","");

mysql_select_db("test1");

?>

<table width="400" border="1">

<tr>

<td>sl number</td>

<td>field_name </td>

<td>field_pass </td>

<td>field_address </td>

</tr>

<?php

$i=1;

$query="Select * from tablename ";

$RES=mysql_query($query);

while($ROW=mysql_fetch_array($RES))

{

?>

<tr>

<td><?php echo $i ?></td>

<td><?php echo $ROW[1]; ?></td>

<td><?php echo $ROW[2]; ?></td>

<td><?php echo $ROW[3]; ?></td>

</tr>

<?php

$i=$i+1;

}

?>

</table>
0 comments

Registration form in php

Frist page reg.php(Registration page)


<form action="insert1.php" method="post" target="LoadData">

<table width="400" border="1">

<tr>

<td>Name</td>

<td> <input type="text" name="name" /></td>

</tr>

<tr>

<td>Password</td>

<td> <input type="password" name="name1" /> </td>

</tr>



<tr>

<td>Email</td>

<td ><label>

<textarea name="text"></textarea>

</label></td>

</tr>

<tr>

<td>&nbsp;</td>

<td > <input name="Rest" type="reset" id="Rest" value="Reset" /> <input type="submit" /> </td>

</tr>

</table></form>


Second form insert1.php(insert function page)


<?php

$name=$_REQUEST['name'];

$anu=$_REQUEST['name1'];


$text=$_REQUEST['text'];

mysql_connect("localhost","root",""); //Connecton String (database,usename,password)

mysql_select_db("test1");

$query="INSERT INTO tablename ( `field_name`, `field_pass`, `field_address`) VALUES ( '$name','$anu', '$text')";

echo $query;

mysql_query($query);

echo "value insert into database";

?>

0 comments

INSERT FUNCTION FOR PHP

INSERT FUNCTION FOR PHP

<?php
mysql_connect("localhost","root",""); //Connecton String (database,usename,password)
mysql_select_db("test1");
$query="INSERT INTO tablename ( `field_name`, `field_pass`, `field_address`) VALUES ( 'anurajs',' anu', 'address')";
mysql_query($query);
echo "value insert into database"
?>


0 comments

Mysql query for date format

if you wanted to change the format of a MySQL date from YYYY-MM-DD to MM/DD/YYYY or DD/MM/YYYY format you can use the DATE_FORMAT() function as shown in the example below:

SELECT DATE_FORMAT(field name, '%d/%m/%Y') FROM tablename

SELECT DATE_FORMAT(column_name, '%m/%d/%Y') FROM tablename
0 comments

Custom date Format in vb.net

Format specifier

Description

Examples

"d"

The day of the month, from 1 through 31.

6/1/2009 1:45:30 PM -> 1

6/15/2009 1:45:30 PM -> 15

"dd"

The day of the month, from 01 through 31..

6/1/2009 1:45:30 PM -> 01

6/15/2009 1:45:30 PM -> 15

"ddd"

The abbreviated name of the day of the week.

6/15/2009 1:45:30 PM -> Mon (en-US)

6/15/2009 1:45:30 PM -> Пн (ru-RU)

6/15/2009 1:45:30 PM -> lun. (fr-FR)

"dddd"

The full name of the day of the week.

6/15/2009 1:45:30 PM -> Monday (en-US)

6/15/2009 1:45:30 PM ->

6/

"f"

The tenths of a second in a date and time value..

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> 0

"ff"

The hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> 00

"fff"

The milliseconds in a date and time value.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> 000

"ffff"

The ten thousandths of a second in a date and time value..

6/15/2009 13:45:30.6175 -> 6175

6/15/2009 13:45:30.00005 -> 0000

"fffff"

The hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> 00000

"ffffff"

The millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> 000000

"fffffff"

The ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 0001150

"F"

If non-zero, the tenths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> (no output)

"FF"

If non-zero, the hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> (no output)

"FFF"

If non-zero, the milliseconds in a date and time value.

.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> (no output)

"FFFF"

If non-zero, the ten thousandths of a second in a date and time value.

.

6/1/2009 13:45:30.5275 -> 5275

6/15/2009 13:45:30.00005 -> (no output)

"FFFFF"

If non-zero, the hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> (no output)

"FFFFFF"

If non-zero, the millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> (no output)

"FFFFFFF"

If non-zero, the ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 000115

"g", "gg"

The period or era.

6/15/2009 1:45:30 PM -> A.D.

"h"

The hour, using a 12-hour clock from 1 to 12.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 1

"hh"

The hour, using a 12-hour clock from 01 to 12.

.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 01

"H"

The hour, using a 24-hour clock from 0 to 23.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 13

"HH"

The hour, using a 24-hour clock from 00 to 23.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 13

"K"

Time zone information.

With DateTime values:

6/15/2009 1:45:30 PM, Kind Unspecified ->

6/15/2009 1:45:30 PM, Kind Utc -> Z

6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings)

With DateTimeOffset values:

6/15/2009 1:45:30 AM -07:00 --> -07:00

6/15/2009 8:45:30 AM +00:00 --> +00:00

"m"

The minute, from 0 through 59.

6/15/2009 1:09:30 AM -> 9

6/15/2009 1:09:30 PM -> 9

"mm"

The minute, from 00 through 59.

6/15/2009 1:09:30 AM -> 09

6/15/2009 1:09:30 PM -> 09

"M"

The month, from 1 through 12.

6/15/2009 1:45:30 PM -> 6

"MM"

The month, from 01 through 12.

6/15/2009 1:45:30 PM -> 06

"MMM"

The abbreviated name of the month.

6/15/2009 1:45:30 PM -> Jun (en-US)

6/15/2009 1:45:30 PM -> juin (fr-FR)

6/15/2009 1:45:30 PM -> Jun (zu-ZA)

"MMMM"

The full name of the month.

6/15/2009 1:45:30 PM -> June (en-US)

6/15/2009 1:45:30 PM -> juni (da-DK)

6/15/2009 1:45:30 PM -> uJuni (zu-ZA)

"s"

The second, from 0 through 59.

6/15/2009 1:45:09 PM -> 9

"ss"

The second, from 00 through 59.

6/15/2009 1:45:09 PM -> 09

"t"

The first character of the AM/PM designator.

.

6/15/2009 1:45:30 PM -> P (en-US)

6/15/2009 1:45:30 PM -> 午 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"tt"

The AM/PM designator.

6/15/2009 1:45:30 PM -> PM (en-US)

6/15/2009 1:45:30 PM -> 午後 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"y"

The year, from 0 to 99.

1/1/0001 12:00:00 AM -> 1

1/1/0900 12:00:00 AM -> 0

1/1/1900 12:00:00 AM -> 0

6/15/2009 1:45:30 PM -> 9

"yy"

The year, from 00 to 99.

1/1/0001 12:00:00 AM -> 01

1/1/0900 12:00:00 AM -> 00

1/1/1900 12:00:00 AM -> 00

6/15/2009 1:45:30 PM -> 09

"yyy"

The year, with a minimum of three digits.

1/1/0001 12:00:00 AM -> 001

1/1/0900 12:00:00 AM -> 900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyy"

The year as a four-digit number.

1/1/0001 12:00:00 AM -> 0001

1/1/0900 12:00:00 AM -> 0900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyyy"

The year as a five-digit number.

1/1/0001 12:00:00 AM -> 00001

6/15/2009 1:45:30 PM -> 02009

"z"

Hours offset from UTC, with no leading zeros.

6/15/2009 1:45:30 PM -07:00 -> -7

"zz"

Hours offset from UTC, with a leading zero for a single-digit value.

6/15/2009 1:45:30 PM -07:00 -> -07

"zzz"

Hours and minutes offset from UTC.

.

6/15/2009 1:45:30 PM -07:00 -> -07:00

":"

The time separator.

6/15/2009 1:45:30 PM -> : (en-US)

6/15/2009 1:45:30 PM -> . (it-IT)

6/15/2009 1:45:30 PM -> : (ja-JP)

"/"

The date separator.

6/15/2009 1:45:30 PM -> / (en-US)

6/15/2009 1:45:30 PM -> - (ar-DZ)

6/15/2009 1:45:30 PM -> . (tr-TR)

"string"

'string'

Literal string delimiter.

6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P

6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P

%

Defines the following character as a custom format specifier.

6/15/2009 1:45:30 PM (%h) -> 1

\

The escape character.

6/15/2009 1:45:30 PM (h \h) -> 1 h

Any other character

The character is copied to the result string unchanged.

6/15/2009 1:45:30 AM (arr hh:mm t) -> arr 01:45 A

0 comments
Subscribe to: Posts (Atom)