Skip to main content

Posts

Showing posts from 2008

HOW TO CURRENT EXCELL FILENAME IN EXCEL SHEET

Every one want to learn or have to learn for the sake of job little tactics in differenct applications or softwares.

This article is written to tell you that how can you get the excel filename in excel sheet which you are viewing so you come to know that on which partition of harddisk the file is stored. Here is the simple formula.

=CELL("filename")

Just write this in your excel sheet and you will get the filename and its complete path along with its sheet name in result.

Access to the path 'path' is denied.

This problem is rear but create big problem sometime for novice as well professional programmers. The simple solution to resolve the issue is written below:

1) Goto c:\inetpub\wwwroot\your_folder_name.

2) Go to properties of your_folder_name by right clicking on your folder.

3) Inside Properties, you will see a Security Tab.

4) Click on Security Tab and assign Full Control to EveryOne Role.

That's all!.... Now open your file again in browser and see that you have resolved the problem.

Note: I have write c:\inetpub because my windows directory is C Drive. If you have installed your windows in another Drive then write Drive\inetpub\wwwroot\your_folder_name.

Wish you all the best.

The credentials supplied conflict with an existing set of credentials

Explanation:Credentials are a username/password combination. In this case, you already have a logon session started with a set of credentials and have tried to start another session between the same computers, using the same set of credentials.User Action: Either end the existing session, or log on with a different set of credentials. Note that this message may not be caused by anything you did at the user interface, but can be caused by a running application (applications can log on as users). In that case, contact the supplier of the running application.

How To Add The File Name and Path to the Header or the Footer in MS Word

To add the file name and path to the header or the footer in a Word document, follow these steps: 1.On the View menu, click Header and Footer.

The header is outlined by non-printing dotted lines.

NOTE: If you want to add the file name and path of your document to the footer, click Switch Between Header and Footer on the Header and Footer toolbar.2.Click Insert AutoText on the Header and Footer toolbar, and then click Filename and path. To insert the file name and path into the body of a Word document, point to AutoText on the Insert menu, point to Header/Footer, and then click Filename and path.

How do I stop people from posting spam messages on yahoo group?

If you are group owner or a moderator with the assigned privilege, you can change the settings so that all new messages have to be moderated. Then you would have to approve them all before they can be posted to your group.

Go to Management->Group Settings ->Messages->Posting and Archives (click Edit)->Posting Options (In the Moderation column, select Moderated.
Make sure to click Save Changes.

Your computer was joined to the domain using your computer old name because the following error has occurred. The directory service is busy.

To resolve this issue follow the given instructions.

1) Go to start menu and click on Run.

2) Type 'cmd' inside Run Window and click ok.

3) Command Prompt will open. Now write net use and Press Enter Button.

4) It will show all the shared drives. If there is any shared resource shown then first disconnect it.

5) After disconnecting the drives come back to Command Prompt and write net use */delete.

6) Now join it back to the domain and all the hurdles are gone.

I hope that this solution will help you as it resolve my issue.

Multiple connection to a server or shared resource by the same user, using more than one username, are not allowed. Disconnect all previous connection

To resolve this error follow these instructions.

1) Look at the sessions that are simultaneously running. On a Windows machine, Run -> ‘net use’. This will list all the connections.2) Ensure that you dont access the shared drive when the program is running.(to avoid starting a new connection)3) Delete all the connections to the storage. Better still, do a ‘net use * /delete’I hope that this will resolve the issue as it happens with me.

ACCESS MODIFIERS IN .NET

publicThis makes the member visible globallyEg. class Gremlin { public Gremlin spawn() { return new Gremlin(); } }
protectedThis makes the member visible to the current class and to child classes. Protected members are only accessible in the same class or through inherited classes.Eg. class ParentClass { protected int valueA; }
class ChildClass { public void doSomething() { valueA = 3; } }
privateThis makes the member visible only to the current class.Eg. class MyCollection { private int lastIndex; }
internal / FriendThis makes the member visible within the same assembly.Eg. internal class ProprietaryStuff { } protected internal / Protected FriendA combination of protected and internal. This makes the member visible within the same assembly and also makes the member visible to an inheriting class. An inheriting class does not need to be in the same assembly to access the member.

SQL TRANSACTION

The below code perform sql transaction in VB.NET. We can use this code in C# also by making only some changes.


Try
con.Open()
trans = con.BeginTransaction
com.Transaction = trans
com.Connection = con

