My Knowledge
All about my knowledge..
Wednesday, October 10, 2007
how can I display tooltip in cell at 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
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
CAUSE
• | The virtual directory for RDS in the Default Web Site has been removed. -OR- |
• | RDS was not installed properly. |
WORKAROUND
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. |
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:
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:
aspnet_regiis.exe –pdf “connectionStrings” “D:\Services”
Monday, September 24, 2007
Friday, September 21, 2007
How to set proxy at regedit for IE
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
How to Create Computer Sticky Notes With Outlook
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.