Database

declare @num as int<br />
select @num = count(*) from Users where groupID = 10<br />
<br />
select top 100 username, address , @num from Users where groupID = 10

update location<br />
set tempareture=34<br />
where city='Athens';

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