strSql = "Insert into Departments values('005','ABC')"
db.Save(strSql, com)

strSql = "Update Departments set department_name='EF' where department_code='002"
db.Save(strSql, com)
trans.Commit()
Catch ex As Exception
MsgBox(ex.Message)
trans.Rollback()
Finally
con.Close()
End Try

STRING CASES

To Capitalize all the characters in a string we use:

ucase( string_name )

To make all the characters of a string Small Letters we use:

lcase( string_name )

To Capitalize first letter of string we use:

StrConv( string_name , VbStrConv.ProperCase)

MessageBoxButtons.YesNo

To interact with user before saving any record or performing a very important operation we can re ask him through dialog result by following the below method.

Dim Buttons As Integer = MessageBoxButtons.YesNo

Dim Result As DialogResult

Result = MessageBox.Show(Me, Message, Caption, MessageBoxButtons.YesNo, _
MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)


If Result = DialogResult.Yes Then
MessageBox.Show("You choosed Yes")
else
MessageBox.Show("You choosed No")
End If

Invalid KeyCodeV2.dll or KeyCodeV2.dll Not Found

The reason you are getting this error is because the machine that you are trying to run your application on does not contain the drivers Crystal Report needs to run. Here is your solution:

Finding Out What the Crystal Report Distribution Key is on VS.NET 2003:

1- Open VS.NET 2003
2- Click on Help Menu Option
3- Choose "About Microsoft Development Environment"
4- Look under Crystal Reports for Visual Studio .NET, you will see a 19 character number, which is the Distribution Key Code:

Example: AAA00-BB00000-C0000DD

Producing the Deployment Project:

Open Solution Explorer, right click on the “Solution Name” at the top and Add a New Project. On the window that appears, move to Setup and Deployment Projects. Click on Setup Project (not the wizard), put a name for your deployment project (make a note of the location where the folder that the deployment project will be created in) and then click OK. A File System dialog will appear – solution explorer should be displayed on the left of scr…

How to Use VLOOKUP or HLOOKUP to find an exact match

SUMMARY

The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table.

Note It is not necessary to sort the lookup table if you use the range_lookup argument correctly.


MORE INFORMATION

The syntax of these functions are defined as follows.


VLOOKUP Function

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)


where:

Argument Definition of argument
---------------------------------------------------------------------

lookup_value The value to be found in the first column of the array.

table_array The table of information in which data is looked up.

col_index The column number in the table_array for which the
matching value should be returned.

range_lookup It is a logical value that specifies whether
you want to find an exact match or an approximate match.
If TRUE or omitted, an approximate match is returned; in

How to Uninstall Symantec Antivirus If we Forget the Password.

I have faced this problem with a workstation inside my Network. Then I follow these steps to remove uninstall Symantec Antivirus.

1) Go to Registry (Regedit).

2) HKEY_LOCAL_MACHINE\SOFTWARE\INTEL\LANDESK\VIRUS PROTECTION\CURRENT VERSION\ADMINISTRATOR ONLY\USEVPUNINSTALLPASSWORD.

3) MODIFY/CHANGE VALUE FROM "1" to "0".

Refresh the registry and then Uninstall Symantec Antivirus. You will get what you want.

HOW TO CREATE AND WRITE A FILE IN VB.NET

Dim FILE_NAME As String = "C:\file2.txt"

If System.IO.File.Exists(FILE_NAME) = True Then

Dim fs As New FileStream(FILE_NAME, FileMode.Create, FileAccess.Write)
Dim s As New StreamWriter(fs)
s.WriteLine("Congrates you have created a new file")
s.Close()

ElseIf System.IO.File.Exists(FILE_NAME) = False Then

Dim fs As New System.IO.FileStream(FILE_NAME, FileMode.Create, FileAccess.Write)
Dim s As New System.IO.StreamWriter(fs)
s.WriteLine("Congrates you have created a new file")
s.Close()

End If

POLYMORPHISM, COMPILATION POLYMORPHISM AND RUNTIME POLYMORPHISM

Polymorphism is the core concept of OOP's. Polymorphism means one name many forms.

Types of polymorphism

Compile Time Polymorphism
Run Time Polymorphism


Compile Time Polymorphism
The compile time polymorphism, here the polymorphism is implemented during compile time, that means at the time of compilation the compiler knows where to bind the method. The compile time polymorphism can be implemented through:

Method Overloading
Operator Overloading


