One line Calculator.

Hi, Live Search, Google, Yahoo can also works like a calculator!!!

• Google Web Search Features
• Yahoo Search Feature

Lets try here...


Live Search result

Yahoo Search result

Some test for Google Search result

Read More

Defy All Challenges

Defy All Challenges is Microsoft site, to get graphical representation using flash technology.


Get information about Office 2007, Vista, Web development and Visual Studio Team System.

Also have some fun there, creating your own cartoon animation.


click here for HTML version.

Read More

Visual Studio 2008 Beta 2

Still, Just to days a go I have complete to download Visual Studio 2008 Beta 1, and do day I found that Visual Studio 2008 Beta 2 is released,

So, once again, I have started to download this new version.

• Download Visual Studio 2008 Beta 2
• Read more on Microsoft site.

Read More

Visual Studio Code Name “Orcas” Beta 1

Finally after two weeks hard download, I have "Orcas".

Download Visual Studio Code Name “Orcas” Beta 1

Here are some screen shots:

Select .Net Framework version direct form New project dialogbox.


Create C# and Visual Basic WPF Application

Office 2007 Workbook, document direct in Visual Studio as wall as Template and Add-In.

Office 2003 Workbook, document direct in Visual Studio as wall as Template and Add-In.

Worlflow Application

There are many feature in this version which was available in Team edition of Visual Studio 2005, now they are including in this version of "Orcas".

So, I have started to learn Visual Studio 2008, What about U?

Read More

Give attachment with blog.

We can start to give attachment with out blog.

box.net is a site where we can store our documents in a box and can be access them from anywhere.


easy to upload Images, Word document, PDF Files etc.

here is there result in a blog. There is also change view icon in top right corner.

This box is use uses Flash Player for the result.

Read More

Online Chat!

Meebo is a great online chat application where AIM, Yahoo, Google and MSN Chat is possible in one browser only.

Read More

How to find missing number form a table?

Please Give me the solution,

Today I had a requirement that I have to get missing number form table and start new ID form that missing value...

Ex. I have a customer table.

ID Name
1 Vijay
2 Rajesh
3 Nitin
5 Manish
6 Bipin
8 Jalpesh

Here, 4 and 7 number are missing, some one have deleted that record. and now suppose user click on add new button he want to generate that missing number.

Here a I have create a small cursor to get that value:


DECLARE @lastID int,
@crrID int

SET @crrID=1;

DECLARE curJob CURSOR FORWARD_ONLY READ_ONLY LOCAL
FOR
SELECT ID FROM Customer ORDER BY ID

OPEN curJob

FETCH NEXT FROM curJob INTO @lastID

WHILE @@FETCH_STATUS = 0 AND @crrID=@lastID
BEGIN
SET @crrID=@crrID+1
FETCH NEXT FROM curJob INTO @lastID
END

CLOSE curJob
DEALLOCATE curJob

SELECT @crrID;


Done. This SQL satisfied my requirement.

But Its now a good idea where thousands of records in a table, I think that there should be some in built functions of SQL Server 2005, who can get me those missing values without any coding and quickly also.

Do you know any other solution?

Read More

Make change in EXE of DLL using Visual Studio 2005

You can change executable or DLL files using IDE, not a completely but most improbably.

You can make change in

• Design of almost executable file
• Icons of the application
• Menu name
• Button caption

Here I m trying to change in calculator...

Regular calculator.

Go to System32 folder select Calculator.exe file, Drag this icon in IDE, of open file form File menu of IDE.


See Here, Calc.exe in Visual Studio 2005

Open calculator design and make some change.


Now, Save that file As EXE, remember that click on "Save Calc.exe As..." menu.


Save file and open that file directly using double click.

New calculator is ready to work.

You can be a one kind of hacker, but I m trying here to show just knowledge.

Read More

Send attachement in mail with big size.

I thick Google, Yahoo etc. mail server does not allow more then 10MB.

But here "Mail Big File" allows 100MB of attachment free.

easy three steps.

Read More

