VSTS Issues and Solutions

1. Test Case is Non-Runnable
A. Make the class public in which test case is present.

2.

How to restore the ToolBox in VisualStudio 2008

Here are the steps to get your items back. Navigate to C:\Users\\AppData\Local\Microsoft\VisualStudio\9.0 (on Vista or Longhorn) or “C:\Documents and Settings\\Local Settings\Application Data\Microsoft\VisualStudio\9.0” (older Windows versions) from a command prompt or in explorer (you may need to configure explorer to show hidden folders: Tools -> Folder Options -> View -> check Show hidden files and folders). Here, just delete these files:

· toolbox.tbd

· toolboxIndex.tbd

· toolbox_reset.tbd

· toolboxIndex_reset.tbd

Then restart VS 2008 and the toolbox should look normal again. Same steps apply to VS 2005 (just replace 8.0 with 9.0 in the path)

http://blogs.msdn.com/oanapl/archive/2008/06/08/visual-studio-2008-missing-items-from-toolbox.aspx

How to conevert Hex value into integer format

Following any of the convertions will work if we want to convert HEX value into Int value in SQL


select
convert(int,CONVERT(binary(4),'0x99CCFF',1)),
convert(int,CONVERT(binary(4),'0x0099CCFF',1)),
convert(int,0x0099CCFF),
convert(int,0x99CCFF)


SQL Server Analysis Services Issues and Solutions

While browsing the cube in BIDS the following error message is displayed.

No connection could be made because the target machine actively refused it 127.0.0.1:2383

Solution: Build and Deploy the cube.

How to identify SQL Server Database file location

If you want to know where exactly the database files or stored for each database using T-SQL. You can use the following query
This will work on Both SQL Server 2005 and Sql Server 2008


SELECT name AS [Database Name], physical_name AS [File Location]
FROM sys.master_files


DBCC commands

• dbcc useroptions -- This command is used to display the current user settings for that connection
• 
  

select * from sys.dm_exec_sessions

This displays all the user sessions connected to the sql server and different options made with the session.

How to rename all the file extensions in a folder

Open a command/cmd window
navigate to the folder
type the following command
rename *.originalextension *.newextension
Example: To cange all jpg file extensions to gif extensions. You can use the following command.
rename *.jpg *.gif
Modify the values originalextension and newextension as required.
You can save this command in a batch file and execute in the respective folders.

ASP.NET usefull links in development

Developing WebBrowser using C#.Net or working with WebBrowser control in .Net
http://www.devx.com/codemag/Article/20145/0/page/4
http://www.dotnetcurry.com/ShowArticle.aspx?ID=49&AspxAutoDetectCookieSupport=1

SQL Server 2008 Service Pack 1 Released

You can download SQL Server 2008 SP1 from the following location.
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

Asp.Net Errors and Resolution

1. Sys.WebForms.PageRequestManagerServerErrorException: Exception has been thrown by the target of an invocation.
When used updatePanel and fileupload controls a client side message displays as above.

To resolve this issue follow the following instructions. orginal link
http://forums.asp.net/p/1100270/2468298.aspx#2468298


<triggers>
<asp:postbacktrigger controlid="fileUpload1">
</triggers>
This works perfect whenever the FileUpload control is a child control of the UpdatePanel's ContentTemplate.However when the FileUpload control is a child control of e.g. a DetailsViews, which is a child control of the UpdatePanel's ContentTemplate, we should not postback the FileUpload control but it's container.
So in this case you would have to postback the DetailsView by using it's ID.

<triggers>
<asp:postbacktrigger controlid="detailsView1" />
</triggers>


How to Send email from ASP.NET

In the web.config file add the following configuration

<system.net>
<mailSettings>
<smtp from="yourmailid@domain.com">
<network host="localhost" port="25" />
</smtp>
</mailSettings>
</system.net>

In the ASP.NET code

try
{
System.Net.Mail.SmtpClient Client = new System.Net.Mail.SmtpClient();
Client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.PickupDirectoryFromIis;
Client.Send("Frommailid@domin.com", "tomailid@domain.com", "Mail Sumbjet", "Mail Body");
}
catch (Exception ex)
{
Response.Wrire(ex.Message.ToString());
}