My Knowledge

how can I display tooltip in cell at excel

noreply@blogger.com (Unknown) — Wed, 10 Oct 2007 01:40:00 -0700

In excel how can I display tooltip sort of information while typing in a cell in excel.

Select the cells, choose Data->Validation from the menu, then enter your message on the 'Input message' tab and OK out

Error: There is no MTS object context

noreply@blogger.com (Unknown) — Wed, 10 Oct 2007 01:38:00 -0700

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: There is no MTS object context

Source Error:

Line 36:
Line 37: // Save to memory. All parameters omitted
Line 38: int Count = objUpload.Save(Missing.Value, Missing.Value, Missing.Value);
Line 39:
Line 40:

Here is exception details given by VISUAL STUDIO.NET 2005

System.Runtime.InteropServices.COMException was unhandled by user code
Message="There is no MTS object context\r\n"
Source="Persits.Upload.1"
ErrorCode=-2146828221
StackTrace:
at ASPUPLOADLib.UploadManagerClass.Save(Object Path, Object Key, Object Ext)
at ASP.admin_upload_aspx.Page_Load(Object Source, EventArgs E) in e:\some folder name\some folder name\Upload_Sites.aspx:line 38
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Solution:
1.Add < aspcompact="true"> the beginning of the aspx file like this..
2. Add Transaction="Required" the beginning of the aspx file like this..

example
<%@ Page Language="vb" SmartNavigation="true" AutoEventWireup="false" Codebehind="Form25NoticeCessation.aspx.vb" Inherits="Licensing.Form25NoticeCessation" Transaction="Required"%>

Error Message: 8447: Internet Server Error

noreply@blogger.com (Unknown) — Thu, 27 Sep 2007 02:24:00 -0700

SYMPTOMS

When you run ASP pages using a Microsoft Remote Data Service (RDS) connection to a database, the following error message may appear in the browser:

8447: Internet Server Error

The same error message appears if you run the Adctest.asp sample file.

CAUSE

This error message may be caused by one of the following:

•	The virtual directory for RDS in the Default Web Site has been removed. -OR-
•	RDS was not installed properly.

WORKAROUND

If the physical files for RDS still exist and only the virtual directory for RDS was accidentally removed, use the following steps to restore the RDS virtual directory:

1.	Re-create the virtual directory named MSADC in the Default Web Site using the wizard. Map this virtual directory to <drive letter>:\Program Files\Common Files\System\Msadc. Enable Read and Execute (including Script) permissions.
2.	Right-click the virtual directory that you just created, and the select Properties. On the Virtual Directory tab, select Application Settings, and then click the Remove to delete any name in the Name box and point the application starting point to the Default Web Site. The Create button will now be available.
3.	Stop and start the Default Web Site.
4.	In Windows NT Explorer, check the physical file and folder permissions for Program Files\Common Files\System\Msadc. The minimum permissions should be Everyone: READ.
5.	Test ASP with RDS. You can use the Adctest.asp sample file included with the IIS in the <drive letter>:\Program Files\Common Files\System\Msadc\Samples directory.

If RDS is not installed correctly or the physical files in the Program Files\Common Files\System\Msadc directory are corrupted, RDS can be installed independently. For information on RDS, please see the following Web page:

http://msdn.microsoft.com/library/en-us/dnoledb/html/usingthecustomizationhandlerfeatureinrds21.asp (http://msdn.microsoft.com/library/en-us/dnoledb/html/usingthecustomizationhandlerfeatureinrds21.asp)

The version included with the Windows NT Option Pack (NTOP) is Microsoft Data Access Components (MDAC) version 1.5 with RDS version 1.5. Because RDS is part of MDAC, it is recommended that you upgrade MDAC if RDS needs to be reinstalled.

Encrypting & Decrypting Connection string at webconfig

noreply@blogger.com (Unknown) — Thu, 27 Sep 2007 01:40:00 -0700

Encrypting Connection string

Enter the userid & password in the connection string section of the Web.Config file. The connection string property can be encrypted using the following command:

Example:

aspnet_regiis.exe –pef “connectionStrings” “D:\Services” –prov “DataProtectionConfigurationProvider”

The aspnet_regiis.exe command can be found in the %WINDOWDIR%\Micorsoft.Net\Framework\version directory. The command can also be run directly if the dos prompt is opened from the Visual Studio SDK.

Decrypting Connection string

To change the userid or password, the connection string can be decrypted using the following command:

Example:

aspnet_regiis.exe –pdf “connectionStrings” “D:\Services”

Comments Posted for DevASP.Net Article

noreply@blogger.com (Unknown) — Mon, 24 Sep 2007 00:52:00 -0700

http://www.devasp.net/net/articles/display/276.html

so easy..

Comments Posted for DevASP.Net Article

noreply@blogger.com (Unknown) — Mon, 24 Sep 2007 00:52:00 -0700

http://www.devasp.net/net/articles/display/276.html

so easy..

How to set proxy at regedit for IE

noreply@blogger.com (Unknown) — Fri, 21 Sep 2007 00:10:00 -0700

1. Go to regedit
2. At path HKEY_CURRENT_USER > Software > Microsoft > Windows > CurrentVersion > Internet Settings
3. At key ProxyServer enter value Proxy - 192.168.2:1212
4. Add Key ProxyOverride with value 10.21..;10.26..;10.55..;<local> . This key use for to access intranet.

How to download video from YouTube

noreply@blogger.com (Unknown) — Wed, 19 Sep 2007 21:33:00 -0700

STEP 1: 1. Go to YouTube and get find the movie you want

