If you are unable to access all jnlp files on your site, chances are that the myme type for jnlp files is not defined in IIS.On your site you need to add a new Mime Type using:Extension: .jnlpMime Type: application/x-java-jnlp-fil... this helps ......

---

select * FROM information_schema.tables where table_schema='YourSchema' ......

---

When you are inserting into a table using entity framework, on rare occasions you might get the following error: {System.Data.OptimisticConc... Store update, insert, or delete statement affected an unexpected number of rows (0) This happened to me because of an "instead of INSERT" trigger that was active on the page. It turns out that ......

---

Restoring a database can be a pain in the ass, specially when you need to find some point in time where the data went wrong.This is the best way i know how:RESTORE DATABASE MY_TARGET_DATABASE FROM DISK = 'path_to_backup.bak' WITH NORECOVERY, replaceGORESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log1.trn' WITH NORECOVERYGORESTORE LOG MY_TARGET_DATABASE ......

---

DataView view = new DataView(table);DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...); Source: http://stackoverflow.com/qu... ......

---

Simple and direct:

myContainer.myEntity.Where("it.myField LIKE '%' + @searchTerm + '%'", new ObjectParameter("searchTerm", myQueryText));

---

If you have a "{" or "}" inside a string when using string.format you will get the error mentioned in the title. To fix this you must double the charater. Error Example: string teste = string.Format(" This is a {teste} {0} ", mystring); Correct Example: string teste = string.Format(" This is a {{teste}} {0} ", mystring);v ......

---

In global.asax: protected void Application_BeginRequest(Ob... sender, EventArgs e) { HttpRuntimeSection runTime = (HttpRuntimeSection)WebConf... //Approx 100 Kb(for page content) size has been deducted because the maxRequestLength proprty is the page size, not only the file upload size int maxRequestLength ......

---

<script type="text/javascript" language="javascript"> Sys.WebForms.PageRequestMan... function refresh() { //Your code here; } </script> Source ......

---

/* Processes that are blocking others */ select * from sysprocesses where spid in ( select blocked from syslocks l inner join sysprocesses p on p.spid=l.spid where p.dbid=5 -- Database ID and p.blocked<>0 ) /* Processes being blocked*/ select p.* from syslocks l inner join sysprocesses p on p.spid=l.spid where p.dbid=5 and p.blocked<>0 ......

---