Wednesday, October 10, 2007

how can I display tooltip in cell at excel

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

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

Thursday, September 27, 2007

Error Message: 8447: Internet Server Error

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

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”

Friday, September 21, 2007

How to set proxy at regedit for IE

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.

Wednesday, September 19, 2007

How to download video from YouTube

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

    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

    Dim activityId As Integer

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

    Internet Explorer Favorites are missing/empty

    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

    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.