Software Bugs and Solutions: August 2012

Friday, 31 August 2012

Sql script to find invalid email addresses

SELECT * FROM students WHERE email NOT LIKE '%_@__%.__%'

Tuesday, 28 August 2012

update two tables in one statement in SQL

UPDATE Table1

SET Table1.LastName = 'XXXXXX'

FROM Table1 T1, Table2 T2

WHERE T1.id = T2.id

and T1.id = '01'

Handle Errors in Global.asax

Let us see an example of how to use the Global.asax to catch unhandled errors that occur at the application level.

To catch unhandled errors, do the following. Add a Global.asax file (Right click project > Add New Item > Global.asax). In the Application_Error() method, add the following code:

void Application_Error(object sender, EventArgs e)

{

// Code that runs when an unhandled error occurs

Exception objErr = Server.GetLastError().GetBaseException();

string err = "Error in: " + Request.Url.ToString() +

". Error Message:" + objErr.Message.ToString();

}

VB.NET

Sub Application_Error(ByVal sender As Object, ByVal e As EventArgs)

' Code that runs when an unhandled error occurs

Dim objErr As Exception = Server.GetLastError().GetBaseException()

Dim err As String = "Error in: " & Request.Url.ToString() & ". Error Message:"& objErr.Message.ToString()

End Sub

Here we make use of the Application_Error() method to capture the error using the Server.GetLastError().

Friday, 24 August 2012

The underlying connection was closed: The connection was closed unexpectedly.” While returning Data Table from WCF service.

I have changed my operation Contract to return Dataset Instead of Data Table

[OperationContract]

DataSet LoadBatchInformation(string Batch);

Tuesday, 21 August 2012

Fixing innerHTML IE9

var newdiv = document.createElement("div");

newdiv.innerHTML = "This is for test" ;

var container = document.getElementById("container");

container.appendChild(newdiv);

Saturday, 18 August 2012

Get Drive Space information in sql

exec xp_fixeddrives

Friday, 17 August 2012

Code Execution Time using Stop watch

using System.Diagnostics;

using System.Threading;

............

Stopwatch stopWatch = new Stopwatch();

stopWatch.Start();

//instead of this there is line of code that you are going to execute

Thread.Sleep(1000);

stopWatch.Stop();

// Get the elapsed time as a TimeSpan value.

TimeSpan ts = stopWatch.Elapsed;

string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",

ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10);

Console.WriteLine(elapsedTime);

Console.ReadLine();

Monday, 6 August 2012

Permission to access the folder in iis

1) IUSR

2) IIS_IUSRS

3) NETWORK SERVICE

Sunday, 5 August 2012

Get the value from input control of html

string text =Request["txt"];

how to get last record value in sql server without using MAX/TOP clause?

1)SELECT * FROM tablename WHERE primarykeyid= IDENT_CURRENT('tablename')

Eg:

SELECT * FROM tbl_emp WHERE empid= IDENT_CURRENT('tbl_emp ')

set rowcount 1

select * from tbl_emp order by empid desc

SET ROWCOUNT { number | @number_var }

Causes SQL Server to stop processing the query after the specified number of 
rows are returned.

Enable compatibility mode for IE in C#

<html>

<head>

<title>My webpage</title>

</head>

<body>

<p>Content goes here.</p>

</body>

</html>

Now it'll try IE9 mode first, IE8, then IE7. You can even set IE=EDGE so it'll use the highest mode possible.

The X-UA-Compatible header is not case sensitive; however, it must appear in the header of the webpage (the HEAD section) before all other elements except for the title element and other meta elements.

http://msdn.microsoft.com/en-us/library/cc288325%28v=vs.85%29.aspx

Manually