C#

public bool ValidateNewUser(string strAlias, string strFirst, string strLast)
        {

            SqlConnection MyConn = new SqlConnection(ConfigurationSettings.AppSettings["MyOnlineShoppingConnectionString2"]);

            SqlCommand MyCmd = new SqlCommand("sp_CheckForDuplicates", MyConn);

            MyCmd.CommandType = CommandType.StoredProcedure;

            SqlParameter objParam1;
            SqlParameter objParam2;
            SqlParameter objParam3;

            SqlParameter objReturnParam;

            objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar);
            objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar);
            objParam3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar);
            objReturnParam = MyCmd.Parameters.Add("@Duplicates", SqlDbType.Int);
            objReturnParam.Direction = ParameterDirection.ReturnValue;

            objParam1.Value = strAlias;
            objParam2.Value = strFirst;
            objParam3.Value = strLast;

            try
            {
                if (MyConn.State == ConnectionState.Closed)
                {
                    MyConn.Open();
                    MyCmd.ExecuteNonQuery();

                    if (Convert.ToInt32(objReturnParam.Value) > 0)
                    {
                        lblResult.Text = "UserName already exists or you are already a registered user!";
                        return false;
                    }
                }
                else
                {
                    return true;
                } 

                MyConn.Close();
            }
            catch (Exception ex)
            {
                lblError.Text = "Error Connecting to Database!";
            }
        }

Adeel Chaudhry wrote:

Why not try out with System.IO.DriveInfo?

int pos = 0;
int left = data.Length;
while (left > 0) {
   int len = Math.Min(left, 1024);
   stream.Write(data, pos, len);
   pos += len;
   left -= len;
}