Programming ideas

Malayalam calendar 2015 Free Download

2014-11-28T00:11:00.002-08:00

Malayalam calendar 2015 Free Download Link

my sql timeout expired in vb.net using data adapter

2012-12-27T21:22:00.000-08:00

Error :timeout expired the time out period to completion of the operation or the server is not responding Solution Public Function read(ByVal str As String) As DataTable Dim dt As DataTable = New DataTable() Try Dim sql As MySqlCommand = New MySqlCommand(str, con) Dim DataAdapter1 As MySqlDataAdapter = New MySqlDataAdapter() DataAdapter1.SelectCommand = sql DataAdapter1.SelectCommand.CommandTimeout = 0 DataAdapter1.Fill(dt) Catch ex As Exception MessageBox.Show(ex.Message) Finally If con.State = ConnectionState.Open Then con.Close() End If End Try Return dt End Function

How to Change default search engine of FireFox address bar

2012-02-23T23:23:00.003-08:00

1)Open about:config in Firefox
2)Search for keyword.url from the filter box.
3)change keyword.url to "http://www.google.co.in/search?hl=en-GB&q="

Create MDI Child Forms

2011-01-05T22:34:00.000-08:00

Private Sub CourseFeeToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CourseFeeToolStripMenuItem.Click

Dim NewMDIChild As New Frm_course_fee()
'Set the Parent Form of the Child window.
NewMDIChild.MdiParent = Me
'Display the new form.
NewMDIChild.Show()
End Sub

Please note main form ismdicontainer=true

HOW TO ADD/SUB GOOGLE SPREADSHEET COLUMN

2010-10-31T06:15:00.000-07:00

HOW TO RESTORE GOOGLE SPREADSHEET INTO OLDER DATE

2010-10-31T06:14:00.000-07:00

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.

Joining Multiple Tables with SQL Inner Join Statements

2010-10-26T03:06:00.000-07:00

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

How to pair Sony ericsson Bluetooth Headset with a phone?

2010-10-23T20:14:00.000-07:00

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.

How to give hyperlink to a label

2010-10-11T03:59:00.000-07:00

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

How to change cursor icons in vb.net

2010-10-11T03:56:00.000-07:00

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

Mysql query for select last x rows

2010-10-10T23:42:00.000-07:00

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

HOW TO TAKE CURRENT DATE AND TIME FROM MYSQL DATABASE

2010-10-08T00:13:00.000-07:00

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

QUERY FOR CURRENT DATE AND TIME INSERT IN MYSQL DATABASE

2010-10-08T00:08:00.000-07:00

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() )"

How to Type Prefix characters in Microsoft Word?

2010-10-05T09:26:00.000-07:00

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

DDDDDDT^TT

How to Type Suffix characters in Microsoft Word?

2010-10-05T09:23:00.000-07:00

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

ADDDDD_DD

Arithmetic Operators in php

2010-09-10T03:10:00.000-07:00

Operator	Description	Example	Result
+	Addition	x=2 x+2	4
-	Subtraction	x=2 5-x	3
*	Multiplication	x=4 x*5	20
/	Division	15/5 5/2	3 2.5
%	Modulus (division remainder)	5%2 10%8 10%2	1 2 0
++	Increment	x=5 x++	x=6
--	Decrement	x=5 x--	x=4

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

2010-09-08T05:27:00.000-07:00

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

Else if in php

2010-08-31T03:34:00.000-07:00

<?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;

How to remove borders Around Image Links

2010-08-31T03:23:00.000-07:00

How to remove underlines from links

2010-08-31T03:19:00.000-07:00

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>

Read data from acess in vb.net

2010-08-19T02:19:00.000-07:00

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

Registration form in php

2010-04-16T10:14:00.000-07:00

<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> </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>

Read function in php

2010-04-16T04:34:00.000-07:00

<?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>

Registration form in php

2010-04-16T03:58:00.000-07:00

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> </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";

?>

INSERT FUNCTION FOR PHP

2010-04-16T02:48:00.000-07:00

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"
?>