Archive

Archive for April, 2009

Sockets: How to get remote IP with TcpClient

April 22nd, 2009 No comments
tcpclient.Client.RemoteEndPoint.ToString();
VN:F [1.9.18_1163]
Rating: 5.0/5 (1 vote cast)
Categories: C#, DOTNET

Free eBooks from Microsoft Press again

April 21st, 2009 No comments

 

 

Offer ends on 22nd April!

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: News

MS Office SharePoint Designer 2007 Beginners Help Topics

April 21st, 2009 No comments
Categories: ASP.NET, Web Design

Tool: ScreenScale

April 14th, 2009 No comments

Just uploaded my newly developed hobby tool “Screen Scale” which is an on-screen ruler tool useful for the designers and developers for checking the positioning of controls. Features of this version are:

  • Size up to width/height of the screen
  • Transparency
  • Marking center
  • Horizontal and Vertical rulers
  • Multiple Scales
  • Lens (for zoom)
  • Pixel notation in ruler
  • Hide to System Tray

 

The tool is programmed on C# under Visual Studio 2008. Contact me if somebody need the source code. Here is a screenshot:

 

Download Here: http://kidoos.net/media/p/484.aspx

VN:F [1.9.18_1163]
Rating: 5.0/5 (2 votes cast)
Categories: General

A Day in a Geek’s Life

April 9th, 2009 No comments

The company’s resident IT professional extraordinaire has just returned from a much-deserved vacation but, in a temporary spell of relaxed judgment, has jeopardized their reputation with a poorly placed email and forwarded personal holiday snaps to the entire staff. Now they have to excavate through the email chain to find the offending photos – all while keeping the office online.

In Server Quest II, the sequel to last year’s pixellated adventure, players must hone their technical prowess in order to prove once and for all why the tech pros take the cake.  From software support to sidequests, players will get behind the curtain and live the life of a server genius fighting for respect.

 

Go Now! – http://www.microsoft.com/click/serverquest/

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: News

Top 10 users on CommunityServer

April 7th, 2009 No comments

This code will give you top 10 posters of Community Server application. Add this in /Themes/yourtheme/Common/home.aspx so that the list will be displayed in home page.

<%
	SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter("select top 10 postauthor, count (*) as posts from cs_posts group by postauthor order by posts desc", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
 
	foreach (DataRow dr in dt.Rows)
        {
		Response.Write("<li> <a href="http://kidoos.net/members/&quot;+dr[&quot;postauthor&quot;].ToString()+&quot;/default.aspx">" + dr["postauthor"].ToString().Substring(0, 1).ToUpper() + dr["postauthor"].ToString().Substring(1,dr["postauthor"].ToString().Length-1)  +" ("+dr["posts"].ToString()+")</a>");
 
        }
 
        con.Dispose();
        da.Dispose();
        dt.Dispose();
 
%>
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: ASP.NET, C#, Code Snippets

SharePoint designer now available for FREE

April 6th, 2009 No comments

After 01 April 2009, Microsoft SharePoint Designer will be available for download as free.

Download here!

 

VN:F [1.9.18_1163]
Rating: 3.0/5 (1 vote cast)
Categories: News

Quick fix for websites which breaks in IE8

April 6th, 2009 No comments

I am sure you noticed the issues (mainly design breaks) in IE8 of your old websites. Here is a quick fix for that websites. But I recommend you to fix the issues so that it will be compatible with Internet Explorer 8 also. Because IE8 is an industry compliant browser which utilises maximum of CSS 3.0.

Add this tag in your web pages:

<meta content="”IE=EmulateIE7?" http-equiv="”X-UA-Compatible”" />

Check this for more details: http://support.microsoft.com/kb/956197

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: Web Design

Monitor your filesystem for changes in real time in .NET

April 3rd, 2009 No comments

Here is a simple C# code which demonstrates usage of FileSystemWatcher. This uses minimum code

 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
 
namespace fswatch
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
	    // sample folder which willl be monitored            
            FileSystemWatcher fsw = new FileSystemWatcher(@"C:\Users\Pits\Desktop\testdir"); 
 
 
            // Event declarations. I point all events to a single method
            fsw.Created += new FileSystemEventHandler(fsw_Method);
            fsw.Renamed += new RenamedEventHandler(fsw_Method);
            fsw.Deleted += new FileSystemEventHandler(fsw_Method);
            fsw.Changed += new FileSystemEventHandler(fsw_Method);
 
            // Instruct the system to report events
            fsw.EnableRaisingEvents = true;
        }
 
        private void fsw_Method(object sender, FileSystemEventArgs e)
        {
            MessageBox.Show("Action:"+e.ChangeType.ToString()+". Name: " + e.Name);
        }
    }
}
VN:F [1.9.18_1163]
Rating: 2.5/5 (2 votes cast)
Categories: C#

What is the maximum size MSSQL and MySQL can support?

April 1st, 2009 No comments

What is the maximum size a Microsoft  SQL Server database can be? – SQL Server 2008

Microsoft SQL Server database size depends on which edition you use. Check the below table. I take MSSQL 2008 for reference:

Edition DB Size
Enterprise Unlimited
Standard Unlimited
Workgroup Unlimited
Web Unlimited
Developer Unlimited
Express 4 GB
Compact 3.5 4 GB

Even though it says unlimited, be careful about the drive size ;)

 

What is the maximum size a MySQL Server database can be? – MySQL 5.x.x

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Check if what size your folder supports.

This table gives you idea:

Operating System File-size Limit
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)
Linux 2.4+ (using ext3 file system) 4TB
Solaris 9/10 16TB
MacOS X w/ HFS+ 2TB
NetWare w/NSS file system 8TB
VN:F [1.9.18_1163]
Rating: 4.3/5 (4 votes cast)
Categories: SQL