Method Overloading:
In complex applications written in C#, we may need many methods which do essentially similar functions but are just different enough to be considered unique. So, we can define method overloading as if two or three method in a class has same name but they differ by number of arguments or type of argument.

OperatorOverloading:
This provides a meaningful understanding of the operation by using operator overloading. Here what we did is we overload an operator and change its meaning, so that a valuable information is send…

KEYCODEV2.DLL NOT FOUND

This problem is occurred when you are using Crystal Reports in any of your project and have not installed VS.NET 1.x . As you install the full software of Visual Studio 1.x (2003) , it also install DLL's for Crystal Report. So, to solve this problem you have two solutions.

1) Install Visual Studio 2003.

2) Go to References in your project solutions and Follow these options:

a) Right Click on Add Reference.
b) Choose Projects tab in the windows of Add Reference.
c) Click on Browse Button and Select KeyCodeV2.Dll file from "C:\Program Files\Common Files\Crystal Decisions\1.0\Bin\keycodeV2.dll".

Add the file in your references and be happy because now the project will not give the KeyCodeV2 file error.

Happy Programming.

Hope my solution will help you in this regards. I have also solved it in this way.

Boxing and Unboxing in C# .Net

IntroductionIn this article I will explain the concepts of Boxing and UnBoxing. C# provides us with Value types and Reference Types. Value Types are stored on the stack and Reference types are stored on the heap. The conversion of value type to reference type is known as boxing and converting reference type back to the value type is known as unboxing.Let me explain you little more about Value and Reference Types.Value TypesValue types are primitive types that are mapped directly to the FCL. Like Int32 maps to System.Int32, double maps to System.double. All value types are stored on stack and all the value types are derived from System.ValueType. All structures and enumerated types that are derived from System.ValueType are created on stack, hence known as ValueType. Reference TypesReference Types are different from value types in such a way that memory is allocated to them from the heap. All the classes are of reference type. C# new operator returns the memory address of the object.Exa…

Invalid Report Source

The error message appears because the incorrect versions of the Crystal DLL files are referenced.

To correct this behavior reference the correct version of Crystal DLL files.


Adding the Correct References
-----------------------------

1. Open the VS .NET project.

2. In the 'Solution Explorer' window, right-click the 'References' folder and choose the 'Add Reference' command. The 'Add Reference' window appears.

3. Verify the References for all Crystal DLLs are version 9.1.5000. If they are not version 9.1.5000, select the 9.1.5000 version DLLs and click the 'Select' button.

4. Click the 'OK' button.

5. Save and run your application.


If running the application you find the DLLs revert to the version observed prior to your updates, complete the following steps:


Reverting DLLs Back to Version 9.1.5000
---------------------------------------

1. Right-click the project name in the solution explorer and select the 'Properties' command. The 'Pro…

.NET ACCESS MODIFIERS

There are Five Access Modifiers available in .NET. Following are the functionalities of these Modifiers.


TermUsed With…VisibilityPublicVariables/Properties/Methods/TypesAnywhere in or outside of a project


PrivateVariables/Properties/Methods/TypesOnly in the block where defined


ProtectedVariables/Properties/MethodsCan be used in the class where defined. Can be used within any inherited class.


FriendVariables/Properties/MethodsCan only be accessed by code in the same project/assembly.


ProtectedFriendVariables/Properties/MethodsCombination of Protected and Friend

HOW TOGET SECOND MINIMUM VALUES FROM TABLE IF VALUE HAVE MULTIPLE OCCURENCES.

I have build this query to get the 2nd minimum amount (salary) of employees no matter how much occurrences they have. I want to retrieve each occurrence of 2nd minimum amount. The following query gives me my desired result.


Select amount
From table2
where amount = ( Select distinct top 1 amount
from (Select top 2 amount
from table2
order by amount asc) a
order by amount desc )

FAILED TO LOAD CRYSTL32.OCX

Description:
This error is displayed when you have used reports in your projects and your reports are builds in Crystal Reports 8.5.

Reason:
Error is because of Crystal Report Viewer.

Solution:
Install Crystal Report 8.5 and problem solved

BC30560: 'CrystalReportViewer' is ambiguous in the namespace 'CrystalDecisions.Web'.

This error drove me crazy but I found the fix if anyone is interested:

On the HTML Behind the Form there are duplicate declarations for the Prefix tag:
<%@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %>