Quick Start Example to Read Write XML data using DataSet.

It's very easy to work XML data file with DataSet.
It's just 2 line of code to Read or Write.
Here I have a XML file...

<?xml version="1.0" standalone="yes"?>

<App xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<value>Some Value1</value>

<value>Some Value2</value>

<value>Some Value3</value>

</App>

Here I'm using Visual Studio 2005 and C# language.

now right down this code in some form load event or in button click event.

//variable and dataset name
System.Data.DataSet ds = new System.Data.DataSet("myDataSet");

//file path to read xml
ds.ReadXml(Application.StartupPath + "\\myfile.xml");

//done. Start to read file.
MessageBox.Show(ds.Tables[0].Rows[0][0].ToString());
//here you will show "Some Value1" from xml file.


//Start to write file.
//change some value.
ds.Tables[0].Rows[0][0]="new value.";

//write file.
ds.WriteXml(Application.StartupPath + "\\myfile.xml");


Done.

Read More

My First User Defined Function in Excel.

With Visual Studio 2005 and Microsoft Office 2007 or 2003, I have created my own formula.



Open Visual Studio -> New -> Project.
Select "Class Library"

Your project name will show in Excel's Formula dialogbox.

Now you have a "Class1.vb" in your Solution Explorer.

Now right down this code in your Class file....

'imports required name space
Imports System.Runtime.InteropServices
Imports Microsoft.Win32


<ClassInterface(ClassInterfaceType.AutoDual), ComVisible(True)< _
Public Class Class1

'this is for automatically register the function in excel.
<ComUnregisterFunctionAttribute()> _
Public Shared Sub RegisterFunction(ByVal type As Type)
Registry.ClassesRoot.CreateSubKey(GetSubKeyName(type))
End Sub

'this is for to unregister the function from excel.
<ComUnregisterFunctionAttribute()> _
Public Shared Sub UnregisterFunction(ByVal type As Type)
Registry.ClassesRoot.DeleteSubKey(GetSubKeyName(type), False)
End Sub

Private Shared Function GetSubKeyName(ByVal type As Type) As String
Dim s1 As String
s1 = "CLSID\{" & type.GUID.ToString().ToUpper() & "}\Programmable"
Return s1.ToString()
End Function


'this is Excel custom formula "myTestFormula"
Public Function myTestFormula(ByVal anyNumber As Double) As Double
Dim result As Double = anyNumber * 2
Return result
End Function

End Class

------------------
ok, open project properties form Project menu.

click on "Compile" Tab. and check a "Register for COM imterop" option.

now save all file of the project. and build solution pressing F6.

Ok, user defined function has been created. now we have to give reference to Excel for this formula.

• Open Microsoft Excel 2007
• open "Excel Options" from office button icon.
• click on "Add-Ins" tab.
• Click on "Go" button under Manage Excel Add-ins list.
• It will show Add-Ins dialog box.

• Click on Automation button.
• Under Automation Services dialogbox fine out ProjectName.ClassName.
• here I have "myExcelFormula.myFunctions" or like that.
  

click on OK.
it done.

now type your formula and pass it argument and you will get the result.

here you will get the result 10 (5*2)

it's g. using this method I am creating a Bill for a form. This is a print preview of a Bill using user defined function where database is MS Access, Software is Created in VB6.0 and this formula created from Visual Studio 2005.

Read More

Advertisement by Mobile Phone Ringtone in India

Advertisement Every!

I have never read or listen about advertisement via mobile phone ring tone in India.

I think that it possible that your cell some and you heard some advertisement in place of ringtone.

Communications Company like Airtel, Hutch, Reliance, Tata should have to use ringtone as commercializations. That if some person is selecting "XYZ" company's ting tone, that person get some money free in his bill. that amount depends on his incoming cell.

Is any one ready???

Read More

SilverLight Game!

"Zero Gravity" I played many times in Flash, but first time any game which one created in SilverLight 1.1 Alpht.

Click here to play it.

Click here to find more information about this game.

Read More