Database

cmd.CommandText = searchSqlstr;

try
{
	return Convert.ToInt64(cmd.ExecuteScalar());
}
finally
{
	connection.Close();
}

using (SqlConnection connection = new SqlConnection(connString))
{
	connection.Open();

	try
	{
		SqlCommand cmd = connection.CreateCommand();
		cmd.CommandType = CommandType.Text;
		cmd.CommandText = searchSqlstr;
		return Convert.ToInt64(cmd.ExecuteScalar());
	}
	// Put a catch{} block here, if you need one
	finally
	{
		connection.Close();
	}
}

using (SqlConnection connection = new SqlConnection(connString))
{
	connection.Open();

	SqlCommand cmd = connection.CreateCommand();
	cmd.CommandType = CommandType.Text;
	cmd.CommandText = searchSqlstr;
	return Convert.ToInt64(cmd.ExecuteScalar());
}

SELECT * FROM user WHERE clue IS NOT NULL<br />
GO

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog

insert table3(email)
select distinct email from table1
union
select distinct email from table2

CalendarSpan
============
CalendarSpanId    INTEGER     --AutoNumber(Identity) primary Key
TimeOrder         INTEGER     --The order of when this Era/Age occurs (0=Earliest)
Era               TEXT(30)    --The Era 
Age               TEXT(30)    --The Age within the Era

GROUPS
|----CATEGORIES
     |----SKILLS
          |----SUBSKILLS  

SKILLSINAGES
=================
SkillInAgesId - Primary Key
AgeCode
SubSkillCode

SELECT
		...
FROM
		(
			(
				(
					CATEGORYGROUPS AS cg
					LEFT JOIN CATEGORY AS c
						ON cg.GroupCode = c.GroupCode
				)
				LEFT JOIN SKILLS AS s
					ON (c.CategoryCode = s.CategoryCode)
					AND (c.GroupCode = s.GroupCode)
			)
			LEFT JOIN SUBSKILLS AS ss
				ON (s.GroupCode = ss.GroupCode)
				AND (s.CategoryCode = ss.CategoryCode)
				AND (s.SkillCode = ss.SkillCode)
		)
		LEFT JOIN SKILLSINAGES sia
			ON (cg.GroupCode = sia.GroupCode)
			AND (c.CategoryCode = sia.CategoryCode)
			AND (s.SkillCode = sia.SkillCode)
			AND (ss.SubSkillCode = sia.SubSkillCode)
WHERE
		...

SELECT
		...
FROM
		CATEGORYGROUPS AS cg
		LEFT JOIN CATEGORY AS c
			ON cg.GroupCode = c.GroupCode
		LEFT JOIN SKILLS AS s
			ON (c.CategoryCode = s.CategoryCode)
			AND (c.GroupCode = s.GroupCode)
		LEFT JOIN SUBSKILLS AS ss
			ON (s.GroupCode = ss.GroupCode)
			AND (s.CategoryCode = ss.CategoryCode)
			AND (s.SkillCode = ss.SkillCode)
		LEFT JOIN SKILLSINAGES sia
			ON (cg.GroupCode = sia.GroupCode)
			AND (c.CategoryCode = sia.CategoryCode)
			AND (s.SkillCode = sia.SkillCode)
			AND (ss.SubSkillCode = sia.SubSkillCode)
WHERE
		...