My error was caused by having one for version 10.x and this one for version 9.x
I deleted the one for version 10.x and the error went away.

What is a favicon?

What is a favicon?Notice the red “Y!” symbol that appears in the left-most area of the address bar in Internet Explorer graphic below. Look familiar? Yep, that’s Yahoo’s favicon. These favicons (favorites icons), sometimes called “bookmark icons,” appear after adding a website with a favicon to the favorites menu in Internet Explorer and certain other browsers.Favicons also appear in the favorites menu after a page is added. Most anyone who’s roamed the Internet and bookmarked sites of interest has noticed favicons showing up in the favorites menu like this:They also often appear in the Windows Start menu after installing a program as shown here:Creating a faviconA favicon should be 16 X 16 pixels with 16 colors and the file name should be favicon.ico. IconEdit32 is a good freeware program that allows you to create favicons as well as icons of other sizes and color depths. IrfanView is an excellent freeware image viewer that supports the icon (.ico) image format. You can use it to shr…

Purpose and Description of svchost.exe

File purpose and description:
svchost.exe is a program that would have arrived on your computer the day you purchased it. Always verify the exact disk location as shown below, since many spyware and virus writers attempt to fool you by using similiar or same names but locate the file in other folders. Svchost.exe is a program which is a critical windows program which monitors programs, manages dll's, and controls loading of system processes. You will find multiple occurances of this running. This will always be running and you cannot kill this task. This file is considered safe and is not spyware or virus related, however, make sure the file is not located at c:\svchost.exe, as many viruses and spyware programs have used this name to confuse you, and several viruses put this svchost name in your root directory which is not the proper location for this file. Also pay close attention that svchost is not spelled scvhost, as these are not the same but look so close its har…

Excel in Seperate Windows

Problem:

When I want to open up several excel files, they all go into the same
application. Is there any way I can set my computer up so that when I
click to open a file, it opens in its own window on the bottom bar. I
want to be able to alt-tab between windows. Currently, I have to go
to Window/then the file. any thoughts>??

Thanks.

Solution:

In Excel, Tools, Options, View, Checkbox for Windows in Taskbar.

OR

another option is using the "ctrl+F6" key which switches between documents,it is meant for doing just what you want to do.

HTTP REQUEST TAG

By Implementing httpruntime tag I solved a webservice problem. Problem was that a report was not displayed and show me a time out error. By implementing this problem was resolved.

<\httpRuntime> Element Configures ASP.NET HTTP runtime settings. This section can be declared at the machine, site, application, and subdirectory levels.<\configuration>
<\system.web>
<\httpRuntime>
maxRequestLength="size in kbytes"
executionTimeout="seconds"
minFreeThreads="number of threads"
minFreeLocalRequestFreeThreads="number of threads"
appRequestQueueLimit="number of requests"
versionHeader="version string"/> Optional AttributesAttributeOptionDescriptionappRequestQueueLimitThe maximum number of requests that ASP.NET will queue for the application. When there are not enough free threads to process a request, the requests are queued. Incoming reque…

Learn How to Write Good Documentation for your Software

The ideal software would be free of errors and so easy to use that everybody would be familiar with it the minute they start the application. However, this is not the case in real life.

Besides the quality of the software product, there’s something else that makes or breaks the deal: technical support. The better the support software publishers and shareware authors provide, the more users are likely to buy the product.

Technical support for software products can be provided in several ways: online product documentatione-mail assistanceaccess to support forums maintained by software publishersknowledge bases.Good documentation may exclude in many cases the need for further forms of technical support. It is, however, not easy to write. One of the reasons why this happens is that it is difficult for shareware authors or other software developers to put themselves into the users’ shoes, since they are already thoroughly familiar with the application.

Read Me file

The first thi…

Writing Good Software Documentation

Writing software documentation may seem extremely easy for some of us, whereas others may consider it one of the most difficult tasks they could ever be asked to do.

The generic term for this kind of writing is "technical writing". A person who does this job is generally referred to as a "technical writer", with quite extensive knowledge of software and technology and with a deeper understanding of the logic behind the software, or a "technical writer", a person who, although somewhat overwhelmed by all the denominations and the algorithms of the software, is accurate in producing a proper technical text.

Nevertheless, regardless of the orientation of the writers, be them more technical than writers, there are some things that need to be considered before, during and after the writing process.


Before Writing·Know the Software
Training
Make sure you receive proper training for the software that you are about to document and that you have the software …