This is a great freeware site for icons for sites http://famfamfam.com/lab/icons/
2 of the sets are available here:
Unlike Sharepoint 2007 which required that it be installed on a Windows Server product
(2003 or 2008), Sharepoint 2010 can be installed on Windows Vista or Windows 7 as
long as they are x64 versions. This is great for developers and for those who
just want to learn more about the product.
It takes a few steps but I got it working on Windows 7 using these instructions:
http://msdn.microsoft.com/library/ee554869(office.14).aspx
This is a nice site for free fonts: http://www.fontsquirrel.com/
This is kind of a basic overview of how to create a class file in VB.NET and use it in your Web application.
Here is the code for the CallHistory class. Notice where the file needs to be located in the application.
Imports Microsoft.VisualBasic Imports System.Data Imports System.Data.SqlClient PublicClass CallHistory PublicSub AddCallHistory(ByVal ReviewID AsInteger, ByVal UserID AsInteger, ByVal EventName AsString) Dim strSQLConn As SqlConnection Dim cmd As SqlCommand
strSQLConn = New SqlConnection(ConfigurationManager.ConnectionStrings("CCMConnectionString").ConnectionString)
cmd = New SqlCommand("p_AddCallHistory",
strSQLConn) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue("@ReviewID",
ReviewID) cmd.Parameters.AddWithValue("@UserID",
UserID) cmd.Parameters.AddWithValue("@DateChanged",
Now()) cmd.Parameters.AddWithValue("@EventName",
EventName) Try strSQLConn.Open() cmd.Connection = strSQLConn
cmd.ExecuteNonQuery() Finally strSQLConn.Close() EndTryEndSubEnd Class
Now we can use this class anywhere in our web application using the following technique.
First import our CallHistory namespace
<%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="CallHistory" %>
Next, we create an instance of the class:
'Add the call to the CallHistory table
Dim newCallHistory AsNew CallHistory
then we call the method
newCallHistory.AddCallHistory(ReviewID, lblUserID.Text, "Call
Added")
I’ve been using the Microsoft Ajax CDN for a while but didn’t know that they had an official page for it. Includes not only links to jQuery but also to jQuery UI, jQuery Validate, jQuery Mobile and Modernizr.
http://www.asp.net/ajaxlibrary/cdn.ashx#Modernizr_Releases_on_the_CDN_6
Here is an example of how to call these files from the CDN:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="TestjQueryUICDN.WebForm1" %> <!DOCTYPE html > <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Using jQuery UI from the CDN</title> <link rel="Stylesheet" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.10/themes/redmond/jquery-ui.css" /> </head> <body> <form id="form1" runat="server"> <div> <asp:TextBox ID="txtStartDate" ClientIDMode="Static" runat="server" /> </div> </form> <script src="http://ajax.aspnetcdn.com/ajax/jquery/jquery-1.5.js"></script> <script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.10/jquery-ui.js"></script> <script> $("#txtStartDate").datepicker(); </script> </body> </html>
Suppose you have a SQL Server stored procedure that returns multiple result sets and you want to store all these results into another table.
CREATE
procedure [dbo].[mytest] asselect 1 as id, 'test1'as myname select 2 as id, 'test2'as myname
When you execute this procedure, it returns two result sets. The following code will copy these two result sets in a table variable.
declare @t table(id int, namesvarchar(100))
insert into @t exec mytest select * from @t
http://csvexpress.expressor-software.com/
Some cool software to move CSV data around to different databases.
Microsoft has updated their browser definition files http://stephenwalther.com/blog/archive/2010/03/05/use-asp.net-4-browser-definitions-with-asp.net-3.5.aspx
Another related article:
http://visualstudiomagazine.com/articles/2011/11/14/recognizing-mobile-browsers.aspx
I work from home full-time and I often need to print and sign documents and then scan
them back to as a PDF. There are many solutions you can pay for but I found
a free one which involves iCopy and CutePDF.
iCopy: http://icopy.sourceforge.net/?page_id=40
CutePDF: http://www.cutepdf.com/
SELECT * FROM Employees
SELECT * FROM EmployeeHistory
If table Employees has a one to many relationship with EmployeeHistory and you need
to find any missing records from EmployeeHistory, then you could run the two queries
above and compare them side-by-side but this pretty tedious and kind of dumb.
A better way is to run an unmatched query. A left outer join of the Employee table
to the EmployeeHistory table on the EmpID field will get all matching and non-matching
records. To look for every record where the Employee table does not have a matching
record in the EmployeeHistory table, we look for a null in the EmployeeHistory table.
SELECT E.* FROM Employees LEFTOUTERJOIN EmployeeHistory
EH ON E.EmpID = EH.EmpID WHERE EH.EmpID IS NULL
Similarly, to insert the missing record into the EmployeeHistory table, you could do this:
INSERT INTO EmployeeHistory SELECT E.* FROM Employee E LEFTOUTERJOIN EmployeeHistory EH ON E.EmpID = EH.EmpID WHERE EH.EmpID IS NULL