STEP 2: 2. Right click on a blank bit of the screen

STEP 3: 3. Click view page source

STEP 4: 4. Type Ctrl+F

STEP 5: 5. Search for player2.swf

STEP 6: 6. You should get something that looks like this ->

STEP 7: 7. Select all the text after video_id= and before the speech mark, this text has been highlighted in the image

STEP 8: 8. Go to www.youtube.com/get_video?video_id=

STEP 9: 9. Paste the text after video_id=

STEP 10: 10. Click enter

STEP 11: 11. Save the file to your desktop (you may need to click file in the top left of the page then click save page as)

STEP 12: 12. Go to http://media-convert.com

STEP 13: 13. Click the “browse” button next to the white box

STEP 14: 14. Select the file you just got from youtube (usually called get_video)

STEP 15: 15. On the drop down box to the right scroll to the bottom and select “flash video .flv”

STEP 16: 16. Scroll down the page until you see

STEP 17: 17. If you are putting this on your phone go to step 18, if you just want to watch it on your PC go to step 21

STEP 18: 18. Does your phone or mobile device play .3gp movies? If yes go to step 19, if no go to step 20 (if you don’t know assume that it can play .3gp movies)

STEP 19: 19. It should say .3gp in the drop down box, if it doesn’t select .3gp from the drop down menu, go to step 22

STEP 20: 20. Select .mp4 from the drop down menu (there are many types of mp4 in the menu, if you have a PSP select PSP .mp4, if you have a Ipod video select Ipod video .mp4, if it is another type of movie player like a phone select mpeg-4 .mp4) Go to step 22

STEP 21: 21. Select Motion Picture Experts Group .mpg from the dropdown menu, go to step 22

STEP 22: 22. Click I accept the terms

STEP 23: 23. Click Convert

STEP 24: 24. Wait until you see this screen (it may take a long time if the movie is long)

STEP 25: 25. Click download and save it to your desktop

STEP 26: 26. Put it on your phone, Ipod, PSP or watch it on your computer

STEP 27: 27. This is a very complicated process; if it doesn’t work then it probably will never work.

How to Create Computer Sticky Notes With Outlook

noreply@blogger.com (Unknown) — Wed, 19 Sep 2007 21:31:00 -0700

Outlook sticky notes are electronic versions of paper Post-it notes (just like Macintosh Stickies). You can create a sticky note in Outlook 97, 98, or 2000 and insert it anywhere on your screen.

Instructions

STEP 1: Select New from the File menu. Click Note.

STEP 2: Enter text when the note appears on your screen. Text is automatically saved.

STEP 3: Drag the note wherever you want it.

STEP 4: Click the close button to close the note without deleting it.

Tips & Warnings

You can also create a new note by opening the Notes section of Outlook and clicking the New Note button on the taskbar or by pressing Control+Shift+N from anywhere in the program.

Click the Notes icon in the left-most Outlook pane to view saved notes.

Delete a saved note by clicking on it and pressing the Delete key.

Change the background color of a note by right-clicking on it and selecting Color.

How to get value in datagrid based on selected row

noreply@blogger.com (Unknown) — Wed, 19 Sep 2007 21:27:00 -0700

Dim activityId As Integer

activityId = dgActivity.Items(e.Item.ItemIndex).Cells(0).Text

Internet Explorer Favorites are missing/empty

noreply@blogger.com (Unknown) — Wed, 19 Sep 2007 21:17:00 -0700

If u familiar with registry maybe u can try this.. i just found from internet..

Internet Explorer Favorites are missing/empty

When you click the Favorites menu in Internet Explorer, all of your favorite URLs may be missing. This might happen if the Favorites Shell Folder is set incorrectly. Open Registry Editor and navigate to:

For Windows XP

[HKEY CURRENT USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders]

Set the Favorites path to %USERPROFILE%\Favorites

The above should be a REG_EXPAND_SZ value, not REG_SZ

The Favorites Shell Folders path reverts back ?

Sometimes, the Shell Folders path for Favorites may revert to the previous setting. To prevent that, read below:

Checkpoints:

If you've only altered the "Shell Folders" value, it usually reverts back (in accordance to the User Shell Folders value). You need to alter the Favorites path in User Shell Folders key.

If you're using an environmental variable such as "%Userprofile%", you need to create a REG_EXPAND_SZ value type, rather than REG_SZ. Also, note that REG_EXPAND_SZ type can accept either formats.

Disable any browser / favorites management software provided by your ISP and reset the Shell Folders as above. If it does not help, see if the *.URL files exists in the hard drive by doing a file search. They may be present in a different folder. Example.. Earthlink's software...Courtesy of MS-MVP Alan Edwards.

[Related Information]

How to Recall an E-mail in Microsoft Outlook

noreply@blogger.com (Unknown) — Wed, 19 Sep 2007 21:13:00 -0700

Instructions

STEP 1: Go to the Sent Items folder in Outlook and open the message you want to recall.
STEP 2: Click on Recall This Message in the Tools menu.
STEP 3: If your message hasn't already been opened by the recipient, either delete the message or replace it with a new message.
STEP 4: If there are multiple recipients, you can request notification of whether the recall succeeded or failed for each one (at least you'll know whom to apologize to). Even if you successfully recall a message, the recipient may still know that you sent a message and then recalled it. So if you didn't replace it with a corrected message, you'll need to get your story straight as to why you recalled it.

Overall Tips & Warnings

Never send "loaded" e-mail messages immediately after you write them. Save them in a draft folder, then review them one more time before sending. Some e-mail programs also let you queue messages so that they're sent after a slight delay.